JDBC Drivers - DB2 iSeries JDBC Driver
| |
DB2 iSeries is the database which has the most connection issues. JDBC drivers for database version are not compatible, neither are they compatible across fixpacks. Updating your DB2 JDBC driver to the version which you are using is always a good idea. The DB2 Server installation provides JDBC drivers for the version and fixpack in use. You may copy the provided JDBC driver and overwrite the driver provided by ADS. You can copy the /sqllib/java/db2java.zip that comes with your installation and overwrite the /ADS_INSTALLATION/lib/db2java.jar file.
- NOTE: The DB2 iSeries JDBC driver does not connect directly to the DB2 Server, but to a proxy server which is installed with the DB2 Server. This proxy server can be started with the db2jstrt[.exe], which defaults to port 6789. The process is enabled by default in most installations.
Driver Location (Windows/Linux):
[ADS_INSTALL]\lib\db2java.jar
Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/db2java.jar
You may locate the latest DB2 JDBC drivers at the following location ...
Vendor: IBM
Driver URL: DB2 Server Installation ([DB2 Install]\java\db2java.zip)
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\SQLLIB\java>dir
Volume in drive C has no label.
Volume Serial Number is 7C2B-F9B7
Directory of C:\Program Files\SQLLIB\java
09/03/2002 12:39p DIR .
09/03/2002 12:39p DIR ..
06/17/2003 07:02p 554,911 cc_cmn.jar
06/17/2003 07:02p 266,631 cc_nav.jar
06/17/2003 06:58p 809,313 common.jar
03/07/2003 07:20p 234,244 databean.jar
06/27/2003 04:23p 1,146,367 db2java.zip
06/18/2003 04:37a 5,342 db2vcsql.jar
09/03/2002 11:21a DIR images
09/03/2002 11:19a DIR java12
09/03/2002 12:36p DIR jdk
06/17/2003 07:01p 239,966 jgraph.jar
09/03/2002 12:35p DIR jre
09/03/2002 12:40p DIR prime
06/17/2003 06:22p 338,990 runtime.zip
06/17/2003 06:58p 1,253,896 sqlasst.jar
06/17/2003 06:22p 1,671,552 sqlj.zip
06/17/2003 09:29p 2,458,220 swingall.jar
11 File(s) 8,979,432 bytes
7 Dir(s) 5,216,145,408 bytes free
C:\Program Files\SQLLIB\java>
To update the ADS JDBC drivers you need to overwrite the ADS db2java.jar file. 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 9.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\aquafold\*.jar classpath.6=.\lib\aspose\*.jar classpath.7=.\lib\dnsjava\*.jar classpath.8=.\lib\drivers\*.jar classpath.9=.\lib\infragistics\*.jar classpath.10=.\lib\itext\*.jar classpath.11=.\lib\java\*.jar classpath.12=.\lib\jgoodies\*.jar classpath.13=.\lib\jgraph\*.jar classpath.14=.\lib\jide\*.jar classpath.15=.\lib\jinterop\*.jar classpath.16=.\lib\jna\*.jar classpath.17=.\lib\jogl\*.jar classpath.18=.\lib\quartz\*.jar classpath.19=.\lib\snmp4j\*.jar classpath.20=.\lib\ssh2\*.jar classpath.21=.\lib\stndeditor\*.jar classpath.22=.\lib\svnkit\*.jar main.class=com.aquafold.datastudio.DataStudio C:\Program Files (x86)\Aqua Data Studio 9.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-ant.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-commons-net.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-jsch.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-launcher.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-ant-nodeps.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-ooxml.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\apache-poi-ooxml-schemas.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-validator.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-vfs.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\commons-xmlgraphics.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\dom4j.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\hadoop-core.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\jakarta-oro.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\jcraft-jsch.jar SET ADS_PATH=%ADS_PATH%;.\lib\apache\tidy.jar SET ADS_PATH=%ADS_PATH%;.\lib\apple\aqua2.jar SET ADS_PATH=%ADS_PATH%;.\lib\aquafold\geo.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_cisuz.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\ncluster.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\tdgssconfig.jar SET ADS_PATH=%ADS_PATH%;.\lib\drivers\terajdbc4.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\servlet-api.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\jna\platform.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\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=192m -cp "%ADS_PATH%" com.aquafold.datastudio.Data Studio C:\Program Files (x86)\Aqua Data Studio 9.0 - 32bit>