skip to main content
Designing and coding the IP : Bulk insert : Mapping SQL datatypes to Java datatypes
 

Mapping SQL datatypes to Java datatypes

The following table shows the corresponding Java datatypes that dam_getBulkValueToSet returns for the SQL datatypes while using Java.
 
Table 16: Mapping SQL datatypes to Java datatypes
SQL DataTypes
Java DataTypes
XO_TYPE_CHAR
An array of String[] objects
XO_TYPE_VARCHAR
An array of String[] objects
XO_TYPE_WCHAR
An array of String[] objects
XO_TYPE_WVARCHAR
An array of String[] objects
XO_TYPE_NUMERIC
An array of String[] objects
XO_TYPE_DECIMAL
An array of String[] objects
XO_TYPE_BIGINT
An array of String[] objects
XO_TYPE_INTEGER
An array of Integer[] objects
XO_TYPE_SMALLINT
An array of Short[] objects
XO_TYPE_TINYINT
An array of Byte[] objects
XO_TYPE_BIT
An array of Boolean[] objects
XO_TYPE_REAL
An array of Float[] objects
XO_TYPE_DOUBLE
An array of Double[] objects
XO_TYPE_FLOAT
An array of Double[] objects
XO_TYPE_DATE
An array of String[] objects
XO_TYPE_TIME
An array of String[] objects
XO_TYPE_TIMESTAMP
An array of String[] objects
XO_TYPE_BINARY
An array of byte[] objects
XO_TYPE_VARBINARY
An array of byte[] objects