This section explains the mapping between the data types that are recognized in the Java language and the data types that are recognized by HiRDB.
Table 1-25 shows the implicit mapping that occurs when a Java signature specifying an external routine is omitted. Table 1-26 shows the mapping between the Java data types that can be specified in a Java signature with an external routine specification and the HiRDB data types.
Table 1-25 Implicit mapping that occurs when a Java signature specifying an external routine is omitted
HiRDB data type | Java data type (null value allowed) |
---|---|
INT [EGER] | java.lang.Integer |
SMALLINT | java.lang.Short |
[LARGE] DEC [IMAL] | java.math.BigDecimal |
FLOAT, DOUBLE PRECISION | java.lang.Double |
SMALLFLT, REAL | java.lang.Float |
CHAR [ACTER] | java.lang.String |
VARCHAR(n), CHAR [ACTER] VARYING | |
NCHAR, NATIONAL CHAR [ACTER] | |
NVARCHAR, NATIONAL CHAR [ACTER], NCHAR VARYING | |
MCHAR | |
MVARCHAR | |
DATE | java.sql.Date |
TIME | java.sql.Time |
TIMESTAMP | java.sql.Timestamp |
INTERVAL YEAR TO DAY | java.math.BigDecimal |
INTERVAL HOUR TO SECOND | |
BLOB, BINARY LARGE OBJECT | byte[] |
BINARY |
Table 1-26 Mapping between Java data types specifiable in a Java signature with an external routine specification and HiRDB data types
HiRDB data type | Java data type (null value allowed) | Java data type (null value not allowed)1 |
---|---|---|
INT [EGER] | java.lang.Integer | int |
SMALLINT | java.lang.Short | short |
[LARGE] DEC [IMAL] | java.math.BigDecimal | ![]() |
FLOAT, or DOUBLE PRECISION | java.lang.Double | double |
SMALLFLT, or REAL | java.lang.Float | float |
CHAR [ACTER] | java.lang.String, or byte[]2 | ![]() |
VARCHAR(n), or CHAR [ACTER] VARYING | ||
NCHAR, or NATIONAL CHAR [ACTER] | ||
NVARCHAR, NATIONAL CHAR [ACTER], or NCHAR VARYING | ||
MCHAR | ||
MVARCHAR | ||
DATE | java.sql.Date | ![]() |
TIME | java.sql.Time | |
TIMESTAMP | java.sql.Timestamp | |
INTERVAL YEAR TO DAY | java.math.BigDecimal | |
INTERVAL HOUR TO SECOND | ||
BLOB, or BINARY LARGE OBJECT | byte[] | |
BINARY | ||
Abstract data type | ![]() |