Large Object Locator Support

jConnect for JDBC 7.07 and Adaptive Server Enterprise ODBC Driver 15.7 support 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. Server support for LOB locators was introduced in Adaptive Server 15.7.

jConnect for JDBC 7.07 accesses LOB data using server-side locators when connected to an Adaptive Server that supports LOB locators and autocommit is turned off. Otherwise, jConnect materializes LOB data at the client side. You can use the complete LOB API with client-side materialized LOB data, however, due to larger data, API performance may be different than when used with LOB locators.

Adaptive Server Enterprise ODBC Driver 15.7 clients cannot use LOB locators unless connected to an Adaptive Server that supports it.

Note: When you are using LOB locators, retrieving a large result set that includes LOB data on each row may impact your application's performance. Adaptive Server returns a LOB locator as part of the result set and, to obtain LOB data, jConnect and ODBC Driver must cache the remaining result set. Sybase recommends that you keep result sets small, or that you enable cursor support to limit the size of data to be cached.

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.
Adaptive Server Enterprise ODBC Driver Support
To enable LOB locator support, establish a connection to Adaptive Server with the EnableLOBLocator connection property set to 1.

Parent topic: SDK 15.7 Features for jConnect and Adaptive Server Enterprise Drivers and Providers