"java.lang.ClassNotFoundException" when trying to connect mySql via servlet

Question

I try to connect to MySQL database (works perfect when I connect to it without servlet) and get the below error all the time:

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

This error means (as I understand) that I don't have some jar files in my project. but this is not true, because I have those Jars. !Moreover, if I realy didn't had those jar, I could not have connected to the database anyway.

What I missed?

If you're running tomcat you can probably drop it into the lib directory? — ConMan
– ConMan, Commented Apr 24, 2015 at 13:07

Jafar Ali · Accepted Answer · 2015-04-24 13:04:57Z

2

By looking at those tags this is a web application. So the error clearly states you don't have your SQL Venders Driver jars in the class path.

You can put this jar in your Project/WEB-INF/lib folder and restart whatever web server you are using. Then you will be good to go.

answered Apr 24, 2015 at 13:04

Jafar Ali

1,1143 gold badges18 silver badges42 bronze badges

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

Comments

peterh · Accepted Answer · 2015-04-24 08:17:39Z

1

Your mysql jdbc jar driver isn't in your classpath.

If you run it from a servlet, it uses the classpath of your servlet container. This classpath probably contains it.

Find mysql-connector-java where you can, and copy into your classpath.

answered Apr 24, 2015 at 8:17

peterh

1

6 Comments

dennis bergkamp Over a year ago

sorry for my lack of knowledge, but i'm not sure how to do it. i saw here a guide that say only to copy it to the src folder. is it correct? anyway-his way doesn't fix the problem.

peterh Over a year ago

@dennisbergkamp You are on a large q&a site, formulate your question and ask it. It is absolutely not a problem here, if you ask a lot.

dennis bergkamp Over a year ago

can u explain please how to add the jar to classpath? i don't find an answer for that, and also posted it and didn't answered yet. thanks

peterh Over a year ago

@dennisbergkamp Yes, but it is already a different question. Ask this as a new one, with proper spelling (forget "u", etc), and give the exact details of the technologies you are using.

dennis bergkamp Over a year ago

working!! thanks all of u (i putted the jar where jafar ali told me)

|

Collectives™ on Stack Overflow

"java.lang.ClassNotFoundException" when trying to connect mySql via servlet

2 Answers 2

Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related