Exception on loading JDBC-ODBC driver

Question

I am getting java.lang.ClassNotFoundException on loading sun.jdbc.odbc.JdbcOdbcDriver using Class.forName().

I am using MySQL as Data Source and I have added Data Source Name in ODBC Data Source Administrator (on Windows 8).

Here is the code:

class Connect {
     check() {
       try {

           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

       } catch (ClassNotFoundException e) {
           e.printStackTrace();
       }
    }
}

Output:

java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver

did you try to Test connection in ODBC Data Source Administrator after configuring? — Rustam
– Rustam, Commented Sep 17, 2014 at 14:12
@ElliottFrisch I tried using Class.forName("com.mysql.jdbc.Driver") but i am getting same error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver — Malwinder Singh
– Malwinder Singh, Commented Sep 17, 2014 at 14:28

Petter · Accepted Answer · 2014-09-17 14:14:01Z

1

Are you using Java 8? The class is no longer present there (more info). You could install Java 7 if you need to use it.

answered Sep 17, 2014 at 14:14

Petter

4,1751 gold badge30 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Malwinder Singh Over a year ago

How to connect to Database by using Java 8?

Petter Over a year ago

A JDBC driver exists for MySQL, use that instead. Here is an example: tutorialspoint.com/jdbc/jdbc-sample-code.htm

Malwinder Singh Over a year ago

I tried using Class.forName("com.mysql.jdbc.Driver") but i am getting same error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Petter Over a year ago

You need to download the driver from here: dev.mysql.com/downloads/connector/j and add it as a dependency to your project.

Malwinder Singh Over a year ago

How to add it as dependency to project? Do i need to import it? How?

|

LeoTorres · Accepted Answer · 2014-09-17 14:42:24Z

0

This happened to me once, and what i did was importing the mysql jdbc library that came with the product when i downloaded it, after that i used the driver as it is explained in the page:

http://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-connect-drivermanager.html

hope this could help you

answered Sep 17, 2014 at 14:42

LeoTorres

1422 silver badges10 bronze badges

Collectives™ on Stack Overflow

Exception on loading JDBC-ODBC driver

2 Answers 2

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related