Chapter 1. Quick Start
Index:
HXTT Paradox provides a type 4 JDBC driver for Paradox version from 3.0, 3.5, 4.x, 5.x, 7.x to 11.x. 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 JBuilder's Database Pilot, Oracle's JVM, JDeveloper 10G, Dreamweaver UltraDev, Dreamweaver ColdFusion, ObJectRelationalBridge, DBVisualizer, Sunopsis, MySQL Migration Toolkit, Tomcat, vqServer, Hibernate, SQuirreL SQL Client, and DbEdit Database Utilites for Eclipse Platform. It supports transaction, XOPEN SQLState, RMI, Jini, JNDI, and serialization. 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 Paradox packages are available here:
First, you need to download JDK 1.3.X, 1.4.X, or 1.5.X from www.javasoft.com if you use Paradox JDBC 3.0 package(Paradox_JDBC30.jar). You can download JDK1.2.X too if you use Paradox JDBC 2.0 package(Paradox_JDBC20.jar). You can download JDK1.1.X too if you use Paradox JDBC 1.2 package(Paradox_JDBC12.jar).
Secondly, please add Paradox_JDBC30.jar, Paradox_JDBC20.jar or Paradox_JDBC12.jar to your Java class path, for instance, "SET CLASSPATH=c:\javalib\Paradox_JDBC20.jar;%classpath%". You can also use "java -classpath c:\javalib\Paradox_JDBC20.jar yourParadoxclass" 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\Paradox_JDBC20.jar yourParadoxclass" too.
Thirdly, you can use 'Class.forName("com.hxtt.sql.paradox.ParadoxDriver").newInstance();' or Class.forName("com.hxtt.sql.paradox.ParadoxDriver");' 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 Paradox URL format below. If you were a Java novice, please
read also other Java examples code in Paradox_JDBC30demo.zip, Paradox_JDBC20demo.zip
or Paradox_JDBC12demo.zip.
Paradox URL format:
Embedded: jdbc:Paradox:[//]/[DatabasePath][?prop1=value1[&prop2=value2]] (You can omit that "//" characters sometimes) For example: "jdbc:Paradox:/." "jdbc:Paradox:/c:/data" "jdbc:Paradox:////usr/data" for unix or linux: "jdbc:Paradox:/./data" Remote Access: jdbc:Paradox://host:port/[DatabasePath] For example: "jdbc:Paradox://domain.com:3099/c:/data" if one ParadoxServer is run on the 3099 port of domain.com
Paradox 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.
Paradox driver will use index to speed up the query which contains some indexed expressions. Paradox driver doesn't index all deleted records, and supports utilizing index file for LIKE, BETWEEN, IN, and some OR operations.