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.
Note 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.
Below is a directory listing of the driver files in the [ORACLE_HOME]\jdbc\lib directory. The ojdbc14.jar file is the
Oracle JDBC driver required by ADS and the nls_charser12.jar is the language pack for the JDBC driver. If you are using
Oracle 8i then the ojdbc14.jar file will not exist but may be substituted by the classes12.jar or classes12.zip file.
C:\oracle92\ora92\jdbc\lib>dir
Volume in drive C is Local Disk
Volume Serial Number is 108C-AA92
Directory of C:\oracle92\ora92\jdbc\lib
02/04/2003 06:34p DIR .
02/04/2003 06:34p DIR ..
04/26/2002 12:47p 1,033,402 classes111.jar
04/26/2002 12:47p 1,043,528 classes111.zip
04/26/2002 12:47p 1,371,600 classes111_g.jar
04/26/2002 12:47p 1,381,728 classes111_g.zip
04/26/2002 12:47p 1,196,109 classes12.jar
04/26/2002 12:47p 1,207,068 classes12.zip
04/26/2002 12:47p 1,201,552 classes12dms.jar
04/26/2002 12:47p 1,438,406 classes12dms_g.jar
04/26/2002 12:47p 1,432,813 classes12_g.jar
04/26/2002 12:47p 1,443,734 classes12_g.zip
04/26/2002 12:47p 1,781,005 nls_charset11.jar
04/26/2002 12:47p 1,810,518 nls_charset11.zip
04/26/2002 12:47p 1,781,898 nls_charset12.jar
04/26/2002 12:47p 1,811,415 nls_charset12.zip
04/26/2002 12:47p 36,640 ocrs12.jar
04/26/2002 12:47p 36,664 ocrs12.zip
04/26/2002 12:47p 1,174,976 ojdbc14.jar
04/26/2002 12:47p 1,383,922 ojdbc14_g.jar
18 File(s) 22,566,978 bytes
2 Dir(s) 35,225,325,568 bytes free
C:\oracle92\ora92\jdbc\lib>
To update the ADS JDBC drivers you need to overwrite the ADS oracle.jar file with ojdbc14.jar or classes12.zip/.jar, and
overwrite the nlscharset12.jar with nls_charset12.jar.
Below is a listing of the Aqua Data Studio library directory [ADS_HOME]\lib ...
C:\Program Files\Aqua Data Studio 4.0\lib>dir
Volume in drive C is Local Disk
Volume Serial Number is 108C-AA92
Directory of C:\Program Files\Aqua Data Studio 4.0\lib
06/06/2005 03:35p DIR .
06/06/2005 03:35p DIR ..
06/25/2002 01:07p 54,368 activation.jar
02/08/2005 08:18a 5,217,547 datastudio.jar
06/27/2003 04:23p 1,146,367 db2java.jar
08/24/2004 02:05p 1,077,696 db2jcc.jar
08/15/2004 09:48p 1,013 db2jcc_license_cu.jar
06/07/2002 08:27a 531,797 ifxjdbc.jar
07/21/2002 10:45p 303,246 jconnect45.jar
04/30/2004 02:20a 896,049 jconnect55.jar
01/25/2005 08:35p 285,111 jtds.jar
08/28/2002 02:58p 305,434 mail.jar
01/21/2005 07:47p 1,773,208 mysql-jdbc.zip
12/23/2004 08:38p 391,434 mysql.jar
03/12/2005 10:27p 1,781,898 nlscharset12.jar
03/12/2005 10:27p 1,196,109 oracle.jar
01/12/2005 07:30p 286,005 postgresql.jar
09/23/2003 01:47p 119,947 xdb.jar
09/23/2003 01:47p 660,890 xmlparserv2.jar
21 File(s) 22,720,504 bytes
2 Dir(s) 35,225,890,816 bytes free
C:\Program Files\Aqua Data Studio 4.0\lib>
The Java class path for the drivers are already configured for ADS in the datastudio.cfg for launching ADS with
datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching ADS from the command line.
The contents of the file are as followed ...
C:\Program Files\Aqua Data Studio 4.0>type datastudio.cfg
.
.\jre\bin\javaw.exe
-Xmx256M -cp ".\lib\datastudio.jar;.\lib\oracle.jar;
.\lib\nlscharset12.jar;.\lib\jtds.jar;
.\lib\mysql.jar;.\lib\postgresql.jar;
.\lib\jconnect45.jar;.\lib\db2java.jar;.\lib\db2jcc.jar;
.\lib\db2jcc_license_cu.jar;.\lib\ifxjdbc.jar;
.\lib\jconnect55.jar;.\lib\mail.jar;
.\lib\activation.jar;.\lib\xmlparserv2.jar;
.\lib\xdb.jar" com.aquafold.datastudio.DataStudio
C:\Program Files\Aqua Data Studio 4.0>type datastudio.bat
SET ADS_PATH=
SET ADS_PATH=%ADS_PATH%;.\lib\oracle.jar
SET ADS_PATH=%ADS_PATH%;.\lib\nlscharset12.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jtds.jar
SET ADS_PATH=%ADS_PATH%;.\lib\mysql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\postgresql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jconnect45.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2jcc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2jcc_license_cu.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2java.jar
SET ADS_PATH=%ADS_PATH%;.\lib\ifxjdbc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jconnect55.jar
SET ADS_PATH=%ADS_PATH%;.\lib\xmlparserv2.jar
SET ADS_PATH=%ADS_PATH%;.\lib\xdb.jar
SET ADS_PATH=%ADS_PATH%;.\lib\mail.jar
SET ADS_PATH=%ADS_PATH%;.\lib\activation.jar
java -cp ".\lib\datastudio.jar;%ADS_PATH%" com.aquafold.datastudio.DataStudio
|
