jConnect Version Property

The JCONNECT_VERSION connection property determines the driver’s behavior and the features activated.

For example, Adaptive Server 15.5 supports both jConnect 6.05 and 7.0, however, these two versions process datetime and time data differently. When connecting to Adaptive Server 15.5, jConnect 7.0, which supports microsecond granularity for time data, uses bigdatetime or bigtime even if the target Adaptive Server columns are defined as datetime or time. jConnect 6.05, however, does not support microsecond granularity and always transfers datetime or time data when connecting to Adaptive Server 15.5.

You can set the jConnect version by using either the SybDriver.setVersion method or the JCONNECT_VERSION connection property.