Skip to end of metadata
Go to start of metadata

Type mapping

 This section describes the mapping between Castor sql type java.sql.Types constant, java data type, sql type of supported database.

  Castor Type

JDBC Type

Java Object Type

MySQL 

PostgreSQL

Oracle 

Derby 

MSSQL

SapDB

DB2

Sybase

HSQL

PointBase 

BIT

BIT

java.lang.Boolean

TINYINT(1)

BOOLEAN

BOOLEAN

CHAR FOR BIT DATA

 BIT

BOOLEAN


BIT

BIT

 BOOLEAN

TINYINT

TINYINT

java.lang.Byte

TINYINT

SMALLINT

SMALLINT

SMALLINT

TINYINT

SMALLINT 

SMALLINT 

TINYINT

TINYINT

SMALLINT

SMALLINT

SMALLINT

java.lang.Short

SMALLINT

SMALLINT

SMALLINT

SMALLINT 

SMALLINT

SMALLINT

SMALLINT

SMALLINT

SMALLINT

SMALLINT

INTEGER

INTEGER

java.lang.Integer

INTEGER

INTEGER

INTEGER

INTEGER

INTEGER

INTEGER 

INTEGER

INTEGER

INTEGER

INTEGER

BIGINT

BIGINT

java.lang.Long

BIGINT

BIGINT

NUMERIC

BIGINT

BIGINT

INTEGER

BIGINT

INTEGER

BIGINT

NUMERIC

FLOAT

FLOAT

java.lang.Double

FLOAT

DOUBLE PRECISION

FLOAT

FLOAT

FLOAT

FLOAT

FLOAT

FLOAT

FLOAT

FLOAT

DOUBLE

DOUBLE

java.lang.Double

DOUBLE

DOUBLE PRECISION

DOUBLE PRECISION

DOUBLE

DOUBLE PRECISION 

DOUBLE PRECISION

DOUBLE

DOUBLE PRECISION

DOUBLE PRECISION

DOUBLE PRECISION

REAL

REAL

java.lang.Float

REAL

REAL

REAL

REAL

REAL

DOUBLE PRECISION

REAL 

REAL

REAL

REAL

NUMERIC

NUMERIC

java.math.BigDecimal

NUMERIC

NUMERIC

NUMERIC

NUMERIC

NUMERIC

NUMERIC

NUMERIC

NUMERIC

NUMERIC

NUMERIC 

DECIMAL

DECIMAL

java.math.BigDecimal

DECIMAL

NUMERIC

DECIMAL

DECIMAL

DECIMAL

DECIMAL

DECIMAL

DECIMAL

DECIMAL

DECIMAL

CHAR

CHAR

java.lang.String

CHAR

CHAR

CHAR

CHAR

CHAR

CHAR

CHAR

CHAR

CHAR

CHAR

VARCHAR

VARCHAR

java.lang.String

VARCHAR

VARCHAR

VARCHAR2

VARCHAR

VARCHAR

VARCHAR

VARCHAR

VARCHAR

VARCHAR

VARCHAR

LONGVARCHAR

LONGVARCHAR

java.lang.String

VARCHAR

VARCHAR

LONG

LONG VARCHAR

TEXT

LONG

LONG VARCHAR

TEXT

LONGVARCHAR

CLOB

DATE       

DATE       

java.sql.Date

DATE

DATE

DATE

DATE

DATETIME 

DATE

DATE

DATETIME

DATE 

DATE

TIME       

TIME       

java.sql.Time

TIME

TIME

DATE

TIME

DATETIME

TIME

TIME

DATETIME

TIME 

TIME

TIMESTAMP  

TIMESTAMP  

java.sql.Timestamp

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP

BINARY     

BINARY     

byte[]

BINARY

BYTEA

RAW

CHAR [n] FOR BIT DATA

BINARY

BLOB

CHAR [n] FOR BIT DATA

BINARY

BINARY

BLOB

VARBINARY

VARBINARY

byte[]

VARBINARY

BYTEA

LONG RAW

VARCHAR [] FOR BIT DATA

VARBINARY

BLOB

VARCHAR [] FOR BIT DATA

VARBINARY

VARBINARY

BLOB

LONGVARBINARY

LONGVARBINARY

byte[]

VARBINARY

BYTEA

LONG RAW

LONG VARCHAR FOR BIT DATA

IMAGE

BLOB

LONG VARCHAR FOR BIT DATA

VARBINARY

LONGVARBINARY

BLOB

OTHER

OTHER

java.lang.Object

BLOB

BYTEA

BLOB

BLOB

IMAGE

BLOB

BLOB

IMAGE

OTHER

BLOB

JAVA_OBJECT

JAVA_OBJECT

java.lang.Object

BLOB

BYTEA

BLOB

BLOB 

IMAGE

BLOB

BLOB

IMAGE

OBJECT

BLOB

BLOB

BLOB

java.io.InputStream

BLOB

BYTEA

BLOB

BLOB

IMAGE

BLOB

BLOB 

IMAGE

OBJECT

BLOB

CLOB

CLOB

java.sql.Clob

TEXT

TEXT

CLOB

CLOB

 TEXT

CLOB

CLOB

TEXT

OBJECT

CLOB

JDBC Types not supported by Castor

  • ARRAY
  • DISTICT
  • REF
  • STRUCT