Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ JDBC Driver GuideThe HCL OneDB™ JDBC Driver Programmer's Guide describes how to install, load, and use HCL OneDB™ JDBC Driver to connect to the HCL OneDB™ database from within a Java™ application.
Work with opaque types
Type cache information

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.