转载：常见数据库字段类型与java.sql.Types的对应
今天工作时候，刚好碰到类型转换错误的现象。找到一篇这样的列表文章。赶紧转载过来。

传送门：http://blog.csdn.net/langrenbule/article/details/6823458

[测试]常见数据库字段类型与java.sql.Types的对应
Oracle与java.sql.Types的对应

Oracle                                java.sql.Types
blob                                     blob
char                                     char
clob                                     clob
date                                    date
number                               decimal
long                                     varbinary
nclob,nvarchar2                   other
smallint                                smallint
timestamp                            timstamp
raw                                      varbinary
varchar2                               varchar

Sql server与java.sql.Types的对应

Sql server                           java.sql.Types
   bigint (2005,2008)                bigint
   timstamp,binary                    binary
   bit                                         bit
   char,nchar,unqualified          char
   datetime                               date
   money,smallmoney,decimal  decimal
   float (2005,2008)