JDBC-ODBC Bridge Removed in Java 8, what is the best alternative?

java sql ms-access jdbc jdbc-odbc
djmordigal picture djmordigal · Mar 31, 2014 · Viewed 15.2k times · Source

Seeing as Oracle has removed the JDBC-ODBC Bridge driver in the latest release of Java (version 8), is there a good alternative that will enable us developers to access ODBC databases in Java 8?

Oracle is apparently recommending that we use vendor-specific JDBC drivers instead of the Bridge, which tells me that Microsoft should have its own JDBC driver for connecting to MS Access databases in Java.

http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html

I'm currently looking into whether or not Microsoft has this technology available, but in the meantime, does anyone know if they do or if another alternative is available?

Answer

Gord Thompson picture Gord Thompson · Mar 31, 2014

does anyone know if ... another alternative is available [for Access]?

Yes. UCanAccess is a viable alternative. For more information look here.

Related questions

Insert data to ms access from java

I'm new to JDBC. I want to insert data into Access from Java, but I can't get it. It shows the following error: Connection Established Successfully java.sql.SQLException: General error Could Not Connect to Database at sun.jdbc.odbc.…

Read More
How to determine if a table contains a value in SQL?

I feel like I'm missing something very obvious here, but it seems that the only way to go about doing this is to get the value, and then see if it returns a null (empty) value, which I would rather …

Read More
Check username and password in java DataBase and give wrong password message if false

i want to display an error wrong username & password after comparing entered username and password with database of users in java. the problem is it does the if else statement against each row until it gets to the right …

Read More