Sybase JDBC Drivers - The Sybase JDBC drivers included with ADS
work across all versions of Sybase from 11.0 to 15. There is no need to change or update this driver.
NOTE: For your Sybase JDBC driver to work properly, your Sybase server must have the latest EBT/Maintenance
patches applied to them. The sql_server_xxx.sql scripts contain metadata required by the JDBC drivers.
You may locate the latest Sybase JDBC drivers at the following location ...
Vendor: Sybase (jConnect 4.5/5.5/6.0)
Driver URL: http://www.sybase.com/downloads
To update the ADS JDBC drivers you need to overwrite the ADS jconnect45.jar and/or jconnect55.jar and/or jconnect60.jar.
Below is a listing of the Aqua Data Studio library directory [ADS_HOME]\lib ...
Driver Location (Windows/Linux): [ADS_INSTALL]\lib\jconnect45.jar & [ADS_INSTALL]\lib\jconnect55.jar & [ADS_INSTALL]\lib\jconnect60.jar
Driver Location (OSX): /Aqua Data Studio/Contents/Resources/Java/jconnect45.jar & /Aqua Data Studio/Contents/Resources/Java/jconnect55.jar & /Aqua Data Studio/Contents/Resources/Java/jconnect60.jar
C:\Program Files\Aqua Data Studio 4.0\lib>dir
Volume in drive C is Local Disk
Volume Serial Number is 108C-AA92
Directory of C:\Program Files\Aqua Data Studio 4.0\lib
06/06/2005 03:35p DIR .
06/06/2005 03:35p DIR ..
06/25/2002 01:07p 54,368 activation.jar
02/08/2005 08:18a 5,217,547 datastudio.jar
06/27/2003 04:23p 1,146,367 db2java.jar
08/24/2004 02:05p 1,077,696 db2jcc.jar
08/15/2004 09:48p 1,013 db2jcc_license_cu.jar
06/07/2002 08:27a 531,797 ifxjdbc.jar
07/21/2002 10:45p 303,246 jconnect45.jar
04/30/2004 02:20a 896,049 jconnect55.jar
01/25/2005 08:35p 285,111 jtds.jar
08/28/2002 02:58p 305,434 mail.jar
01/21/2005 07:47p 1,773,208 mysql-jdbc.zip
12/23/2004 08:38p 391,434 mysql.jar
03/12/2005 10:27p 1,781,898 nlscharset12.jar
03/12/2005 10:27p 1,196,109 oracle.jar
01/12/2005 07:30p 286,005 postgresql.jar
09/23/2003 01:47p 119,947 xdb.jar
09/23/2003 01:47p 660,890 xmlparserv2.jar
21 File(s) 22,720,504 bytes
2 Dir(s) 35,225,890,816 bytes free
C:\Program Files\Aqua Data Studio 4.0\lib>
The Java class path for the drivers are already configured for ADS in the datastudio.cfg 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 followed ...
C:\Program Files\Aqua Data Studio 4.0>type datastudio.cfg
.
.\jre\bin\javaw.exe
-Xmx256M -cp ".\lib\datastudio.jar;.\lib\oracle.jar;
.\lib\nlscharset12.jar;.\lib\jtds.jar;
.\lib\mysql.jar;.\lib\postgresql.jar;
.\lib\jconnect45.jar;.\lib\db2java.jar;.\lib\db2jcc.jar;
.\lib\db2jcc_license_cu.jar;.\lib\ifxjdbc.jar;
.\lib\jconnect55.jar;.\lib\mail.jar;
.\lib\activation.jar;.\lib\xmlparserv2.jar;
.\lib\xdb.jar" com.aquafold.datastudio.DataStudio
C:\Program Files\Aqua Data Studio 4.0>type datastudio.bat
SET ADS_PATH=
SET ADS_PATH=%ADS_PATH%;.\lib\oracle.jar
SET ADS_PATH=%ADS_PATH%;.\lib\nlscharset12.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jtds.jar
SET ADS_PATH=%ADS_PATH%;.\lib\mysql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\postgresql.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jconnect45.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2jcc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2jcc_license_cu.jar
SET ADS_PATH=%ADS_PATH%;.\lib\db2java.jar
SET ADS_PATH=%ADS_PATH%;.\lib\ifxjdbc.jar
SET ADS_PATH=%ADS_PATH%;.\lib\jconnect55.jar
SET ADS_PATH=%ADS_PATH%;.\lib\xmlparserv2.jar
SET ADS_PATH=%ADS_PATH%;.\lib\xdb.jar
SET ADS_PATH=%ADS_PATH%;.\lib\mail.jar
SET ADS_PATH=%ADS_PATH%;.\lib\activation.jar
java -cp ".\lib\datastudio.jar;%ADS_PATH%" com.aquafold.datastudio.DataStudio
|
