How to Access the JDBC-ODBC Bridge in Java 8 After Its Removal?

Accessing JDBC-ODBC Bridge in Java 8 after Removal

As Java 8 no longer includes the JDBC-ODBC Bridge, many developers may wonder how to connect to ODBC data sources. Fortunately, it is possible to retain the functionality despite the change.

Custom Jar Creation

One approach involves creating a custom JAR file:

1. Download a JDK or JRE version 7.
2. Extract the rt.jar file from the JRE's lib folder.
3. Unzip rt.jar (or rename it to rt.zip and unzip).
4. Copy the sunjdbc and sunsecurityaction folders with their original structure.
5. Run the command "jar -cvf jdbc.jar sun" in the CMD window to create jdbc.jar.
6. Copy jdbc.jar to the lib folder (or libext if necessary) of your JDK or JRE 8.

DLL Transfer

Additionally, the jdbcodbc.dll file must be transferred from JRE 7bin to JRE 8bin.

JVM Restart

Restart the JVM after completing these steps to enable the JDBC-ODBC bridge functionality.

The above is the detailed content of How to Access the JDBC-ODBC Bridge in Java 8 After Its Removal?. For more information, please follow other related articles on the PHP Chinese website!