Adaptive Server offers limits and parameters that are larger than in 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 inserting data into tables.
To ensure that jConnect requests wide table support from the database, the default setting of JCONNECT_VERSION must be 6 or later.
jConnect continues to work with an Adaptive Server version
12.5 and later if you set JCONNECT_VERSION to earlier than
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 JCONNECT_VERSION to 6 or later 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.
In addition to the larger number of columns and parameters, wide table support provides extended result set metadata. For example, in versions of 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.
