 JDBC Drivers - Oracle JDBC Drivers 10g
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:\oracle\product\10.2.0\db_1\jdbc\lib>dir
Volume in drive C has no label.
Volume Serial Number is 18E3-967F
Directory of C:\oracle\product\10.2.0\db_1\jdbc\lib
03/06/2007 10:40p DIR .
03/06/2007 10:40p DIR ..
08/16/2005 04:38p 1,590,041 classes12.jar
08/16/2005 04:38p 1,602,539 classes12.zip
08/16/2005 04:38p 1,597,679 classes12dms.jar
08/17/2005 02:04p 1,642,006 nls_charset12.jar
08/16/2005 04:38p 1,536,554 ojdbc14.jar
08/16/2005 04:38p 1,544,083 ojdbc14dms.jar
08/16/2005 04:38p 1,936,238 ojdbc14dms_g.jar
08/16/2005 04:38p 1,928,225 ojdbc14_g.jar
8 File(s) 13,377,365 bytes
2 Dir(s) 28,158,951,424 bytes free
C:\oracle\product\10.2.0\db_1\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 6.5\lib>dir
Volume in drive C has no label.
Volume Serial Number is 1866-293A
Directory of C:\Program Files\Aqua Data Studio 6.5\lib
06/27/2007 01:41p DIR .
06/27/2007 01:41p DIR ..
02/28/2007 04:18p 54,829 activation.jar
07/11/2007 06:23p 6,367,567 ads.jar
07/11/2007 06:21p 8,540,927 aqua-lib.jar
06/22/2007 05:17p 7,489 aqua2.jar
06/22/2007 01:37p 577,389 aspc.jar
02/28/2007 04:18p 1,146,367 db2java.jar
02/28/2007 04:18p 1,124,512 db2jcc.jar
02/28/2007 04:18p 1,013 db2jcc_license_cu.jar
06/12/2007 07:04p 2,276,020 derby.jar
06/12/2007 07:04p 470,438 derbyclient.jar
02/28/2007 04:18p 685,631 ifxjdbc.jar
02/28/2007 04:18p 73,081 jaxb-api.jar
02/28/2007 04:18p 786,408 jaxb-impl.jar
02/28/2007 04:18p 1,594,947 jaxb-xjc.jar
02/28/2007 04:18p 980,566 jaxb1-impl.jar
10/03/2006 08:25p 523,096 jconnect60.jar
06/05/2007 01:55p 180,724 jide-action.jar
06/05/2007 01:55p 13,343 jide-beaninfo.jar
06/05/2007 01:54p 1,129,067 jide-common.jar
06/05/2007 01:54p 252,162 jide-components.jar
06/05/2007 01:55p 55,179 jide-dialogs.jar
06/05/2007 01:54p 267,173 jide-dock.jar
06/05/2007 01:55p 813,121 jide-grids.jar
06/05/2007 01:55p 402,782 jide-pivot.jar
06/05/2007 01:55p 78,112 jide-shortcut.jar
02/28/2007 04:18p 46,047 jsr173_1.0_api.jar
02/28/2007 04:18p 554,589 jtds-src.jar
02/28/2007 04:18p 285,638 jtds.jar
02/28/2007 04:18p 655,034 mysql-src.jar
02/28/2007 04:18p 495,944 mysql.jar
02/28/2007 04:18p 1,642,000 nlscharset12.jar
02/28/2007 04:18p 1,536,979 oracle.jar
02/28/2007 04:18p 415,542 postgresql.jar
02/28/2007 04:18p 182,856 stringtemplate.jar
02/28/2007 04:18p 139,148 xdb.jar
02/28/2007 04:18p 839,982 xmlparserv2.jar
36 File(s) 35,195,702 bytes
2 Dir(s) 24,478,228,480 bytes free
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 follows ...
C:\Program Files\Aqua Data Studio 6.5>type datastudio.cfg
.
.\jre\bin\javaw.exe
-Dsun.swing.enableImprovedDragGesture -Xmx256M -cp ".\lib\ads.jar;
.\lib\aqua-lib.jar;
.\lib\aspc.jar;
.\lib\aqua2.jar;
.\lib\oracle.jar;
.\lib\nlscharset12.jar;
.\lib\jtds.jar;
.\lib\derby.jar;
.\lib\derbyclient.jar;
.\lib\mysql.jar;
.\lib\postgresql.jar;
.\lib\db2java.jar;
.\lib\db2jcc.jar;
.\lib\db2jcc_license_cu.jar;
.\lib\ifxjdbc.jar;
.\lib\jconnect55.jar;
.\lib\jconnect60.jar;
.\lib\xmlparserv2.jar;
.\lib\xdb.jar;
.\lib\activation.jar;
.\lib\jaxb1-impl.jar;
.\lib\jaxb-api.jar;
.\lib\jaxb-impl.jar;
.\lib\jaxb-xjc.jar;
.\lib\jsr173_1.0_api.jar;
.\lib\stringtemplate.jar;
.\lib\jide-action.jar;
.\lib\jide-beaninfo.jar;
.\lib\jide-common.jar;
.\lib\jide-components.jar;
.\lib\jide-dialogs.jar;
.\lib\jide-dock.jar;
.\lib\jide-grids.jar;
.\lib\jide-pivot.jar;
.\lib\jide-shortcut.jar" com.aquafold.datastudio.DataStudio
C:\Program Files\Aqua Data Studio 6.5>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\derby.jar
SET ADS_PATH=%ADS_PATH%;.\lib\derbyclient.jar
SET ADS_PATH=%ADS_PATH%;.\lib\mysql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\postgresql.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\jconnect60.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aqua-lib.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aqua2.jar
SET ADS_PATH=%ADS_PATH%;.\lib\xmlparserv2.jar
SET ADS_PATH=%ADS_PATH%;.\lib\xdb.jar
SET ADS_PATH=%ADS_PATH%;.\lib\activation.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aspc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jaxb1-impl.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jaxb-api.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jaxb-impl.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jaxb-xjc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jsr173_1.0_api.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stringtemplate.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-action.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-beaninfo.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-common.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-components.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-dialogs.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-dock.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-grids.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-pivot.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide-shortcut.jar
|
