Aqua Data Studio includes the Oracle 11g JDBC drivers, which do not support Oracle 8i connections. In order to use Aqua Data Studio with Oracle 8i, you must must remove the Oracle 11g JDBC drivers that come as part of the default installation of Aqua Data Studio. If you need the functionality of the Oracle 11g JDBC drivers once more, remove the Oracle 8i drivers and return the Oracle 11g JDBC drivers to their default installation location.
Oracle JDBC drivers provide compatibility 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 11g client software. If you have the 8i 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 JDBC driver, which has support for 8i OCI libraries.
Important: OSX Installations: OCI Connections are not supported on OSX. There is no need to change or update the drivers on OSX.
You may locate the latest Oracle JDBC drivers at the following location ...
Vendor: Oracle
Driver URL: [Free Registration Required] http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
You may locate the JDBC drivers for your installed version of Oracle in the Oracle server or Oracle client installations under [ORACLE_HOME]\jdbc\lib\ directory. The xdb.jar file is also needed and is located in the [ORACLE_HOME]\rdbms\jlib directory. Below is a directory listing of the driver files in the [ORACLE_HOME]\jdbc\lib\ directory. The classes12.zip file is the Oracle JDBC driver required by ADS and the nls_charser12.zip is the language pack for the JDBC driver.
C:\oracle\ora81\jdbc\lib>dir
Volume in drive C has no label.
Volume Serial Number is 5C1C-7C82
Directory of C:\oracle\ora81\jdbc\lib
07/03/2002 10:33p DIR .
07/03/2002 10:33p DIR ..
09/14/2000 03:03p 1,778,452 classes111.zip
09/14/2000 03:21p 1,932,480 classes12.zip
08/23/2000 05:58p 97,158 jndi.zip
08/23/2000 05:58p 14,810 jta.zip
06/28/2000 03:58p 10,155,207 nls_charset11.zip
06/28/2000 05:25p 12,097,171 nls_charset12.zip
6 File(s) 26,075,278 bytes
2 Dir(s) 2,054,410,240 bytes free
C:\oracle\ora81\jdbc\lib>
To update the ADS JDBC drivers you need to delete the ADS ojdbc6.jar, orai18n.jar and xdb6.jar and copy the nls_charset12.zip/.jar and classes12.zip/.jar into \lib\drivers making sure to rename the file extensions for all of them to .jar. Also copy the xdb.jar file from the [ORACLE_HOME]\rdbms\jlib directory to [ADS_INSTALL]\lib\drivers. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers ...
C:\Program Files\Aqua Data Studio 12.0 - 64bit\lib\drivers>dir Volume in drive C has no label. Volume Serial Number is 40F4-2392 Directory of C:\Program Files\Aqua Data Studio 12.0 - 64bit\lib\drivers 11/23/2012 08:58 AM <DIR> . 11/23/2012 08:58 AM <DIR> .. 11/22/2012 11:13 AM 35,701 cassandra-clientutil.jar 11/22/2012 11:13 AM 64,465 cassandra-jdbc.jar 11/22/2012 11:13 AM 948,351 cassandra-thrift.jar 09/14/2000 02:21 PM 1,932,480 classes12.jar (jar file used to backdrop to 8i) 11/22/2012 11:13 AM 1,146,367 db2java.jar 11/22/2012 11:13 AM 3,348,681 db2jcc.jar 11/22/2012 11:13 AM 1,015 db2jcc_license_cu.jar 11/22/2012 11:13 AM 2,703,892 derby.jar 11/22/2012 11:13 AM 535,985 derbyclient.jar 11/22/2012 11:13 AM 242,891 derbynet.jar 11/22/2012 11:13 AM 812,386 ifxjdbc.jar 11/22/2012 11:13 AM 1,660,765 jconnect70.jar 11/22/2012 11:13 AM 141,648 jsqlparser-src.zip 11/22/2012 11:13 AM 142,861 jsqlparser.jar 11/22/2012 11:13 AM 4,581,825 jt400.jar 11/22/2012 11:13 AM 350,273 jtds-src.jar 11/22/2012 11:13 AM 329,228 jtds.jar 11/22/2012 11:13 AM 291,946 mongo.jar 11/22/2012 11:13 AM 651,205 mysql-src.jar 11/22/2012 11:13 AM 745,416 mysql.jar 11/22/2012 11:13 AM 445,188 ncluster.jar 06/28/2000 04:25 PM 12,097,171 nls_charser12.jar (jar file used to backdrop to 8i) 04/13/2004 04:01 PM 1,352,918 orajdb14.jar (jar file used to backdrop to 8i) 11/22/2012 11:13 AM 2,714,189 ojdbc6.jar (delete before backdrop to the 8i JDBC Drivers) 11/22/2012 11:13 AM 1,656,248 orai18n.jar (delete before backdrop to the 8i JDBC Drivers) 11/22/2012 11:13 AM 346,944 paraccel-jdbc.jar 11/22/2012 11:13 AM 561,969 postgresql.jar 11/22/2012 11:13 AM 3,516,830 sqlite-jdbc.jar 11/22/2012 11:13 AM 286,773 util400.jar 11/22/2012 11:13 AM 262,740 xdb6.jar (delete before backdrop to the 8i JDBC Drivers) 06/26/2012 10:45 AM 139,148 xdb.jar (jar file used to backdrop to 8i) 11/22/2012 11:13 AM 839,982 xmlparserv2.jar 28 File(s) 29,365,764 bytes 2 Dir(s) 88,341,790,720 bytes free C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>
The Java class path for the drivers are already configured for ADS in the datastudio.ini for launching ADS with datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching ADS from the command line.
If you have an installation of Aqua Data Studio v11.0 or earlier, you can use its Oracle drivers ( oracle.jar, xdb.jar, nlscharset12.jar ) to replace the Aqua Data Studio v13.0 drivers. As in the steps above, first delete the Oracle 11g JDBC drivers ( ojdbc6.jar, orai18n.jar, xdb6.jar ), then paste in your Oracle drivers from the older version of Aqua Data Studio.