CODEWITHSUNDEEP
javasqljdbctypes
Stephan
Stephan

Reputation: 43013

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 ?

Upvotes: 4

Views: 8020

Answers (4)

Vineet Reynolds
Vineet Reynolds

Reputation: 76709

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.

Upvotes: 9

Jifeng Zhang
Jifeng Zhang

Reputation: 5147

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

Upvotes: 4

Paul Bellora
Paul Bellora

Reputation: 55213

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.

Upvotes: 2

Shawn Vader
Shawn Vader

Reputation: 12385

This is for the Derby database Sql Types

Upvotes: 0

Related Questions