Moving the JDBC ODBC bridge from Java 7 to Java 8

The JDBC ODBC bridge that we were used to in Java, 5, 6, and 7 is no longer supported in Java 8.

This means that when you upgrade to Java 8 and try to connect to your MS Access database (or other databases that require an ODBC driver instead of a JDBC driver) you will get the following error:

'java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver'

Happily, there is a very easy way to move the JDBC ODBC bridge from your Java 7 installation into your new Java 8 installation.

1) Place the attached jar file in the folder called java/jre8/lib/ext

2) Then go to your java 7 installation and copy the file called jdbcOdbc.dll from the java/jre7/bin folder and put it in the java/jre8/bin folder

Obviously make sure not to mix up architectures (32-bit/64-bit)

Files: jdbc.jar
Is article helpful?