Programming Information

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

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

• SAP jConnect Version Property
  The JCONNECT_VERSION connection property determines the driver’s behavior and the features activated.
• Invoking the SAP jConnect Driver
  Register and invoke SAP jConnect, and add SAP jConnect to the jdbc.drivers system property.
• Configuring SAP jConnect for J2EE servers
  Use the com.sybase.jdbc4.jdbc.SybConnectionPoolDataSource class to configure connection pools to an SAP Adaptive Server server in application servers such as EAServer.
• Establish a Connection
  Establish a connection to an SAP Adaptive Server or SAP SQL Anywhere database using SAP jConnect.
• Internationalization and Localization
  Review the internationalization and localization issues relevant to SAP jConnect.
• Database Issues
  Review the database issues relevant to SAP jConnect.
• Variable-Length Rows in Data-Only-Locked Tables
  Versions of SAP 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
  SAP jConnect supports using large object (LOB) datatypes—text, unitext, and image
• Large Object Locator Support
  SAP 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 SAP Adaptive Server and its clients.
• Advanced Features in SAP jConnect
  SAP 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 SAP jConnect implementation of JDBC deviates from the JDBC standards.