Java sql type mapping (Oracle, MySql++)

I found this useful table at the castor site:

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 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

Welcome!

This is my blog for stuff that I work, or even play with, mostly computer code. If any of this is useful to anybody but me, that's nice and good with me, but:

1. be nice - use it for good, not bad.
   
2. be responsible - don't blame (or sue) me for any problems arising from such use.

I put out most stuff here for my own sake, so the rest is optional but you're welcome to link to this blog and give me credit (or even money) if you feel that I deserve it.