Data type mapping for UDT manager and UDR manager
When you use the UDTManager and UDRManager classes to create opaque types and Java™ UDRs in the database server, the driver maps Java™ method arguments and return types to SQL data types according to the tables in this section. Any data type not shown in these tables is not supported.
If the Java™ method has arguments of any of the following Java™ types, the arguments and return type are mapped to SQL types in the server as shown in the following table. The table shows the HCL Informix® data type to which each Java™ data type maps.
Java™ data type | SQL data type |
---|---|
boolean, java.lang.Boolean | BOOLEAN |
char | CHAR(1) |
byte | CHAR(1) |
short, java.lang.Short | SMALLINT |
int, java.lang.Integer | INT |
long, java.lang.Long | INT8 |
float, java.lang.Float | SMALLFLOAT |
double, java.lang.Double | FLOAT1 |
java.lang.String | LVARCHAR |
java.math.BigDecimal | DECIMAL Default precision is set by the server
to be: DECIMAL( |
java.sql.Date | DATE |
java.sql.Time | DATETIME HOUR TO SECOND |
java.sql.Timestamp | DATETIME YEAR TO FRACTION(5) |
com.informix.lang.IntervalYM | INTERVAL YEAR TO MONTH |
com.informix.lang.IntervalDF | INTERVAL DAY TO FRACTION(5) |
java.sql.Blob | BLOB |
java.sql.Clob | CLOB |
1 This mapping is JDBC compliant. You can map the Java™ double data type (via the JDBC FLOAT data type) to the Informix® SMALLFLOAT data type for backward compatibility by setting the IFX_GET_SMFLOAT_AS_FLOAT environment variable to 1.