JDBC Driver Usage - Aqua Data Studio uses JDBC drivers to make database connections to the appropriate database. By default, Aqua Data Studio comes packaged with an appropriate JDBC driver for all supported databases. The included drivers work for most database versions and setups. In specific configurations you may be required to update the JDBC driver in your Aqua Data Studio installation with the latest driver from the database vendor. Below is a list of databases, the corresponding issues that may arise and the appropriate action to take to resolve the issue.

Apache Derby JDBC Driver - Apache Derby drivers included with ADS work with all versison of Apache Derby. There is no need to update this driver

Vendor: Apache DB Project
Driver URL: http://db.apache.org/derby/derby_downloads.html
Driver Location (Windows/Linux):
[ADS_INSTALL]\lib\drivers\derby.jar
[ADS_INSTALL]\lib\drivers\derbyclient.jar
[ADS_INSTALL]\lib\drivers\derbynet.jar
Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/drivers/derby.jar
/Aqua Data Studio/Contents/Resources/Java/drivers/derbyclient.jar
/Aqua Data Studio/Contents/Resources/Java/drivers/derbynet.jar

DB2 7.2 JDBC Driver - DB2 7.2 is the database which has the most connection issues. JDBC drivers for database version are not compatible, neither are they compatible across fixpacks. Updating your DB2 JDBC driver to the version which you are using is always a good idea. The DB2 Server installation provides JDBC drivers for the version and fixpack in use. You may copy the provided JDBC driver and overwrite the driver provided by ADS. You can copy the /sqllib/java/db2java.zip that comes with your installation and overwrite the /ADS_INSTALLATION/lib/drivers/db2java.jar file.

- NOTE: The DB2 7.2 JDBC driver does not connect directly to the DB2 Server, but to a proxy server which is installed with the DB2 Server. This proxy server can be started with the db2jstrt[.exe], which defaults to port 6789. The process is enabled by default in most installations.

Vendor: IBM
Driver URL: DB2 Server Installation ([DB2 Install]\java\db2java.zip)
Driver Location (Windows/Linux): [ADS_INSTALL]\lib\drivers\db2java.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/drivers/db2java.jar

DB2 8.1 - 9.x JDBC Driver - The DB2 JDBC drivers included with ADS work across all 8.x versions of DB2. There is no need to change or update this driver.

Vendor: IBM (JDBC Type 4 Driver)
Driver URL: http://www.ibm.com/support/us/
Driver Location (Windows/Linux): [ADS_INSTALL]\lib\drivers\db2jcc.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/drivers/db2jcc.jar

DB2 iSeries - IBM as400 JDBC Driver - The IBM as400 JDBC drivers included with ADS work across all iSeries versions of DB2. There is no need to change or update this driver.

Vendor: JTOpen
Driver URL: http://jt400.sourceforge.net/
Driver Location (Windows/Linux):
[ADS_INSTALL]\lib\drivers\jt400.jar
[ADS_INSTALL]\lib\drivers\util400.jar
Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/drivers/jt400.jar
/Aqua Data Studio/Contents/Resources/Java/drivers/util400.jar

Oracle JDBC Drivers - Oracle JDBC drivers provide compatibilty between different version of the Oracle server. Oracle JDBC/OCI drivers do not provide support between OCI libraries. The JDBC driver included with ADS supports native connections to Oracle 10g/9i/8i, but only OCI connections with the 10g client software. If you have the 8i/9i OCI client drivers installed on your machine and you would like to use them with ADS then you will need to install the Oracle 8i/9i JDBC driver, which has support for 8i/9i OCI libraries.

- For Oracle you can copy the /oraxx/jdbc/lib/classes12.jar that comes with your installation and overwrite the /ADS_INSTALLATION/lib/drivers/oracle.jar file.

Note OSX Installations: OCI Connections are not supported on OSX. There is no need to change or update the drivers on OSX.

Vendor: Oracle
Driver URL: [Free Registration Required] http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
Driver Location (Windows/Linux):
[ADS_INSTALL]\lib\drivers\oracle.jar
ADS_INSTALL]\lib\nlscharset12.jar
Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/drivers/oracle.jar
/Aqua Data Studio/Contents/Resources/Java/drivers/nlscharset12.jar

Microsoft SQL Server JDBC Drivers - The jTDS JDBC (v1.0) drivers included with ADS work across all versions of SQL Server. There is no need to change or update this driver.

Vendor: jTDS Open Source Project
Driver URL: http://sourceforge.net/project/showfiles.php?group_id=33291
Driver Location (Windows): [ADS_INSTALL]\lib\drivers\jtds.jar & [ADS_INSTALL]\ntlmauth.dll
Driver Location (Linux): [ADS_INSTALL]\lib\drivers\jtds.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/drivers/jtds.jar

PostgreSQL JDBC Drivers - The PostgreSQL JDBC (v8.0.401) drivers included with ADS work across all versions of PostgreSQL from 7.2 to 8.0. PostgreSQL server releases are frequent, and may sometimes require updating the JDBC driver.

Vendor: PostgreSQL
Driver URL: http://jdbc.postgresql.org/download.html
Driver Location (Windows/Linux): [ADS_INSTALL]\lib\drivers\postgresql.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/drivers/postgresql.jar

MySQL JDBC Drivers - The MySQL JDBC (v3.1.10) drivers included with ADS work across all versions of MySQL from 3.x to 4.1. MySQL server releases are very frequent, and may sometimes require updating the JDBC driver.

Vendor: MySQL
Driver URL: http://www.mysql.com/products/connector/j/
Driver Location (Windows/Linux): [ADS_INSTALL]\lib\drivers\mysql.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/drivers/mysql.jar

Sybase Anywhere JDBC Drivers - The Sybase Anywhere JDBC drivers included with ADS work across all versions of Sybase Anywhere from 7.0 to 9.0. There is no need to change or update this driver.

Vendor: Sybase (jConnect 6.0)
Driver URL: http://www.sybase.com/downloads
Driver Location (Windows/Linux): [ADS_INSTALL]\lib\drivers\jconnect60.jar.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/drivers/jconnect60.jar

Sybase JDBC Drivers - The Sybase JDBC drivers included with ADS work across all versions of Sybase from 11.0 to 12.5. There is no need to change or update this driver.

NOTE: For your Sybase JDBC driver to work properly, your Sybase server must have the latest EBT/Maintenance patches applied to them. The sql_server_xxx.sql scripts contain metadata required by the JDBC drivers.

Vendor: Sybase (jConnect 6.0)
Driver URL: http://www.sybase.com/downloads
Driver Location (Windows/Linux): [ADS_INSTALL]\lib\drivers\jconnect45.jar & [ADS_INSTALL]\lib\drivers\jconnect55.jar & [ADS_INSTALL]\lib\drivers\jconnect60.jar
Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/drivers/jconnect45.jar
/Aqua Data Studio/Contents/Resources/Java/drivers/jconnect55.jar
/Aqua Data Studio/Contents/Resources/Java/drivers/jconnect60.jar

Informix JDBC Drivers - The Informix JDBC drivers included with ADS work across all versions of Informix. There is no need to change or update this driver.

Vendor: IBM
Driver URL: http://www.iiug.org/home.html
Driver Location (Windows/Linux): [ADS_INSTALL]\lib\drivers\ifxjdbc.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/drivers/ifxjdbc.jar