2

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?

Gord Thompson
  • 98,607
  • 26
  • 164
  • 342
djmordigal
  • 551
  • 1
  • 5
  • 13

1 Answers1

2

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

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

Community
  • 1
  • 1
Gord Thompson
  • 98,607
  • 26
  • 164
  • 342
  • Third-party, enterprise-grade, commercial JDBC-to-ODBC Bridges also exist, including those [from my employer](http://uda.openlinksw.com/). – TallTed Apr 02 '14 at 16:44
  • UCanAccess on the other hand is free/open-source. Just gave it a try, and it works great. Basically, it's just a really good JDBC driver which supports MS Access. – bvdb Mar 24 '16 at 12:52