Oracle 10g JDBC Drivers

JDBC Drivers - Oracle JDBC Drivers 10g

ADS 12.0 and above comes bundled with Oracle 11g JDBC Drivers. These drivers are compatible with JDBC connections to Oracle 11g, 10g and 9i servers. If you want to make a JDBC connection to Oracle 8i, you need to downgrade to Oracle 10g JDBC drivers because Oracle 11g JDBC drivers have discontinued support for Oracle 8i. Please see the instructions below on how to downgrade to Oracle JDBC 10g Drivers.

OS X Users: OCI Connections are not supported on OS X.

Downgrading to Oracle 10g JDBC Drivers

1. You should perform this downgrade only if you want to connect to an Oracle 8i Database.
2. Download nls_charset12.jar, xdb.jar and oracle.jar from http://dd1.aquafold.com/download/jdbc-drivers/Oracle10g/
3. Delete ojdbc6.jar, orai18n.jar and xdb6.jar from [ADS_INSTALL]\lib\drivers.
4. Copy the nls_charset12.jar, xdb.jar and oracle.jar file that you downloaded in step 2 to [ADS_INSTALL]\lib\drivers.

Below is a listing of the Aqua Data Studio [ADS_INSTALL]\lib\drivers directory before deleting the Oracle 11g 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 13.0 - 64bit\lib\drivers

11/23/2012  08:58 AM    <DIR>          .
11/23/2012  08:58 AM    <DIR>          ..
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           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
11/22/2012  11:13 AM         2,714,189 ojdbc6.jar    (delete before backdrop to the 10g JDBC Drivers)
11/22/2012  11:13 AM         1,656,248 orai18n.jar   (delete before backdrop to the 10g 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           286,773 util400.jar
11/22/2012  11:13 AM           262,740 xdb6.jar   (delete before backdrop to the 10g JDBC Drivers)
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>

Below is a listing of the Aqua Data Studio [ADS_INSTALL]\lib\drivers directory after copying and pasting the Oracle 10g 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         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           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
11/22/2012  11:13 AM         1,646,178 nlscharset12.jar    (added after backdrop to the 10g JDBC Drivers)
11/22/2012  11:13 AM         1,555,682 oracle.jar   (added after backdrop to the 10g 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           286,773 util400.jar
11/22/2012  11:13 AM           139,148 xdb.jar   (added after backdrop to the 10g JDBC Drivers)
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.