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 - Microsoft SQL Server JDBC Drivers
The jTDS JDBC (v1.2) drivers included with ADS work across all versions of SQL Server. There shouldn’t be any need to change or update this driver.
If there is a need to update to the latest version of the driver, you may locate the latest jTDS JDBC driver at the following location ...
Vendor: jTDS Open Source Project
Driver URL: http://sourceforge.net/project/showfiles.php?group_id=33291
To update the ADS JDBC drivers you need to overwrite the ADS jtds.jar file and ntlmauth.dll on the Windows platform. Below is a listing of the Aqua Data Studio library directory [ADS_HOME]\lib\drivers\ ...
Driver Location (Windows):
[ADS_INSTALL]\lib\\drivers\jtds.jar
[ADS_INSTALL]\ntlmauth.dll
Driver Location (Linux):
[ADS_INSTALL]\lib\drivers\jtds.jar
Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/drivers/jtds.jar
C:\Program Files\Aqua Data Studio 7.5 - 32bit\lib\drivers>dir
Volume in drive C has no label.
Volume Serial Number is AC70-D62C
Directory of C:\Program Files\Aqua Data Studio 7.5 - 32bit\lib\drivers
05/30/2008 08:48 AM dir .
05/30/2008 08:48 AM dir ..
03/20/2008 10:05 PM 1,146,367 db2java.jar
03/20/2008 10:05 PM 1,973,658 db2jcc.jar
03/20/2008 10:05 PM 1,015 db2jcc_license_cu.jar
03/20/2008 10:05 PM 2,343,388 derby.jar
03/20/2008 10:05 PM 489,802 derbyclient.jar
04/05/2008 01:15 PM 218,162 derbynet.jar
03/20/2008 10:05 PM 685,631 ifxjdbc.jar
03/20/2008 10:05 PM 529,560 jconnect60.jar
03/20/2008 10:05 PM 4,301,866 jt400.jar
03/20/2008 10:05 PM 554,589 jtds-src.jar
05/06/2008 09:46 PM 297,610 jtds.jar
03/20/2008 10:05 PM 655,034 mysql-src.jar
03/20/2008 10:05 PM 676,693 mysql.jar
04/16/2008 09:29 AM 1,645,114 nlscharset12.jar
04/16/2008 09:29 AM 1,545,954 oracle.jar
03/20/2008 10:05 PM 415,542 postgresql.jar
03/20/2008 10:05 PM 286,771 util400.jar
03/20/2008 10:05 PM 139,148 xdb.jar
03/20/2008 10:05 PM 839,982 xmlparserv2.jar
19 File(s) 18,745,886 bytes
2 Dir(s) 17,642,438,656 bytes free
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 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 8.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\aspose\*.jar
classpath.6=.\lib\dnsjava\*.jar
classpath.7=.\lib\drivers\*.jar
classpath.8=.\lib\infragistics\*.jar
classpath.9=.\lib\itext\*.jar
classpath.10=.\lib\java\*.jar
classpath.11=.\lib\jgoodies\*.jar
classpath.12=.\lib\jgraph\*.jar
classpath.13=.\lib\jide\*.jar
classpath.14=.\lib\jinterop\*.jar
classpath.15=.\lib\jna\*.jar
classpath.16=.\lib\jogl\*.jar
classpath.17=.\lib\quartz\*.jar
classpath.18=.\lib\snmp4j\*.jar
classpath.19=.\lib\ssh2\*.jar
classpath.20=.\lib\stndeditor\*.jar
classpath.21=.\lib\svnkit\*.jar
main.class=com.aquafold.datastudio.DataStudio
C:\Program Files (x86)\Aqua Data Studio 8.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-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-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-xmlgraphics.jar
SET ADS_PATH=%ADS_PATH%;.\lib\apple\aqua2.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_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\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\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\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\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\org-openide-explorer.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=128m -cp "%ADS_PATH%" com.aquafold.datastudio.Data
Studio