You may locate the JDBC drivers for your installed version of DB2 in the DB2 server or DB2 client installations.
Below is a directory listing of the driver files in the [DB2_INSTALL]\java directory. The db2java.zip file is the
DB2 JDBC driver required by ADS. This is the file which you need to use to overwrite the db2java.jar file.
C:\Program Files\IBM\SQLLIB\java>dir
Volume in drive C is Local Disk
Volume Serial Number is 5C1C-7C82
Directory of C:\Program Files\IBM\SQLLIB\java
08/03/2004 12:07a DIR .
08/03/2004 12:07a DIR ..
08/15/2004 08:48p 2,212,612 Common.jar
08/15/2004 08:48p 237,008 db2fs.jar
08/15/2004 08:48p 1,232,035 db2java.zip
08/15/2004 08:48p 1,075,286 db2jcc.jar
08/15/2004 08:48p 23,709 db2jcc_javax.jar
08/15/2004 08:48p 1,013 db2jcc_license_cu.jar
08/15/2004 08:48p 118,928 db2policy.jar
08/15/2004 08:48p 161,393 db2qgjava.jar
08/03/2004 12:02a DIR images
08/03/2004 12:03a DIR jdk
08/15/2004 08:48p 1,512,886 sqlj.zip
9 File(s) 6,574,870 bytes
4 Dir(s) 1,808,121,856 bytes free
C:\Program Files\IBM\SQLLIB\java>
|
To update the ADS JDBC drivers you need to overwrite the ADS db2jcc.jar and db2jcc_license_cu.jar files.
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
|
