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.

By default the driver will 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.

In the database URL, you can set the property udtCache=false to disable the cache.