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.
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 9.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 9.0 - 32bit\lib\drivers
07/19/2010 02:05 PM .
07/19/2010 02:05 PM ..
07/19/2010 08:36 AM 1,146,367 db2java.jar
07/19/2010 08:36 AM 3,059,973 db2jcc.jar
07/19/2010 08:36 AM 1,015 db2jcc_license_cu.jar
07/19/2010 08:36 AM 2,446,767 derby.jar
07/19/2010 08:36 AM 514,328 derbyclient.jar
07/19/2010 08:36 AM 229,921 derbynet.jar
07/19/2010 08:36 AM 723,264 ifxjdbc.jar
07/19/2010 08:36 AM 562,289 jconnect60.jar
07/19/2010 08:36 AM 4,393,355 jt400.jar
07/19/2010 08:36 AM 334,207 jtds-src.jar
07/19/2010 08:36 AM 324,739 jtds.jar
07/19/2010 08:36 AM 651,205 mysql-src.jar
07/19/2010 08:36 AM 723,660 mysql.jar
07/19/2010 08:36 AM 445,188 ncluster.jar
07/19/2010 08:36 AM 1,646,178 nlscharset12.jar
09/17/2010 01:32 PM 339,634 nzjdbc.jar
07/19/2010 08:36 AM 1,555,682 oracle.jar
07/19/2010 08:36 AM 475,580 postgresql.jar
07/19/2010 08:36 AM 286,773 util400.jar
07/19/2010 08:36 AM 139,148 xdb.jar
07/19/2010 08:36 AM 839,982 xmlparserv2.jar
21 File(s) 20,499,621 bytes
2 Dir(s) 196,816,015,360 bytes free
C:\Program Files (x86)\Aqua Data Studio 9.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\nzjdbc.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>