jdbc type 4 -java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Question

Possible Duplicate:
ClassNotFoundException com.mysql.jdbc.Driver

Hi I am beginner in java and I have created a java program in eclipse using jdbc type 4.

I got an error : java.lang.ClassNotFoundException: com.mysql.jdbc.Driver.

so can you please help me in resolving this error.

Thanks in advance

Read the answer of @BaluSc : http://stackoverflow.com/questions/2353141/mysql-jdbc-driver-and-eclipse-classnotfoundexception-com-mysql-jdbc-driver?lq=1 — Hardik Mishra, Jul 30 '12 at 08:53

score 1 · Answer 1 · answered Jul 30 '12 at 06:44

1

You need MySQL Connector jar which is not in classpath. Add it in your classpath

answered Jul 30 '12 at 06:44

Nandkumar Tekale

score 0 · Answer 2 · answered Jul 30 '12 at 06:50

0

Two ways

1) Run java app with classpath

Windows

java -classpath .;mysqljarfile.jar YourApplication

Linux

java -classpath .:mysqljarfile.jar YourApplication

2) Define it in your manifest file

Manifest-Version: 1.0
Class-Path: mysqljarfile.jar 
Main-Class: mainClass

answered Jul 30 '12 at 06:50

Bekzat Abdiraimov

I misread. In eclipse you can add library in Properties/JavaBuildPath – Bekzat Abdiraimov Jul 30 '12 at 06:57
I have been creating this program using eclipse so how do i set the class path in eclipse ? – user1450954 Jul 30 '12 at 07:11

score 0 · Answer 3 · answered Jul 30 '12 at 08:00

0

Add your mysql connector jar file to your project WEB-INF\lib folder and redeploy again.

answered Jul 30 '12 at 08:00

Communication failure during handshake. Is there a server running on localhost:3306? i tried adding the jar file and now – user1450954 Jul 30 '12 at 08:41

3 Answers3