Mapping Types |
Java Type |
ANSI SQL types |
Integer |
Int or java.lang.Integer |
INTEGER |
Long |
Long or java.lang.Long |
BIGINT |
Short |
Short or java.lang.Short |
SMALLINT |
Float |
Float or java.lang.Float |
FLOAT |
Double |
double or java.lang.Double |
DOUBLE |
big_decimal |
java.math.BigDecimal |
NUMERIC |
Character |
java.lang.String |
CHAR(1) |
String |
java.lang.String |
VARCHAR |
Byte |
byte or java.lang.Byte |
TINYINT |
Boolean |
boolean or java.lang.Boolean |
BIT |
yes/no |
boolean or java.lang.Boolean |
CHAR(1) ('Y' or 'N') |
true/false |
boolean or java.lang.Boolean |
CHAR(1) ('T' or 'F') |
Mapping Types |
Java Type |
ANSI SQL types |
Date |
java.util.Date or java.sql.Date |
DATE |
Time |
java.util.Date or java.sql.Time |
TIME |
Timestamp |
java.util.Date or java.sql.Timestamp |
TIMESTAMP |
Calendar |
java.util.Calendar |
TIMESTAMP |
calendar_date |
java.util.Calendar |
DATE |
Mapping Types |
Java Type |
ANSI SQL types |
Binary |
Byte[] |
VARBINARY (or BLOB) |
Text |
java.lang.String |
CLOB |
Serializable |
any Java class that implements java.io.Serializable |
VARBINARY (or BLOB) |
Clob |
java.sql.Clob |
CLOB |
Blob |
java.sql.Blob |
BLOB |
Mapping Types |
Java Type |
ANSI SQL types |
Class |
java.lang.Class |
VARCHAR |
Locale |
java.util.Locale |
VARCHAR |
Timezone |
java.util.TimeZone |
VARCHAR |
Currency |
java.util.Currency |
VARCHAR |