3.18 ParAccel Analytic Platform JDBC Drivers (Revision #16)

JDBC Drivers - ParAccel Analytic Platform JDBC Drivers

 The ParAccel Analytic Platform JDBC (v8.0) drivers included with ADS work with ParAccel 3.5 and 3.1. ParAccel Analytic Platform server releases are frequent, and may sometimes require updating the JDBC driver.
You may locate the latest ParAccel Analytic Platform JDBC drivers at the following location ...

Vendor: ParAccel
Driver URL:

To update the ADS JDBC drivers you need to overwrite the ADS paraccel-jdbc.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\paraccel-jdbc.jar

Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/drivers/paraccel-jdbc.jar

C:\Program Files\Aqua Data Studio 11.0 - 64bit\lib\drivers>dir
 Volume in drive C has no label.
 Volume Serial Number is 40F4-2392

 Directory of C:\Program Files\Aqua Data Studio 11.0 - 64bit\lib\drivers

04/09/2012  04:07 PM    <DIR>          .
04/09/2012  04:07 PM    <DIR>          ..
04/08/2012  04:03 PM         1,146,367 db2java.jar
12/07/2008  01:08 PM         3,059,973 db2jcc.jar
12/07/2008  01:08 PM             2,068 db2jcc_license_cisuz.jar
12/07/2008  01:08 PM             1,015 db2jcc_license_cu.jar
04/08/2012  04:03 PM         2,446,767 derby.jar
04/08/2012  04:03 PM           514,328 derbyclient.jar
04/08/2012  04:03 PM           229,921 derbynet.jar
04/08/2012  04:03 PM           812,386 ifxjdbc.jar
04/08/2012  04:03 PM           562,289 jconnect60.jar
04/08/2012  04:03 PM         4,485,843 jt400.jar
04/08/2012  04:03 PM           320,846 jtds-src.jar
04/08/2012  04:03 PM           324,727 jtds.jar
04/08/2012  04:03 PM           651,205 mysql-src.jar
04/08/2012  04:03 PM           745,416 mysql.jar
04/08/2012  04:03 PM           445,188 ncluster.jar
04/08/2012  04:03 PM         1,646,178 nlscharset12.jar
08/23/2010  11:07 AM           339,634 nzjdbc.jar
04/08/2012  04:03 PM         1,555,682 oracle.jar
04/08/2012  04:03 PM           346,944 paraccel-jdbc.jar
04/08/2012  04:03 PM           475,580 postgresql.jar
06/20/2008  01:41 PM             1,711 tdgssconfig.jar
05/08/2009  09:12 AM           855,053 terajdbc4.jar
04/08/2012  04:03 PM           286,773 util400.jar
04/08/2012  04:03 PM           139,148 xdb.jar
04/08/2012  04:03 PM           839,982 xmlparserv2.jar
              25 File(s)     22,235,024 bytes
               2 Dir(s)  113,013,755,904 bytes free

C:\Program Files\Aqua Data Studio 11.0 - 64bit\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\Aqua Data Studio 11.0 - 64bit>type datastudio.ini
working.directory=.

# JVM Properties
vm.location=.\jre\bin\server\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
single.instance=dde
dde.enabled=true
dde.class=com.common.windows.noobfus.WinDDE
dde.server.name=datastudio

vmarg.1=-Dsun.swing.enableImprovedDragGesture
vmarg.2=-Xmx512M
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\icepdf\*.jar
classpath.10=.\lib\infragistics\*.jar
classpath.11=.\lib\itext\*.jar
classpath.12=.\lib\java\*.jar
classpath.13=.\lib\jgoodies\*.jar
classpath.14=.\lib\jgraph\*.jar
classpath.15=.\lib\jide\*.jar
classpath.16=.\lib\jinterop\*.jar
classpath.17=.\lib\jna\*.jar
classpath.18=.\lib\jogl\*.jar
classpath.19=.\lib\perforce\*.jar
classpath.20=.\lib\quartz\*.jar
classpath.21=.\lib\snmp4j\*.jar
classpath.22=.\lib\ssh2\*.jar
classpath.23=.\lib\stndeditor\*.jar
classpath.24=.\lib\svnkit\*.jar

main.class=com.aquafold.datastudio.DataStudio




C:\Program Files\Aqua Data Studio 11.0 - 64bit>



C:\Program Files\Aqua Data Studio 11.0 - 64bit>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-compress.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\aspose\jsr173-api.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aspose\stax2-api.jar
SET ADS_PATH=%ADS_PATH%;.\lib\aspose\woodstox-core-asl.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\paraccel-jdbc.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\icepdf\icepdf-core.jar
SET ADS_PATH=%ADS_PATH%;.\lib\icepdf\icepdf-viewer.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\perforce\p4java.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.terminal.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 -Xmx512M -XX:MaxPermSize=192m -cp "%ADS_PATH%" com.aquafold.datastudio.Data
Studio







C:\Program Files\Aqua Data Studio 11.0 - 64bit>