I didn’t deal with JDBC directly for a long time because most projects I used EJB, Hibernate, iBatis or home-made DAO wrapper class. But sometimes I still have to use JDBC to test. The one thing must be careful is different RDMS with different JDBC Data Type mapping. For easy to look up I list the major JDBC driver data type mapping.

Microsoft SQL server 2005
IBM DB2
Oraccle 10g
MySQL 5.0
jTDS Driver for SQL server
Sun Java Tutorial – JDBC
JDBC 4.0 Enhancements in Java SE 6

update: 06-20-2007

Hibernate Mapping Cheat Sheet 

Advertisements