Exception with com.mysql.jdbc.Driver

Question

i'm trying run code

public static Connection getConnection() throws SQLException{
        try {
            Class.forName("com.mysql.jdbc.Driver");
            cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull [root on Default schema]");
        } catch (ClassNotFoundException | SQLException e) {
            JOptionPane.showMessageDialog(null,e.toString());
        }
        return cn;
    }

but i get the exception: enter image description here

with the dialog:

enter image description here

I have added the divier :mysql-connector-java-5.1.36-bin.jar in this project. What am I doing wrong?

You run it from eclipse? Have you add it as library? See stackoverflow.com/questions/3280353/… — diufanman
– diufanman, Commented Jul 18, 2015 at 14:16
The JAR isn't in the CLASSPATH. Put it there and find your next problem. — duffymo
– duffymo, Commented Jul 18, 2015 at 14:18

Seeker · Accepted Answer · 2015-07-18 15:46:00Z

1

Add mysql connector jar to your project classpath.

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.6</version>
</dependency>

answered Jul 18, 2015 at 15:46

Seeker

9579 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Exception with com.mysql.jdbc.Driver

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related