Page History
JDBC Drivers - Sybase Anywhere JDBC Drivers
The Sybase Anywhere JDBC drivers included with ADS work across all versions of Sybase Anywhere from 7.0 to 16.0. There is no need to change or update this driver.
You may locate the latest Sybase JDBC drivers at the following location ...
Vendor: Sybase (jConnect16.0)
Driver URL: http://www.sybase.com/downloads
To update the ADS JDBC drivers you need to overwrite the ADS jconnect16.jar. Below is a listing of the Aqua Data Studio library directory [ADS_HOME]\lib\drivers ...
Driver Location (Windows/Linux):
[ADS_INSTALL]\lib\drivers\jconnect16.jar
Driver Location (OSX):
/Aqua Data Studio/Contents/Java/drivers/jconnect70.jar
No Format |
---|
C:\Program Files\Aqua Data Studio 12.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 12.0 - 64bit\lib\drivers
07/26/2012 07:45 AM <DIR> .
07/26/2012 07:45 AM <DIR> ..
07/26/2012 06:33 AM 1,146,367 db2java.jar
07/26/2012 06:33 AM 3,348,681 db2jcc.jar
07/26/2012 06:33 AM 1,015 db2jcc_license_cu.jar
07/26/2012 06:33 AM 2,671,577 derby.jar
07/26/2012 06:33 AM 538,340 derbyclient.jar
07/26/2012 06:33 AM 239,546 derbynet.jar
07/26/2012 06:33 AM 812,386 ifxjdbc.jar
07/26/2012 06:33 AM 1,437,384 jconnect16.jar
07/26/2012 06:33 AM 4,581,825 jt400.jar
07/26/2012 06:33 AM 327,933 jtds-src.jar
07/26/2012 06:33 AM 327,974 jtds.jar
07/26/2012 06:33 AM 291,946 mongo.jar
07/26/2012 06:33 AM 651,205 mysql-src.jar
07/26/2012 06:33 AM 745,416 mysql.jar
07/26/2012 06:33 AM 445,188 ncluster.jar
07/26/2012 06:33 AM 2,714,189 ojdbc6.jar
07/26/2012 06:33 AM 1,656,248 orai18n.jar
07/26/2012 06:33 AM 346,944 paraccel-jdbc.jar
07/26/2012 06:33 AM 561,969 postgresql.jar
07/26/2012 06:33 AM 3,516,830 sqlite-jdbc.jar
07/26/2012 06:33 AM 286,773 util400.jar
07/26/2012 06:33 AM 262,740 xdb6.jar
07/26/2012 06:33 AM 839,982 xmlparserv2.jar
23 File(s) 27,752,458 bytes
2 Dir(s) 252,798,070,784 bytes free
C:\Program Files\Aqua Data Studio 12.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 ...
No Format |
---|
C:\Program Files\Aqua Data Studio 12.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=-Xmx756M
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 12.0 - 64bit>
C:\Program Files\Aqua Data Studio 12.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\*
SET ADS_PATH=%ADS_PATH%;.\lib\apache\*
SET ADS_PATH=%ADS_PATH%;.\lib\apple\*
SET ADS_PATH=%ADS_PATH%;.\lib\aquafold\*
SET ADS_PATH=%ADS_PATH%;.\lib\aspose\*
SET ADS_PATH=%ADS_PATH%;.\lib\dnsjava\*
SET ADS_PATH=%ADS_PATH%;.\lib\drivers\*
SET ADS_PATH=%ADS_PATH%;.\lib\icepdf\*
SET ADS_PATH=%ADS_PATH%;.\lib\infragistics\*
SET ADS_PATH=%ADS_PATH%;.\lib\itext\*
SET ADS_PATH=%ADS_PATH%;.\lib\java\*
SET ADS_PATH=%ADS_PATH%;.\lib\jgoodies\*
SET ADS_PATH=%ADS_PATH%;.\lib\jgraph\*
SET ADS_PATH=%ADS_PATH%;.\lib\jide\*
SET ADS_PATH=%ADS_PATH%;.\lib\jinterop\*
SET ADS_PATH=%ADS_PATH%;.\lib\jna\*
SET ADS_PATH=%ADS_PATH%;.\lib\jogl\*
SET ADS_PATH=%ADS_PATH%;.\lib\perforce\*
SET ADS_PATH=%ADS_PATH%;.\lib\quartz\*
SET ADS_PATH=%ADS_PATH%;.\lib\snmp4j\*
SET ADS_PATH=%ADS_PATH%;.\lib\ssh2\*
SET ADS_PATH=%ADS_PATH%;.\lib\stndeditor\*
SET ADS_PATH=%ADS_PATH%;.\lib\svnkit\*
ECHO ON
java -Xmx756M -XX:MaxPermSize=192m -cp "%ADS_PATH%" com.aquafold.datastudio.DataStudio
C:\Program Files\Aqua Data Studio 12.0 - 64bit> |