Programming Information

Review the basic components of, and programming requirements for, jConnect for JDBC.

Start the jConnect driver, set connection properties, connect to a database server, and review information about using jConnect features. For information about JDBC programming, go to the resource page for Java developers at the Oracle Technology Network for Java.

• jConnect Version Property
  The JCONNECT_VERSION connection property determines the driver’s behavior and the features activated.
• Invoking the jConnect Driver
  Register and invoke jConnect, and add jConnect to the jdbc.drivers system property.
• Configuring jConnect for J2EE servers
  Use the com.sybase.jdbc4.jdbc.SybConnectionPoolDataSource class to configure connection pools to an Adaptive Server server in application servers such as EAServer.
• Establish a Connection
  Establish a connection to an Adaptive Server or SQL Anywhere database using jConnect.
• Internationalization and Localization
  Review the internationalization and localization issues relevant to jConnect.
• Database Issues
  Review the database issues relevant to jConnect.
• Variable-Length Rows in Data-Only-Locked Tables
  Versions of Adaptive Server earlier than 15.7 configured for 16K logical page sizes could not create data-only-locked (DOL) tables with variable-length rows if a variable-length column began more than 8191 bytes after the start of the row.
• Large Object (LOB) Support
  jConnect supports using large object (LOB) datatypes—text, unitext, and image
• Large Object Locator Support
  jConnect supports large object (LOB) locators. A LOB locator contains a logical pointer to LOB data rather than the data itself, reducing the amount of data that passes through the network between Adaptive Server and its clients.
• Advanced Features in jConnect
  jConnect provides advanced features such as event notification, error message handling, password encryption, dynamic class loading, and JDBC specification support.
• Restrictions and Interpretations of JDBC Standards
  The jConnect implementation of JDBC deviates from the JDBC standards.