JSP Class Not Found Exception after using import

Question

I am trying to display table data in JSP

<%@ page import="java.sql.*" %> <%@ page import="com.mysql.*" %> <html> <body> <% Class.forName("com.mysql.jdbc.Driver"); Connection conn = null; conn = DriverManager.getConnection(connection, username, password); String query = "select * from table1"; Statement stmt = null; stmt = conn.createStatement(); ResultSet rs = null; rs = stmt.ExecuteQuery(query); while(rs.next()){ } %> </body> </html>

It gives cannot find class com.mysql.jdbc.Driver.

Did you attached the mysql connector jar file to the project classpath? — user2575725
– user2575725, Commented Jan 27, 2015 at 4:43
Yes, external JAR is added. Also i am able to get the result in a java file. But not in JSP — user544079
– user544079, Commented Jan 27, 2015 at 4:43

Oliver · Accepted Answer · 2015-01-27 04:43:31Z

1

Your JDBC Driver is not in the Classpath. Do the following:

Put your JDBC Driver in Web-INF/libs
Then Right Click on the Jar and do Add to bulid path.
Run your application again

answered Jan 27, 2015 at 4:43

Oliver

6,2802 gold badges48 silver badges81 bronze badges

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

1 Comment

Oliver Over a year ago

Don't Forget to do the Second Step. This should solve the problem.

BAR · Accepted Answer · 2015-01-27 04:43:00Z

You need to add com.mysql.jdbc.Driver in your classpath.

Simply calling Class.forName(...) is not enough.

Collectives™ on Stack Overflow

JSP Class Not Found Exception after using import

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related