I download the 'DBF JDBC 2.0 Driver package' from and copy it into my classpath. But I cannot find its Driver name string using in Class.forName(). Yes, I tried to find another type 3 or type 4 JDBC driver for foxpro 2.6a. But I cannot find. HXTT DBF driver has become the best JDBC driver for Xbase database since 1999. HXTT DBF contains the only type 4 JDBC(1.2, 2.0, 3.0, 4.0, 4.1, 4.2) driver packages for Xbase database (dbase, Visual DBASE, SIx Driver, Alaska, SoftC, Codebase, CA-Clipper, PowerPlus, Foxbase, Foxpro, VFP(3.0,5.0,7.0,8.0,9.0),.
Caigen DBF JDBC Drivers for dbase, Visual DBASE, Clipper, Foxbase, Foxpro, and VFP Cagen DBF JDBC Driver v4.2 Documentation Index: • • • • • To put dbfdriver.jar into your class path, you should use 'export CLASSPATH=/usr/share/lib/dbfdriver.jar:$CLASSPATH' on Solaris and Linux, and 'SET CLASSPATH= javalib dbfdriver.jar;%classpath%' on Windows. Any source that uses JDBC needs to import the java.sql package by using ' import java.sql.*;'. Caigen DBF driver' name is com.caigen.sql.dbf.DBFDriver, and you can uses it without involving hard coding the driver into your code.
You do this by setting the jdbc.drivers system property. For example, for command line apps you can use: java -Djdbc.drivers=com.caigen.sql.dbf.DBFDriver yourApp Then, the JVM upon startup will load the drivers automatically. Some applications (JBoss, Tomcat etc) support a.properties file which they use to save putting this on the command line. The second method is the most common and involves you loading the driver yourself. It's simple: Class.forName('com.caigen.sql.dbf.DBFDriver'); From then on you can get connections from DriverManager. Note: If Class.forName() throws ClassNotFoundException, you should check your classpath.
Data Source class is com.caigen.sql.CaigenDataSource, and Connection Pool Data Source class is com.caigen.sql.CaigenConnectionPoolDataSource. After the driver has been registered with the DriverManager, you can obtain a Connection instance that is connected to a particular database by calling DriverManager.getConnection(). With JDBC, a database is represented by a URL (Uniform Resource Locator). Embedded: jdbc:dbf:[//]/[DatabasePath][?prop1=value1[;prop2=value2]] (You can omit that '//' characters sometimes) For example: 'jdbc:dbf:/.' 'jdbc:dbf:/c:/data' for Windows driver 'jdbc:dbf:///c:/data' for Windows driver 'jdbc:dbf:////usr/data' for unix or linux 'jdbc:dbf://///192.168.10.2/sharedir' for UNC path 'jdbc:dbf:/./data' Compressed Database:(.ZIP,.JAR,.GZ,.TAR,.BZ2,.TGZ,.TAR.GZ,.TAR.BZ2) jdbc url format is the same as embedded url and remote url. For example: 'jdbc:dbf:/c:/test/testdbf.zip Memory-only Database: jdbc:dbf:/_memory_/ URL Database:(http protocol, https protocol, ftp protocol) jdbc:dbf:jdbc:dbf:jdbc:dbf:ftp://ftpURL For example: 'jdbc:dbf://Note: FTP site's user/password should be set in ftpURL, and cannot be set in JDBC connection property because user/password JDBC connection property belongs to server/client connection. SAMBA Database:(smb protocol) jdbc:dbf:smb://[[[domain;]username[:password]@]server[:port]/[[share/[dir/]file]]][?[param=value]] For example: 'jdbc:dbf:smb://test1:firstname.lastname@example.org/dbffiles/zone' //Note: SAMBA user/password should be set in SMB url, and cannot be set in JDBC connection property because user/password JDBC connection property belongs to server/client connection.
UNC path JDBC url: jdbc:dbf:/uncpath jdbc:dbf:///uncpath For example: 'jdbc:dbf:/ PC17 c$ values' 'jdbc:dbf:/ PC17 val' Free JDBC url:(Warning: only use it for special project) jdbc:dbf:/' or 'jdbc:dbf:///'. Then you can use some full UNC path names in SQL to visit anywhere where your Java VM has right to access. For instance: select * from amd2500 e$ dbffiles test; elect * from ' amd2500 d$ dbfiles'.test; select * from '.' .test; Caigen DBF supports seamlessly data mining on memory-only table, physical table, url table, compressed table, SAMBA table in a sql. To connect, you need to get a Connection instance from JDBC. To do this, you use the DriverManager.getConnection() method: Connection con = DriverManager.getConnection(url, properties); There are a few different signatures for the getConnection() method.
You should see the API documentation that comes with your JDK for more specific information on how to use them. You can specify additional properties to the JDBC driver by placing them in a java.util.Properties instance and passing that instance to the DriverManager when you connect. Default Value user The user to connect as null password The password to use when connecting null charSet To specify a Character Encoding Scheme other than the client default. You can find a Supported Encodings list of file:///c /jdk1.2/docs/guide/internat/encoding.doc. F4u Keygen Maker 1.1 Free Download. html.