search

rbeckman-nextgen / test-mc

test-migration
1 stars 0 forks source link

Remove JDBC-ODBC Bridge Driver from dbdrivers.xml for new installations #3564

Open rbeckman-nextgen opened 4 years ago

rbeckman-nextgen commented 4 years ago

It appears that the JDBC-ODBC Bridge has been removed by Oracle in Java 8. http://docs.oracle.com/javase/8/docs/technotes/guides/jdbc/

I can confirm that using it with Java 8 will yield an exception similar to {code} Caused by: java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver at java.net.URLClassLoader$1.run(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at com.mirth.connect.connectors.jdbc.DatabaseConnectorService.invoke(DatabaseConnectorService.java:62) ... 27 more {code}

We won't remove it when users upgrade, but we will no longer include it for new installations. Users that wish to remain on Java 7 so they can continue to use the bridge can always add the entry back to dbdrivers.xml. For reference, it is {code}

{code}

According to http://docs.oracle.com/javase/7/docs/technotes/guides/jdbc/bridge.html {quote} Oracle recommends that you use JDBC drivers provided by the vendor of your database instead of the JDBC-ODBC Bridge. {quote}

Imported Issue. Original Details: Reporter: wayneh Created: 2015-02-15T18:59:21.000-0800

rbeckman-nextgen commented 4 years ago

I've mostly seen this used for Access. Are there other options?

Imported Comment. Original Details: Author: jacobb Created: 2015-02-23T10:51:09.000-0800

rbeckman-nextgen commented 4 years ago

http://ucanaccess.sourceforge.net/site.html http://www.easysoft.com/products/data_access/jdbc-access-gateway/getting-started.html

The first one is open source under LGPL. Haven't tested them out myself.

Imported Comment. Original Details: Author: wayneh Created: 2015-02-23T10:54:52.000-0800

rbeckman-nextgen commented 4 years ago

[This SO post|http://stackoverflow.com/questions/9863482/jdbc-with-ms-access] mentions these two open-source alternatives, both are LGPL:

http://jackcess.sourceforge.net/ http://ucanaccess.sourceforge.net/site.html

Imported Comment. Original Details: Author: brentm Created: 2015-02-23T10:56:17.000-0800