Sybase IQ JDBC Drivers

Aqua Data Studio comes bundled with the Sybase jConnect 16.0 JDBC drivers. These drivers are compatible with all Sybase IQ versions 12.5 - 16.0. It is also possible to use the Sybase iAnywhere drivers by following the steps below for Downloading and using Sybase iAnywhere JDBC Drivers.

Contents

• Sybase jConnect Driver Location
• Updating jConnect Drivers for use with Sybase IQ
• Downloading and using Sybase iAnywhere JDBC Drivers

Sybase jConnect Driver Location

You may locate the latest Sybase jConnect JDBC drivers at the following location ...

Vendor: Sybase (jConnect 7.0)
Driver URL: http://www.sybase.com/downloads

Database Product: Sybase IQ 12.5/12.6/12.7/15/15.2/15.4/16.0

Updating jConnect Drivers for use with Sybase IQ

To update the Aqua Data Studio jConnect JDBC drivers you need to overwrite the Aqua Data Studio jconnect16.jar. Below is a listing of the Aqua Data Studio library directory [ADS_HOME]\lib\drivers\ ...

Windows

[ADS_INSTALL]\lib\drivers\jconnect70.jar

C:\Program Files\Aqua Data Studio 14.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 14.0 - 64bit\lib\drivers

06/06/2013  09:20 AM    <DIR>          .
06/06/2013  09:20 AM    <DIR>          ..
06/05/2013  03:23 PM            15,364 cassandra-clientutil-extras.jar
06/05/2013  03:23 PM            36,549 cassandra-clientutil.jar
06/05/2013  03:23 PM           228,286 cassandra-jackson-core-asl.jar
06/05/2013  03:23 PM           765,648 cassandra-jackson-mapper-asl.jar
06/05/2013  03:23 PM         1,073,177 cassandra-thrift.jar
06/05/2013  03:23 PM         1,146,367 db2java.jar
06/05/2013  03:23 PM         3,348,681 db2jcc.jar
06/05/2013  03:23 PM             1,015 db2jcc_license_cu.jar
06/05/2013  03:23 PM         2,703,892 derby.jar
06/05/2013  03:23 PM           535,985 derbyclient.jar
06/05/2013  03:23 PM           242,891 derbynet.jar
06/05/2013  03:23 PM         4,707,593 hbase.jar
06/05/2013  03:23 PM         4,854,977 hive-exec.jar
06/05/2013  03:23 PM         3,081,632 hive-metastore.jar
06/05/2013  03:23 PM           265,212 hive-service.jar
06/05/2013  03:23 PM           812,386 ifxjdbc.jar
06/05/2013  03:23 PM         1,785,512 jconnect16.jar
06/05/2013  03:23 PM         4,581,825 jt400.jar
06/05/2013  03:23 PM           332,114 jtds-src.jar
06/05/2013  03:23 PM           330,879 jtds.jar
06/05/2013  03:23 PM           417,206 mongo.jar
06/05/2013  03:23 PM           651,205 mysql-src.jar
06/05/2013  03:23 PM           867,335 mysql.jar
06/05/2013  03:23 PM           445,188 ncluster.jar
03/18/2013  01:19 PM           344,843 nzjdbc.jar
06/05/2013  03:23 PM         2,714,189 ojdbc6.jar
06/05/2013  03:23 PM         1,656,248 orai18n.jar
06/05/2013  03:23 PM           346,944 paraccel-jdbc.jar
06/05/2013  03:23 PM           561,969 postgresql.jar
06/05/2013  03:23 PM           449,818 protobuf-java.jar
06/05/2013  03:23 PM         3,662,128 sqlite-jdbc.jar
06/05/2013  03:23 PM           286,773 util400.jar
06/05/2013  03:23 PM           262,740 xdb6.jar
06/05/2013  03:23 PM           839,982 xmlparserv2.jar
06/05/2013  03:23 PM           779,974 zookeeper.jar
              35 File(s)     45,136,527 bytes
               2 Dir(s)  53,721,489,408 bytes free

C:\Program Files\Aqua Data Studio 14.0 - 64bit\lib\drivers>

OSX

/Aqua Data Studio/Contents/Java/drivers/jconnect70.jar

Linux

[ADS_INSTALL]/lib/drivers/jconnect70.jar

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.

Downloading and using Sybase iAnywhere Drivers

The steps for installing the Sybase iAnywhere Drivers are as follows

1. Download the Sybase iAnywhere Driver installer from the Sybase website here: http://www.sybase.com/detail?id=1087327
2. Install the Sybase iAnywhere Driver on your system
3. OS Specific Setup instructions for Windows, Linux and OS X

Sybase iAnywhere Driver on Windows

1. Copy [SQL_iANYWHERE_DRIVER]\java\sajdbc4.jar into [ADS_HOME]\lib\drivers folder
2. Restart Aqua Data Studio

Sybase iAnywhere Driver on Linux

1. Setup the necessary environment variables by sourcing sa_config.sh: . [SQLANY_HOME]/System/bin[32 or 64]/sa_config.sh (or sa_config.csh). For further information, see Sybase help
2. Copy [SQLANY_HOME]/java/sajdbc4.jar into [ADS_HOME]/lib/drivers folder
3. Restart Aqua Data Studio

Sybase iAnywhere Driver on OS X

1. Setup the necessary environment variables by sourcing sa_config.sh: . Applications/SQLAnywhere12/System/bin64/sa_config.sh. For further information, see Sybase help
2. Copy [SQL_iANYWHERE_DRIVER]/java/sajdbc4.jar into [ADS_HOME]/Contents/Resources/Java/drivers folder
3. Launch ADS from the command line: open /Applications/Aqua\ Data\ Studio.app