ASA Programming Guide
JDBC Programming
JDBC overview
Two JDBC drivers are provided for Adaptive Server Anywhere:
jConnect This driver is a 100% pure Java driver. It communicates with Adaptive Server Anywhere using the TDS client/server protocol.
For jConnect documentation, see http://sybooks.sybase.com/jc.html.
iAnywhere JDBC driver This driver communicates with Adaptive Server Anywhere using the Command Sequence client/server protocol. Its behavior is consistent with ODBC, embedded SQL, and OLE DB applications.
When choosing which driver to use, you may want to consider the following factors:
Features Both drivers are JDK 2 compliant. The iAnywhere JDBC driver provides fully-scrollable cursors, which are not available in jConnect.
Pure Java The jConnect driver is a pure Java solution. The iAnywhere JDBC driver requires the Adaptive Server Anywhere ODBC driver and is not a pure Java solution.
Performance The iAnywhere 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/XP, as well as supported UNIX and Linux operating systems. They are not available on NetWare or Windows CE.