Type Mapping

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