java 1.8 odbc,sun.jdbc.odbc.JdbcOdbcDriver不使用jdk 1.8

I downloaded jdk8u40 and now I get:

SQLException:

SQLState: 08001

Message: No suitable driver found for jdbc:odbc:mysqlDB

Vendor: 0

where mysqlDB is my data source name.

I use:

jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver

jdbc.url=jdbc:odbc:mysqlDB

as connection strings. I have downloaded and installed driver:

mysql-connector-odbc-5.3.4-winx64.msi

I read in your forums that the jdbc-odbc bridge is no longer supported in jdk 1.8.

Any help appreciated.

解决方案

The JDBC-ODBC bridge is no longer shipped/supported with JDK 8, hence the errors:

The JDBC-ODBC Bridge should be considered a transitional solution; it will be removed in JDK 8. In addition, Oracle does not support the JDBC-ODBC Bridge. Oracle recommends that you use JDBC drivers provided by the vendor of your database instead of the JDBC-ODBC Bridge.

If you're using Java, it would be better to use a JDBC driver instead of an ODBC driver, see here http://dev.mysql.com/downloads/connector/j/ for the MySQL JDBC driver.