Java sql type mapping (Oracle, MySql++)

18 Apr 2008

I found this useful table at the castor site:

Castor TypeJDBC TypeJava Object TypeMySQLPostgreSQLOracleDerbyMSSQLSapDBDB2SybaseHSQLPointBase
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
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 
 <a name="JDBC-Types-not-supported-by-Castor"> ##

</a></div> </div>

Posts

Tommy Skodje
Software Developer and consultant
Acando, Oslo, Norway