Data Type Mapping Between Extended Types and Java and JDBC Types

Home | Previous Page | Next Page Appendix C. Mapping Data Types > Data Type Mapping Between Informix and JDBC Data Types >

Data Type Mapping Between Extended Types and Java and JDBC Types

The following table lists mappings between the extended data types supported in IBM Informix Dynamic Server and the corresponding Java and JDBC types.

JDBC Type	Java Object Type	Informix Type
java.sql.Types.LONGVARCHAR	java.sql.String java.io.inputStream	LVARCHAR IfxTypes.IFX_TYPE_LVARCHAR
java.sql.Types.JAVA_OBJECT	java.sql.SQLData	Opaque type IfxTypes.IFX_TYPE_UDTFIXED IfxTypes.IFX_TYPE_UDTVAR
java.sql.Types.LONGVARBINARY java.sql.Types.BLOB	java.sql.Blob java.io.inputStream byte[]	BLOB IfxTypes.IFX_TYPE_BLOB
java.sql.Types.LONGVARCHAR java.sql.Types.CLOB	java.sql.Clob java.io.inputStream java.lang.String	CLOB IfxTypes.IFX_TYPE_CLOB
java.sql.Types.LONGVARBINARY java.sql.Types.BLOB	java.io.inputStream java.sql.Blob byte[]	BYTE IfxTypes.IFX_TYPE_BYTE
java.sql.Types.LONGVARCHAR java.sql.Types.CLOB	java.io.InputStream java.sql.Clob java.sql.String	TEXT IfxTypes.IFX_TYPE_TEXT
java.sql.Types.JAVA_OBJECT java.sql.Types.STRUCT	java.sql.SQLData java.sql.Struct	Named row IfxTypes.IFX_TYPE_ROW
java.sql.Types.STRUCT	java.sql.Struct	Unnamed row IfxTypes.IFX_TYPE_ROW
java.sql.Types.ARRAY java.sql.Types.OTHER	java.sql.Array java.util.LinkedList java.util.HashSet java.util.TreeSet	set, multiset IfxTypes.IFX_TYPE_SET IfxTypes.IFX_TYPE_MULTISET
java.sql.Types.ARRAY java.sql.Types.OTHER	java.sql.Array java.util.ArrayList java.util.LinkedList	LIST IfxTypes.IFX_TYPE_LIST

A Java boolean object can map to an Informix smallint data type or an Informix boolean data type. IBM Informix JDBC Driver attempts to map it according to the column type. However, in cases such as PreparedStatement host variables, IBM Informix JDBC Driver cannot access the column types, so the mapping is somewhat limited. For more details on data type mapping, refer to Data Type Mapping for PreparedStatement.setXXX() Extensions.