JCONNECT_VERSION Connection Property

Use the JCONNECT_VERSION connection property to override the SybDriver version setting and specify a different version setting for a specific connection.

See the valid JCONNECT_VERSION values and the jConnect characteristics associated with these values.

Features Associated with jConnect Version

JCONNECT_VERSION

Features

7.0

jConnect 7.0 behaves in the same way as jConnect 6.05, except that in 7.0, jConnect requests support for:
  • bigdatetime and bigtime SQL datatypes from the server. Versions of Adaptive Server earlier than 15.5 ignore this request.

  • JDBC 4.0.

  • Valid values of ENABLE_BULK_LOAD are null (default), ARRAYINSERT_WITH_MIXED_STATEMENTS, ARRAYINSERT, BCP, and LOG_BCP.

6.05

jConnect 6.05 behaves in the same way as jConnect 6.0, except that in 6.05, jConnect requests support for:
  • Computed columns, including metadata.

  • Larger identifiers. With large identifiers, you can use identifiers or object names with lengths of up to 255 bytes. The large identifier applies to most user-defined identifiers, including table name, column name, and index name.

6.0

jConnect 6.0 behaves in the same way as jConnect 5.x, except that in 6.0, jConnect requests support for:
  • date and time SQL datatypes. Versions of Adaptive Server earlier than 12.5.1 ignore this request.

  • unichar and univarchar datatypes from the server. Versions of Adaptive Server earlier than 12.5.1 ignore this request.

  • Wide tables from the server. Versions of Adaptive Server earlier than 12.5.1 ignore this request.

  • Default value of DISABLE_UNICHAR_SENDING is false.

5.0

jConnect 5.x behaves in the same way as jConnect 4.0.

4.0

jConnect 4.0 behaves in the same way as jConnect 3.0, except that in 4.0, jConnect requests support for:

  • The default value of the LANGUAGE connection property is null.

  • The default behavior of Statement.cancel is to cancel only the Statement object on which it is invoked. This behavior is JDBC-compliant.

    Use CANCEL_ALL to set the behavior of Statement.cancel.

  • You can use JDBC 2.0 methods to store and retrieve Java objects as column data.

3.0

jConnect 3.0 behaves in the same way as jConnect 2.0, except that in 3.0:
  • If the CHARSET connection property does not specify a character set, jConnect uses the default character set of the database.

  • The default value for CHARSET_CONVERTER is the CheckPureConverter class.

2.0

  • The default value of the LANGUAGE connection property is us_english.

  • If the CHARSET connection property does not specify a character set, the default character set is iso_1.

  • The default value for CHARSET_CONVERTER is the TruncationConverter class, unless the CHARSET connection property specifies a multibyte or 8-bit character set, in which case the default CHARSET_CONVERTER is the CheckPureConverter class.

  • The default behavior of Statement.cancel is to cancel the object it is invoked on and any other Statement objects that have begun to execute and are waiting for results. This behavior is not JDBC-compliant.

    Use CANCEL_ALL to set the behavior of Statement.cancel.

Related concepts
JDBC 4.0 Specifications Support
Restrictions and Interpretations of JDBC Standards
jConnect Character Set Converters
Related tasks
Using jConnect to Pass Unicode Data
Related reference
Date and Time Datatypes
JDBC 3.0 Specifications Support
Wide Table Support for Adaptive Server
Store Java Objects as Column Data in Table