Map opaque data types

opaque types map to Java objects, which must implement the java.sql.SQLData interface. These Java objects describe all the data members that make up the opaque type. These Java objects are strongly typed; that is, each read or write method in the readSQL or writeSQL method of the Java object must match the corresponding data member in the opaque type definition.Informix® JDBC Driver cannot perform any type conversion because the type structure is unknown to it.

Informix® JDBC Driver also requires that all opaque data be transported as Informix® DataBlade® API data types, as defined in mitypes.h (this file is included in all installations). All opaque data is stored in the database server table in a C struct, which is made up of various DataBlade® API types, as defined in the opaque type.

You do not need to handle mapping between Java and C if you use the UDT and UDR Manager facility to create opaque types. For more information, see Creating opaque types and UDRs.