The jConnect, SQL Anywhere 16 JDBC 4.0 driver, and the iAnywhere JDBC driver are supported by SAP Sybase IQ. The iAnywhere JDBC driver is deprecated.
Driver |
Definition |
|---|---|
jConnect |
This driver is a 100% pure Java driver. It communicates with SAP Sybase IQ using the TDS client/server protocol. |
|
SQL Anywhere 16 JDBC driver |
The SQL Anywhere JDBC 4.0 driver is recommended. The SQL Anywhere JDBC 4.0 driver provides some performance benefits and feature benefits compared to the pure Java jConnect JDBC driver; however, this driver does not provide a pure-Java solution. |
iAnywhere JDBC driver |
This driver is deprecated. The iAnywhere JDBC driver communicates with SAP Sybase IQ using the Command Sequence client/server protocol. Its behavior is consistent with ODBC, embedded SQL, and OLE DB applications. Interactive SQL supports this driver. |
For jConnect documentation, see jConnect for JDBC.
When choosing which driver to use, you may want to consider the following factors:
Features—All drivers are JDK 2 compliant. The SQL Anywhere 16 JDBC driver provides fully-scrollable cursors, which are not available in jConnect.
Pure Java—The jConnect driver is a pure Java solution. The SQL Anywhere 16 JDBC driver requires the SAP Sybase IQ or SQL Anywhere ODBC driver and is not a pure Java solution.
Performance—The SQL Anywhere 16 JDBC driver provides better performance for most purposes than the jConnect driver.
Compatibility—The TDS protocol used by the jConnect driver is shared with Adaptive Server Enterprise. Some aspects of the driver's behavior are governed by this protocol, and are configured to be compatible with Adaptive Server Enterprise.
Both drivers are available on Windows 95/98/Me and Windows NT/2000/2003/XP, as well as supported UNIX and Linux operating systems.
Java applications running in SAP Sybase IQ run slower than when run outside in a Sun Java Virtual Machine (JVM).