Wide Table Support for Adaptive Server

SAP Adaptive Server 15.7 ESD #1 offers limits and parameters that are larger than previous versions of the database server.

For example:

Tables can contain 1024 columns.
varchar and varbinary columns can contain more than 255 bytes of data.
You can send and retrieve up to 2048 parameters when invoking stored procedures or as parameters to PreparedStatement.
When connected to SAP Adaptive Server 15.7 ESD #1 and later, you can send and retrieve up to 32767 parameters to PreparedStatement.

To ensure that SAP jConnect requests wide table support from the database, the default setting of JCONNECT_VERSION must be 6.0 or later.

Note: SAP jConnect continues to work with an SAP Adaptive Server version 12.5 and later if you set JCONNECT_VERSION to earlier than 6.0. However, if you try selecting from a table that requires wide table support to fully retrieve the data, you may encounter unexpected errors or data truncation.

You can also set JCONNECT_VERSION to 6.0 or later when you access data from a SAP Adaptive Server that does not support wide tables. In this case, the server simply ignores your request for wide table support.

In addition to the larger number of columns and parameters, wide table support provides extended result set metadata. For example, in versions of SAP jConnect earlier than 6.0, the ResultSetMetaData methods getCatalogName, getSchemaName, and getTableName all returned Not Implemented SQLExceptions because that metadata was not supplied by the server. When you enable wide table support, the server now sends back this information, and the three methods return useful information.