Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| JDBC Drivers - DB2 9.0 JDBC Driver
The DB2 JDBC drivers included with ADS work across all 8.x and 9.x versions of DB2. There is no need to change or update this driver.
|
||
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 has no label.
Volume Serial Number is 18E3-967F
Directory of C:\Program Files\IBM\SQLLIB\java
04/09/2007 08:19a DIR .
04/09/2007 08:19a DIR ..
07/11/2006 01:06a 2,227,922 Common.jar
07/11/2006 01:05a 47,649 db2dbgm.jar
07/11/2006 01:05a 869,388 db2java.zip
07/11/2006 01:05a 1,973,658 db2jcc.jar
07/11/2006 01:05a 23,709 db2jcc_javax.jar
07/11/2006 01:05a 1,015 db2jcc_license_cu.jar
07/11/2006 01:06a 120,951 db2policy.jar
07/11/2006 01:05a 170,472 db2qgjava.jar
07/11/2006 01:05a 9,095 db2umplugin.jar
04/09/2007 08:19a DIR images
04/09/2007 08:18a DIR jdk
07/11/2006 01:05a 1,515,827 sqlj.zip
10 File(s) 6,959,686 bytes
4 Dir(s) 26,645,422,080 bytes free
C:\Program Files\IBM\SQLLIB\java>
|
||
To update the ADS JDBC drivers you need to overwrite the ADS db2java.jar (for DB2 7.2) and/or db2jcc.jar and db2jcc_license_cu.jar (for DB2 8.1) files. Below is a listing of the Aqua Data Studio library directory [ADS_HOME]\lib\drivers\ ...C:\Program Files\Aqua Data Studio 7.0 - 32bit\lib\drivers>dir
Volume in drive C has no label.
Volume Serial Number is AC70-D62C
Directory of C:\Program Files\Aqua Data Studio 7.0 - 32bit\lib\drivers
05/30/2008 08:48 AM dir .
05/30/2008 08:48 AM dir ..
03/20/2008 10:05 PM 1,146,367 db2java.jar
03/20/2008 10:05 PM 1,973,658 db2jcc.jar
03/20/2008 10:05 PM 1,015 db2jcc_license_cu.jar
03/20/2008 10:05 PM 2,343,388 derby.jar
03/20/2008 10:05 PM 489,802 derbyclient.jar
04/05/2008 01:15 PM 218,162 derbynet.jar
03/20/2008 10:05 PM 685,631 ifxjdbc.jar
03/20/2008 10:05 PM 529,560 jconnect60.jar
03/20/2008 10:05 PM 4,301,866 jt400.jar
03/20/2008 10:05 PM 554,589 jtds-src.jar
05/06/2008 09:46 PM 297,610 jtds.jar
03/20/2008 10:05 PM 655,034 mysql-src.jar
03/20/2008 10:05 PM 676,693 mysql.jar
04/16/2008 09:29 AM 1,645,114 nlscharset12.jar
04/16/2008 09:29 AM 1,545,954 oracle.jar
03/20/2008 10:05 PM 415,542 postgresql.jar
03/20/2008 10:05 PM 286,771 util400.jar
03/20/2008 10:05 PM 139,148 xdb.jar
03/20/2008 10:05 PM 839,982 xmlparserv2.jar
19 File(s) 18,745,886 bytes
2 Dir(s) 17,642,438,656 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
|