jConnect for JDBC Support

To enable LOB locator support, establish a connection to Adaptive Server with the ENABLE_LOB_LOCATORS connection property set to true.

When enabled, client applications can access the locators using the Blob, Clob, and NClob classes from the java.sql package.

Note: When both LOB locators and autocommit are enabled, jConnect automatically switches the LOB locators to client-side-materialized LOB locators even if the connected Adaptive Server is capable of supporting them. This increases the memory used by the client and may degrade performance. Therefore, it is advisable to use LOB locators with autocommit off.

For information about the Blob, Clob, and NClob classes, see the Java documentation.