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.
|
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/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\db2java.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/db2java.jar
|
DB2 8.1 & 8.2 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\db2jcc.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/db2jcc.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/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\oracle.jar & [ADS_INSTALL]\lib\nlscharset12.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/oracle.jar & /Aqua Data Studio/Contents/Resources/Java/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\jtds.jar & [ADS_INSTALL]\ntlmauth.dll
Driver Location (Linux): [ADS_INSTALL]\lib\jtds.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/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\postgresql.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/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\mysql.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/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\jconnect60.jar.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/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\jconnect45.jar & [ADS_INSTALL]\lib\jconnect55.jar & [ADS_INSTALL]\lib\jconnect60.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/jconnect45.jar & /Aqua Data Studio/Contents/Resources/Java/jconnect55.jar & /Aqua Data Studio/Contents/Resources/Java/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\ifxjdbc.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/ifxjdbc.jar
|
