CODEWITHSUNDEEP
javajdbcodbctypes
prg-blogger
prg-blogger

Reputation:

ODBC to JDBC datatypes mapping

Where can I find description of how to map ODBC datatypes to JDBC? Or maybe anybody knows where source code of a jdbc-odbc bridge driver can be downloaded?

Upvotes: 2

Views: 1134

Answers (3)

Jeff Fiedler
Jeff Fiedler

Reputation:

I stumbled across this page for JDBC to database column type mappings: Mapping SQL and Java Types .

However, I did notice that the table does not show that a JDBC CLOB will work with a Memo column of Access.

Upvotes: 0

Reputation:

According to wikipedia,

Sun provides a JDBC-ODBC Bridge driver. sun.jdbc.odbc.JdbcOdbcDriver. This driver is native code and not Java, and is closed source.

But I've downloaded sources (jdk-6u3-fcs-src-b05-jrl-24_sep_2007.jar), and the driver's source is really there: j2se\src\share\classes\sun\jdbc\odbc\JdbcOdbcDriver.java

Upvotes: 0

Joe Ratzer
Joe Ratzer

Reputation: 18549

The JDBC-ODBC Bridge is bundled with the Java 2 SDK Standard Edition...

Check out the FAQ's at Sun - http://java.sun.com/products/jdbc/faq.html

Upvotes: 2

Related Questions