All geek questions in one place

JDBC-ODBC Bridge Replacement

Java 8 will remove JDBC-ODBC-Bridge . Typical error:

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

Are you aware of a possible replacement? I found Easysoft. But for this bridge, you need an additional server that does not start inside the Java virtual machine. This is a type 3 driver, not a type 1 driver. Are there other alternatives?

+5
source share
2 answers

In the meantime, we created our own JNA-based JDBC-ODBC bridge for our i-net Clear-Reports reporting software. The driver is currently not an official product. But if you have interest, you can contact us.

-1
source

Another solution is to take the ODBC material from the 1.7 JRE and pack it into your own JAR file.

To do this (this is for Windows 64, but the process should be the same), you need to take the JdbcOdbc.dll from the 1.7 JRE bin and copy it to the 1.8 JRE box.

Then extract the contents of 1.7 JRE lib\rt.jar to another location. After extracting, delete everything except

 sun\ jdbc\ odbc\ * security\ action\ LoadLibraryAction.class

Then create a JAR file with the remaining content (the root content of the JAR must be META-INF and sun). Copy the JAR file to the 1.8 JRE lib\ext folder.

+2
source

Source: https://habr.com/ru/post/987684/

More articles:


All Articles