Deploying JDBC clients

You must install a Java Runtime Environment to use JDBC. Version 1.6.0 or later is recommended.

In addition to a Java Runtime Environment, each JDBC client requires the iAnywhere JDBC driver or jConnect.

iAnywhere JDBC driver

To deploy the iAnywhere JDBC driver, you must deploy the following files:

  • jodbc.jar This must be in the application's classpath. This file is located in the SQL Anywhere installation java folder.

  • dbjodbc11.dll This must be locatable in the system path. On Linux and Unix environments, the file is a shared library called libdbjodbc11.so. On Mac OS X, the file is a shared library called libdbjodbc11.dylib.

  • The ODBC driver files. For more information, see ODBC driver required files.

jConnect JDBC driver

To deploy the jConnect JDBC driver, you must deploy the following files:

  • The jConnect driver files. For a version of the jConnect software and the jConnect documentation, see [external link] jConnect for JDBC.

  • When you use a TDS client (either Open Client or jConnect based), you have the option of sending the connection password in clear text or in encrypted form. The latter is done by performing a TDS encrypted password handshake. The handshake involves using private/public key encryption. The support for generating the RSA private/public key pair and for decrypting the encrypted password is included in a special library. The library file must be locatable by the SQL Anywhere server in its system path. For Windows, this file is called dbrsakp11.dll. There are both 64-bit and 32-bit versions of the DLL. On Linux and Unix environments, the file is a shared library called libdbrsakp11.so. On Mac OS X, the file is a shared library called libdbrsakp11.dylib. The file is not necessary if you do not use this feature.

JDBC database connection URL

Your Java application needs a URL to connect to the database. This URL specifies the driver, the computer to use, and the port on which the database server is listening.

For more information about URLs, see Supplying a URL to the driver.