Mapping SQL datatypes to Java datatypes
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
The following table shows the corresponding Java datatypes that dam_getBulkValueToSet returns for the SQL datatypes while using Java.
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 |