SDK 15.7 Features for jConnect and Adaptive Server Enterprise Drivers and Providers
New features in SDK 15.7 for jConnect, the Adaptive Server Enterprise ODBC Driver, the
Adaptive Server Enterprise OLE DB Provider, and the Adaptive Server Enterprise ADO.NET
Data Provider are introduced.
- ODBC Driver Version Information Utility
The odbcversion utility displays information about the ODBC driver.
- SupressRowFormat2 Connection String Property
With Adaptive Server Enterprise ODBC Driver 15.7, Adaptive Server Enterprise OLE DB Provider 15.7, and Adaptive Server Enterprise ADO.NET Data Provider 15.7, you can use the SupressRowFormat2 connection string property to force Adaptive Server to send data using the TDS_ROWFMT byte sequence where possible instead of the TDS_ROWFMT2 byte sequence.
- Enhancement to UseCursor Property
You can use the UseCursor connection string property of Adaptive Server Enterprise ODBC Driver to determine how server-side cursors are used for SQL statements that generate result sets.
- Log without ODBC Driver Manager Tracing
In Adaptive Server Enterprise ODBC Driver 15.7, you can log calls to ODBC APIs without using ODBC Driver Manager tracing. This is useful when the driver manager is not used or when running on a platform that does not support tracing.
- jConnect setMaxRows Enhancement
JDBC programs use Statement.setMaxRows(int max) to limit the number of rows returned by a result set. In jConnect 7.0 and earlier, the result of the select, insert, update, and delete statements are counted against the limit.
- TDS ProtocolCapture
Adaptive Server Enterprise ODBC Driver 15.7 introduces the ProtocolCapture connection string property which specifies a file for receiving Tabular Data Stream (TDS) packets exchanged between an ODBC application and Adaptive Server.
- ODBC Data Batching without Binding Parameter Arrays
When the same SQL statement is executed for different parameter values, client applications normally bind parameter arrays and execute each set of parameters using SQLExecute, SQLExecuteDirect, and SQLBulkOperations.
- Optimized Batching in jConnect
jConnect for JDBC 7.07 implements an internal algorithm to speed up batch operations for PreparedStatement objects.
- jConnect Parameter Batching without Row Accumulation
jConnect for JDBC 7.07 adds the SEND_BATCH_IMMEDIATE connection property.
- jConnect Batch Update Enhancement to Execute Past Errors
jConnect for JDBC 7.07 introduces the EXECUTE_BATCH_PAST_ERRORS connection property, which, when set to true, allows a batch update operation to ignore nonfatal errors encountered while executing individual statements and to complete the batch update.
- Support for Releasing Locks at Cursor Close
Adaptive Server 15.7 extends the declare cursor syntax to include the release_locks_on_close option, which releases shared cursor locks at isolation levels 2 and 3 when a cursor is closed. Adaptive Server Enterprise ODBC Driver 15.7 and jConnect for JDBC 7.07 support the release-lock-on-close semantics.
- select for update Support
Adaptive Server 15.7 supports select for update, which can lock rows for subsequent updates within the same transaction, and supports exclusive locks for updatable cursors.
- Support for Expanded Variable-length Rows
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. This limitation has been removed starting in Adaptive Server 15.7.
- Support for Nonmaterialized Columns
The bulk insert routines in the Adaptive Server Enterprise ODBC Driver 15.7 have been enhanced to handle nonmaterialized columns in Adaptive Server 15.7.
- In-row and off-row LOB Storage Support
In Adaptive Server 15.7, LOB columns that are marked for in-row storage are stored in-row when there is adequate memory to hold the entire row.
- Large Objects as Stored Procedure Parameters
Passing LOB data as stored procedure input parameters has also been introduced in Adaptive Server 15.7.
- Large Object Locator Support
jConnect for JDBC 7.07 and Adaptive Server Enterprise ODBC Driver 15.7 support large object (LOB) locators.
Created March 10, 2014. Send feedback on this help topic to Technical Publications:
pubs@sap.com