Caching Type Information

When objects of some data types insert data into columns of certain other data types, IBM Informix 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

You can set an environment variable, ENABLE_CACHE_TYPE=1, in the database URL, to have the driver cache the 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.