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 - ParAccel Analytic Platform JDBC Drivers
|
|
The ParAccel Analytic Platform JDBC (v8.0) drivers included with ADS work with ParAccel 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: PostgreSQL
Driver URL: http://jdbc.postgresql.org/download.html
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/postgresql.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 10:56 AM <DIR> .
04/09/2012 10:56 AM <DIR> ..
04/08/2012 04:03 PM 1,146,367 db2java.jar
04/08/2012 04:03 PM 3,348,681 db2jcc.jar
04/08/2012 04:03 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
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
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
21 File(s) 21,325,266 bytes
2 Dir(s) 113,017,577,472 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 (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>