Java 6 - Mapping java.sql.Types to Java types

问题:

I'm looking for a link to a table with the mappings between SQL types (java.sql.Types) to Java types.

Do you know where I can find one ?

回答1:

The JDBC 4.x Specification, provided by JSR 221, provides this info in appendix B titled Data Type Conversion Tables.

See tables containing mappings from Java object types to JDBC types. Different tables exist for the mappings that will be performed when different methods of the JDBC API are invoked; for instance, a separate mapping exists for CallableStatement.getObject and ResultSet.getObject while another exists for the mappings used during ResultSet.getXXX methods.

Click through that JSR 221 page to download a PDF of the spec document, currently JDBC 4.3.

回答2:

here is a document for Java 6. http://download.oracle.com/javase/6/docs/technotes/guides/jdbc/getstart/mapping.html#996857

回答3:

EDIT: Have a look at this article.

It may be better to look for documentation provided by the driver itself, as this will be more definite.

回答4:

This is for the Derby database Sql Types