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 - Netezza JDBC Drivers
The Netezza JDBC (v5.0) drivers included with ADS work with Netezza 5.0 and Netezza 6.0. Netezza server releases are frequent, and may sometimes require updating the JDBC driver.
You may locate the latest Netezza JDBC drivers at the following location ...
Vendor: Netezza
Driver URL: Contact your Netezza Representative.
To update the ADS JDBC drivers you need to overwrite the ADS nzjdbc.jar file. Below is a listing of the Aqua Data Studio library directory [ADS_HOME]\lib\drivers\ ...
Driver Location (Windows/Linux):
[ADS_INSTALL]\lib\drivers\nzjdbc.jar
Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/drivers/nzjdbc.jar
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>