Error: java.lang.ClassNotFoundException:com.mysql.jdbc.Driver [duplicate]

Question

I am trying to connect to mysql database. I am using MySQL workbench. These are my codes:

 Class.forName("com.mysql.jdbc.Driver");
 con =DriverManager.getConnection("jdbc:mysql://localhost/try?" +"user=jenny&password=perez");

 PreparedStatement ps=con.prepareStatement("SELECT * FROM address");
 ResultSet myRS=ps.executeQuery();

What's wrong with my codes?

Because you don't have the MySQL JDBC driver on the app's classpath? — Dave Newton
– Dave Newton, Commented Jan 13, 2015 at 2:22

Rachelle Tud · Accepted Answer · 2015-01-13 02:27:21Z

1

Your codes are correct. You come up with that error because you have no mysql connector. Try to download mysql-connector-java-5.1.18-bin. Install it here C:\Program Files\Java\jre6\lib. Then, Go to the properties of your project, then follow these:

Go to Libraries, then Compile, click Add JAR/Folder, then search the mysql connector you installed. Then run your program. ^_^

edited Jan 13, 2015 at 2:27

answered Jan 13, 2015 at 2:20

Rachelle Tud

2151 silver badge10 bronze badges

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

1 Comment

user207421 Over a year ago

Could you possibly name a version that isn't several years out of date? The current version is 5.1.34.

Collectives™ on Stack Overflow

Error: java.lang.ClassNotFoundException:com.mysql.jdbc.Driver [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related