Using the jConnect JDBC driver

SQL Anywhere supports one version of jConnect: jConnect 6.0.5. The jConnect driver is available as a separate download at [external link] http://www.sybase.com/products/allproductsa-z/softwaredeveloperkit/jconnect. Documentation for jConnect can also be found on the same page.

If you want to use JDBC from an applet, you must use the jConnect JDBC driver to connect to SQL Anywhere databases.

The jConnect driver files

SQL Anywhere supports the following version of jConnect:

jConnect 6.0.5 This version of jConnect is for developing JDK 1.4 or later applications. jConnect 6.0.5 is JDBC 3.0 compliant. jConnect 6.0.5 is supplied as a JAR file named jconn3.jar.

Note

This documentation assumes that you are developing JDK 1.5 applications and using the jConnect 6.0.5 driver.

There is a copy of jconn3.jar in the install-dir\java folder. However, it is recommended that you use the version of the file included with jConnect 6.0.5 since it will be current with the version of jConnect that you have installed.

Setting the class file path for jConnect

For your application to use jConnect, the jConnect classes must be in your class file path at compile time and run time, so that the Java compiler and Java runtime can locate the necessary files.

The following command adds the jConnect 6.0.5 driver to an existing CLASSPATH environment variable (where path is your jConnect installation directory).

set classpath=path\jConnect-6_0\classes\jconn3.jar;%classpath%

Importing the jConnect classes

Encrypting passwords

Installing jConnect system objects into a database
Loading the jConnect driver
Supplying a URL to the driver

Discuss this page in DocCommentXchange.