We can still use JDBC-ODBC Bridge in java 8 too, just follow this simple recipe:
- Download a JDK 7 or JRE 7.
- Goto JRE\lib folder and find the rt.jar
- Unzip it (if you have WinRAR or 7zip installed) or you can rename it to rt.zip and unzip it.
-
Copy sun\jdbc and sun\security\action folders out, keep the folder structure. i.e., you should have the folder structure like below:
Sun --> Security --> Action --> JDBC
-
Open a CMD window. Go to the parent folder of Sun folder. Run the command:
jar -cvf jdbc.jar sun
- The above command will create a file named jdbc.jar
- Copy JDBC.jar to your JDK8 or JRE8
lib
folder. If that doesn’t work try thelib\ext
folder. - Copy jdbcodbc.dll from JRE\bin of your JRE 7 installation to JRE\bin of your JRE 8 installation.
- Restart your JVM.
How to enable JDBC-ODBC bridge for JDK 8