PRE_CACHE_DATATYPE_INFO Connection Property in jConnect

jConnect uses the PRE_CACHE_DATATYPE_INFO connection property to cache datatype metadata at login, which enhances data access performance for subsequent uses.

If you repeatedly use Statement or its derived interfaces to obtain datatype metadata, setting PRE_CACHE_DATATYPE_INFO to true might improve performance.

When PRE_CACHE_DATATYPE_INFO is set to true, information about all user-defined datatypes that serve various ResultsetMetadata APIs, like isCaseSensitive and isSearchable, is cached at connection time. Subsequent access to this information is then available from the cache.

When PRE_CACHE_DATATYPE_INFO is false (the default), jConnect does not cache any user-defined datatype information.

Note: Depending on the number of user-defined datatypes that exist in the database to which the connection is being obtained, the time it takes to establish the connection may increase.
Parent topic: SDK 15.7 Features for Adaptive Server Enterprise Drivers and Providers