× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases

×

2.7.9 DB2 LUW 9.0 and DB2 UDB 9.5 (Revision #11)

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.

Driver Location (Windows/Linux): [ADS_INSTALL]\lib\drivers\db2jcc.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/drivers/db2jcc.jar

You may locate the latest DB2 JDBC drivers at the following location ...

Vendor: IBM (JDBC Type 4 Driver)
Driver URL: http://www.ibm.com/support/us/

 
 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 (x86)\Aqua Data Studio 8.0 - 32bit\lib\drivers>dir
 Volume in drive C has no label.
 Volume Serial Number is 40F4-2392

 Directory of C:\Program Files (x86)\Aqua Data Studio 8.0 - 32bit\lib\drivers

06/11/2009  09:47 AM              .
06/11/2009  09:47 AM              ..
06/10/2009  12:48 PM         1,146,367 db2java.jar
06/10/2009  12:48 PM         3,059,973 db2jcc.jar
12/07/2008  01:08 PM             2,068 db2jcc_license_cisuz.jar
06/10/2009  12:48 PM             1,015 db2jcc_license_cu.jar
06/10/2009  12:48 PM         2,446,767 derby.jar
06/10/2009  12:48 PM           514,328 derbyclient.jar
06/10/2009  12:48 PM           229,921 derbynet.jar
06/11/2009  09:46 AM           788,919 drivers-extended.zip
06/10/2009  12:48 PM           685,631 ifxjdbc.jar
06/10/2009  12:48 PM           529,560 jconnect60.jar
06/10/2009  12:48 PM         4,301,866 jt400.jar
06/10/2009  12:48 PM           568,827 jtds-src.jar
06/10/2009  12:48 PM           298,518 jtds.jar
06/10/2009  12:48 PM           655,034 mysql-src.jar
06/10/2009  12:48 PM           676,693 mysql.jar
06/10/2009  12:48 PM           444,919 ncluster.jar
06/10/2009  12:48 PM         1,646,178 nlscharset12.jar
06/10/2009  12:48 PM         1,555,682 oracle.jar
06/10/2009  12:48 PM           415,542 postgresql.jar
03/04/2009  11:57 AM             1,711 tdgssconfig.jar
03/04/2009  11:57 AM           848,943 terajdbc4.jar
06/10/2009  12:48 PM           286,771 util400.jar
06/10/2009  12:48 PM           139,148 xdb.jar
06/10/2009  12:48 PM           839,982 xmlparserv2.jar
              24 File(s)     22,084,363 bytes
               2 Dir(s)  261,242,703,872 bytes free

C:\Program Files (x86)\Aqua Data Studio 8.0 - 32bit\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. The contents of the file are as follows ...

C:\Program Files (x86)\Aqua Data Studio 8.0 - 32bit>type datastudio.ini
working.directory=.

# JVM Properties
vm.location=.\jre\bin\client\jvm.dll

# Specify a proportion of the available physical memory to use (ie. relates to -
Xmx arg). For example, vm.heapsize.max.percent=75. Note that this will use the m
aximum memory possible.
#vm.heapsize.max.percent=

#Specify a proportion of the available physical memory to use as the minimum sta
rting heap size (ie. relates to -Xms arg).
#vm.heapsize.min.percent=

#Specify a preferred amount (in MB) for the heap size (ie. relates to -Xmx arg).
 If this amount is not available it will use the maximum amount possible given t
he physical memory available.
#vm.heapsize.preferred=

#Specifies that only one instance of the product should run at any given time
single.instance=window

vmarg.1=-Dsun.swing.enableImprovedDragGesture
vmarg.2=-Xmx256M
vmarg.3=-XX:MaxPermSize=128m

classpath.1=.\lib\*.jar
classpath.2=.\lib\antlr\*.jar
classpath.3=.\lib\apache\*.jar
classpath.4=.\lib\apple\*.jar
classpath.5=.\lib\aspose\*.jar
classpath.6=.\lib\dnsjava\*.jar
classpath.7=.\lib\drivers\*.jar
classpath.8=.\lib\infragistics\*.jar
classpath.9=.\lib\itext\*.jar
classpath.10=.\lib\java\*.jar
classpath.11=.\lib\jgoodies\*.jar
classpath.12=.\lib\jgraph\*.jar
classpath.13=.\lib\jide\*.jar
classpath.14=.\lib\jinterop\*.jar
classpath.15=.\lib\jna\*.jar
classpath.16=.\lib\jogl\*.jar
classpath.17=.\lib\quartz\*.jar
classpath.18=.\lib\snmp4j\*.jar
classpath.19=.\lib\ssh2\*.jar
classpath.20=.\lib\stndeditor\*.jar
classpath.21=.\lib\svnkit\*.jar

main.class=com.aquafold.datastudio.DataStudio
C:\Program Files (x86)\Aqua Data Studio 8.0 - 32bit>type datastudio.bat
ECHO OFF

SET ADS_PATH=

SET ADS_PATH=%ADS_PATH%;.\lib\ads.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aqua-lib.jar

SET ADS_PATH=%ADS_PATH%;.\lib\antlr\stringtemplate.jar

SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-batik.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-fop.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-log4j.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-contrib.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-scratchpad.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-serializer.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-xalan.jar

SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-beanutils.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-codec.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-collections.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-configuration.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-dbcp.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-dbutils.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-email.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-httpclient.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-io.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-lang.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging-adapters.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-logging-api.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-math.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-net.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-net-ftp.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-primitives.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-transaction.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-xmlgraphics.jar

SET ADS_PATH=%ADS_PATH%;.\lib\apple\aqua2.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aspose\aspc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\dnsjava\dnsjava.jar

SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2java.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\db2jcc_license_cu.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derby.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derbyclient.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\derbynet.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\ifxjdbc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jconnect55.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jconnect60.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jt400.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\jtds.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\mysql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\nlscharset12.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\oracle.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\postgresql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\util400.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\xdb.jar
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\xmlparserv2.jar

SET ADS_PATH=%ADS_PATH%;.\lib\infragistics\infragistics.jar
SET ADS_PATH=%ADS_PATH%;.\lib\itext\itext.jar
SET ADS_PATH=%ADS_PATH%;.\lib\java\activation.jar
SET ADS_PATH=%ADS_PATH%;.\lib\java\mail.jar
SET ADS_PATH=%ADS_PATH%;.\lib\java\tools.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jgoodies\looks.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jgraph\jgraph.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jgraph\jgraphlayout.jar

SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-action.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-beaninfo.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-common.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-components.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-dialogs.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-dock.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-grids.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-pivot.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-shortcut.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jide\jide-properties.jar

SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\jcifs.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\j-interop.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\j-interopdeps.jar

SET ADS_PATH=%ADS_PATH%;.\lib\jna\jna.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jogl\jogl.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jogl\gluegen-rt.jar
SET ADS_PATH=%ADS_PATH%;.\lib\quartz\quartz.jar
SET ADS_PATH=%ADS_PATH%;.\lib\snmp4j\snmp4j.jar
SET ADS_PATH=%ADS_PATH%;.\lib\ssh2\ssh2.jar

SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.core.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.htmlcss.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.java.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.javascript.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\lib.xml.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\org-openide-explorer.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-htmlcss.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-java.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-javascript.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-core.jar
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\standalone-xml.jar

SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit-cli.jar
SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit-javahl.jar
SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\svnkit.jar

ECHO ON

java -Xmx256M -XX:MaxPermSize=128m -cp "%ADS_PATH%" com.aquafold.datastudio.Data
Studio






 

 

 

Last updated by swissarmyknife(*) on Jun 18, 2009 11:16 PM

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017