Type cache information
When objects of some data types insert data into columns of certain other data types, HCL OneDB™ JDBC Driver verifies that the data provided matches the data the database server expects by calling the SQLData.getSQLTypeName() method. The driver asks the database server for the type information with each insertion.
This occurs in the following cases:
- When an SQLData object inserts data into an opaque type column and getSQLTypeName() returns the name of the opaque type
- When a Struct or SQLData object inserts data into a row column and getSQLTypeName() returns the name of a named row
- When an SQLData object inserts data into a DISTINCT type column,
In
the database URL, you can set the environment variable ENABLE_TYPE_CACHE=TRUE to
have the driver cache the data type information the first time it
is retrieved. The driver then asks the cache for the type information
before requesting the data from the database server.