Adaptive Server version 12.5 and later offers limits and parameters that are larger than in previous versions of the database server. For example:
You must use jConnect 5.5 or later to access the wide
table functionality in Adaptive Server version 12.5 and later.
Tables can contain 1,024 columns.
Varchar and varbinary columns can contain more than 255 bytes of data.
You can send and retrieve up to 2,048 parameters when invoking stored procedures or inserting data into tables.
To take advantage of this capability, jConnect version 5.5 and later users need to set their JCONNECT_VERSION property to VERSION_6 or VERSION_LATEST. This will request that the server enable wide table support.
jConnect continues to work with an Adaptive Server version
12.5 and later if you set the version to below VERSION_6.
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 the version to VERSION_6 or VERSION_LATEST when you access data from a Sybase server that does not support wide tables. In this case, the server simply ignores your request for wide table support.
Wide table support offers an extra benefit for jConnect users, besides the larger number of columns and parameters—a greater amount of ResultSetMetaData. For example, in versions of jConnect earlier than 5.5, 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.
Copyright © 2003. Sybase Inc. All rights reserved. |
![]() |