2.7.10 Sybase ASE JDBC Drivers (Revision #6)

JDBC Drivers - 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\drivers\ ...

Driver Location (Windows/Linux):
[ADS_INSTALL]\lib\drivers\jconnect45.jar
[ADS_INSTALL]\lib\drivers\jconnect55.jar
[ADS_INSTALL]\lib\drivers\jconnect60.jar
Driver Location (OSX):
/Aqua Data Studio/Contents/Resources/Java/drivers/jconnect45.jar
/Aqua Data Studio/Contents/Resources/Java/drivers/jconnect55.jar
/Aqua Data Studio/Contents/Resources/Java/drivers/jconnect60.jar

C:\Program Files\Aqua Data Studio 7.0 - 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.0 - 32bit\lib\drivers05/30/2008  08:48 AM    dir          .05/30/2008  08:48 AM    dir          ..03/20/2008  10:05 PM         1,146,367 db2java.jar03/20/2008  10:05 PM         1,973,658 db2jcc.jar03/20/2008  10:05 PM             1,015 db2jcc_license_cu.jar03/20/2008  10:05 PM         2,343,388 derby.jar03/20/2008  10:05 PM           489,802 derbyclient.jar04/05/2008  01:15 PM           218,162 derbynet.jar03/20/2008  10:05 PM           685,631 ifxjdbc.jar03/20/2008  10:05 PM           529,560 jconnect60.jar03/20/2008  10:05 PM         4,301,866 jt400.jar03/20/2008  10:05 PM           554,589 jtds-src.jar05/06/2008  09:46 PM           297,610 jtds.jar03/20/2008  10:05 PM           655,034 mysql-src.jar03/20/2008  10:05 PM           676,693 mysql.jar04/16/2008  09:29 AM         1,645,114 nlscharset12.jar04/16/2008  09:29 AM         1,545,954 oracle.jar03/20/2008  10:05 PM           415,542 postgresql.jar03/20/2008  10:05 PM           286,771 util400.jar03/20/2008  10:05 PM           139,148 xdb.jar03/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.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 follows ...

C:\Program Files\Aqua Data Studio 6.5>type datastudio.cfg..\jre\bin\javaw.exe-Dsun.swing.enableImprovedDragGesture -Xmx256M -cp ".\lib\ads.jar;.\lib\aqua-lib.jar;.\lib\aspc.jar;.\lib\aqua2.jar;.\lib\oracle.jar;.\lib\nlscharset12.jar;.\lib\jtds.jar;.\lib\derby.jar;.\lib\derbyclient.jar;.\lib\mysql.jar;.\lib\postgresql.jar;.\lib\db2java.jar;.\lib\db2jcc.jar;.\lib\db2jcc_license_cu.jar;.\lib\ifxjdbc.jar;.\lib\jconnect55.jar;.\lib\jconnect60.jar;.\lib\xmlparserv2.jar;.\lib\xdb.jar;.\lib\activation.jar;.\lib\jaxb1-impl.jar;.\lib\jaxb-api.jar;.\lib\jaxb-impl.jar;.\lib\jaxb-xjc.jar;.\lib\jsr173_1.0_api.jar;.\lib\stringtemplate.jar;.\lib\jide-action.jar;.\lib\jide-beaninfo.jar;.\lib\jide-common.jar;.\lib\jide-components.jar;.\lib\jide-dialogs.jar;.\lib\jide-dock.jar;.\lib\jide-grids.jar;.\lib\jide-pivot.jar;.\lib\jide-shortcut.jar" com.aquafold.datastudio.DataStudio        

C:\Program Files\Aqua Data Studio 6.5>type datastudio.batSET ADS_PATH=SET ADS_PATH=%ADS_PATH%;.\lib\oracle.jarSET ADS_PATH=%ADS_PATH%;.\lib\nlscharset12.jarSET ADS_PATH=%ADS_PATH%;.\lib\jtds.jarSET ADS_PATH=%ADS_PATH%;.\lib\derby.jarSET ADS_PATH=%ADS_PATH%;.\lib\derbyclient.jarSET ADS_PATH=%ADS_PATH%;.\lib\mysql.jarSET ADS_PATH=%ADS_PATH%;.\lib\postgresql.jarSET ADS_PATH=%ADS_PATH%;.\lib\db2jcc.jarSET ADS_PATH=%ADS_PATH%;.\lib\db2jcc_license_cu.jarSET ADS_PATH=%ADS_PATH%;.\lib\db2java.jarSET ADS_PATH=%ADS_PATH%;.\lib\ifxjdbc.jarSET ADS_PATH=%ADS_PATH%;.\lib\jconnect55.jarSET ADS_PATH=%ADS_PATH%;.\lib\jconnect60.jarSET ADS_PATH=%ADS_PATH%;.\lib\aqua-lib.jarSET ADS_PATH=%ADS_PATH%;.\lib\aqua2.jarSET ADS_PATH=%ADS_PATH%;.\lib\xmlparserv2.jarSET ADS_PATH=%ADS_PATH%;.\lib\xdb.jarSET ADS_PATH=%ADS_PATH%;.\lib\activation.jarSET ADS_PATH=%ADS_PATH%;.\lib\aspc.jarSET ADS_PATH=%ADS_PATH%;.\lib\jaxb1-impl.jarSET ADS_PATH=%ADS_PATH%;.\lib\jaxb-api.jarSET ADS_PATH=%ADS_PATH%;.\lib\jaxb-impl.jarSET ADS_PATH=%ADS_PATH%;.\lib\jaxb-xjc.jarSET ADS_PATH=%ADS_PATH%;.\lib\jsr173_1.0_api.jarSET ADS_PATH=%ADS_PATH%;.\lib\stringtemplate.jarSET ADS_PATH=%ADS_PATH%;.\lib\jide-action.jarSET ADS_PATH=%ADS_PATH%;.\lib\jide-beaninfo.jarSET ADS_PATH=%ADS_PATH%;.\lib\jide-common.jarSET ADS_PATH=%ADS_PATH%;.\lib\jide-components.jarSET ADS_PATH=%ADS_PATH%;.\lib\jide-dialogs.jarSET ADS_PATH=%ADS_PATH%;.\lib\jide-dock.jarSET ADS_PATH=%ADS_PATH%;.\lib\jide-grids.jarSET ADS_PATH=%ADS_PATH%;.\lib\jide-pivot.jarSET ADS_PATH=%ADS_PATH%;.\lib\jide-shortcut.jar