start.html - HXTT DBF packages of type 4 JDBC1.2, JDBC2.0 and JDBC3.0 Drivers for dbase, Visual DBASE, SIx Driver, SoftC, Clipper, Foxbase, Foxpro, and VFP

Chapter 1. Quick Start

Index:

What Is the HXTT DBF?
Follow Me

HXTT DBF driver has become the best JDBC driver for Xbase database since 1999. It supports JDBC1.2, JDBC2.0, and JDBC3.0. It supports Personal Java, JDK1.0.X, JDK1.1.X, JDK1.2.X, JDK1.3.X, JDK1.4.X and JDK1.5.X. It supports dbase, Visual DBASE, SIx Driver, SoftC, Clipper, Foxbase, Foxpro, and VFP. It supports FlexFile3, SIxMemo, DB2K, IDX, CDX, NDX, MDX, NTX, and CGP. It supports DBF, DBC, DCT, DCX, DBT, FPT, SMT, and user-defined extensions. It supports all transactions level of READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. It supports Multi-user Access and Xbase applications' compatible lock. It supports Borland's BDE, JBuilder's Database Pilot, Oracle's JVM, JDeveloper 10G, Dreamweaver UltraDev, Dreamweaver ColdFusion, ObJectRelationalBridge, DBVisualizer, iSQL-Viewer, Sunopsis, MySQL Migration Toolkit, Tomcat, vqServer, Hibernate, SQuirreL SQL Client, and DbEdit Database Utilites for Eclipse Platform. It supports XOPEN SQLState, RMI, Jini, JNDI, and serialization. It supports all codepage, multilingual collation sequence, and unicode character set. It supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query , INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, CROSS JOIN, self join, and subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery. The current version of the HXTT DBF packages are available here:

Follow Me

First, you need to download JDK 1.3.X, 1.4.X, or 1.5.X from www.javasoft.com if you use DBF JDBC 3.0 package(DBF_JDBC30.jar). You can download JDK1.2.X too if you use DBF JDBC 2.0 package(DBF_JDBC20.jar). You can download JDK1.1.X too if you use DBF JDBC 1.2 package(DBF_JDBC12.jar).

Secondly, please add DBF_JDBC30.jar, DBF_JDBC20.jar or DBF_JDBC12.jar to your Java class path, for instance, "SET CLASSPATH=c:\javalib\DBF_JDBC20.jar;%classpath%". You can also use "java -classpath c:\javalib\DBF_JDBC20.jar yourDBFclass" to run your class. More information about classpath, please read the "Setting the Classpath" topic in file:///yourdriver|/jdk1.2/docs/tooldocs/tools.html . You can use "java -classpath c:\javalib\DBF_JDBC20.jar yourDBFclass" too.

Thirdly, you can use 'Class.forName("com.hxtt.sql.dbf.DBFDriver").newInstance();' or Class.forName("com.hxtt.sql.dbf.DBFDriver");' to load this driver.

Fourth, if you have used other JDBC driver, you only need to know the correct URL format for DriverManager.getConnection(url,"",""); You can find the DBF URL format below. If you were a Java novice, please read also other Java examples code in DBF_JDBC30demo.zip, DBF_JDBC20demo.zip or DBF_JDBC12demo.zip.
DBF URL format:


        Embedded:
                jdbc:DBF:[//]/[DatabasePath][?prop1=value1[&prop2=value2]] (You can omit that "//" characters sometimes)
                        For example:
                                "jdbc:DBF:/."
                                "jdbc:DBF:/c:/data"
                                "jdbc:DBF:////usr/data" 
                           for unix or linux:
                                "jdbc:DBF:/./data"
        Remote Access:
                jdbc:DBF://host:port/[DatabasePath]
                        For example: "jdbc:DBF://domain.com:3099/c:/data" if one DBFServer is run on the 3099 port of domain.com

Last, DBF driver is a standard JDBC driver so that you will find most of valuable information at file:///yourdrive|/jdk1.2/docs/api/java/sql/package-frame.html .

DBF supports SQL Minimum Grammar, which is a subset of the Entry level syntax of SQL-92. It supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query , INNER JOIN, FULL JOIN, LEFT JOIN, RIGHT JOIN, NATURAL JOIN, CROSS JOIN, self join, and subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery. The major syntax is listed at here.

DBF driver will use index to speed up the query which contains some indexed expressions. DBF driver doesn't index all deleted records, and supports utilizing index file for LIKE, BETWEEN, IN, and some OR operations.

File name is case sensitive on unix OS. For unix or linux, DBF will try to seek acquiescently dbf files with the suffixs like ".DBF" for the first time, and ".dbf" for the second time. If it failed to find out a suitable dbf file, it will try other mixture method. You can also use the full table name to quote your table. For instance, 'select * from "Test.dBf"'.