current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Join the Stack Overflow Community
Stack Overflow is a community of 6.6 million programmers, just like you, helping each other.
Join them; it only takes a minute:
Sign up
up vote 2 down vote favorite

This question already has an answer here:

I am using Java/Eclipse to connect to MySQL database but encountering the following error.

Error Message:

Unable to connect to databasejava.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Code:

<%
  try {
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection myCon = DriverManager.getConnection("jdbc:mysql://localhost/myDB", "root", "password");
    if(! myCon.isClosed())
      out.println("Successfully connected to " + "MySQL server!");

    myCon.close();
  }catch(Exception ex){
      out.println("Unable to connect to database" + ex);
  }      
%>

I know that this question has already been asked here but still I am unable to sort this thing out.

Environmental variables:

JAVA_HOME: C:\Program Files\Java\jdk1.7.0_51

CLASSPATH: .%JAVA_HOME%\lib;C:\Program Files\MySQL\Connector J 5.1.29;

How can I can solve this issue?

share|improve this question

marked as duplicate by BalusC eclipse Oct 9 '15 at 7:50

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
    
As @ThorbjørnRavnAndersen said, the CLASSPATH generally won't apply in a web environment. Even if it did (in more classic environment), you'd need the exact jar name, not the name of the directory containing the jars. – Bruno Mar 29 '14 at 15:00
    
@bruno see docs.oracle.com/javase/7/docs/technotes/tools/solaris/… for instructions on how to use wildcards in the Classpath definition. – Thorbjørn Ravn Andersen Mar 30 '14 at 12:47
up vote 5 down vote accepted

The Eclipse project doesn't know where you have the drivers for the database. You need to include them under the WEB-INF/lib directory so that they become part of the classpath.

share|improve this answer
up vote 2 down vote

Inside tomcat the external definitions do not apply.

Either deploy the driver jar with your application or add it to the extension library inside Tomcat. I would use the first if Tomcat is not expected to help you with e.g. connection pools or similar

share|improve this answer
up vote 1 down vote

if you are using eclipse then add MySQL jars in projects lib folder.

share|improve this answer
    
Thank you for all these answers. It worked after copying mysql-connector-java-5.1.29-bin.jar to WEB-INF/lib directory. Is't there another way by adding a code statement that will reference the mySql connector jar? In a forum, they suggested to write the following: java -cp<path to jars>;. myclass Where am I supposed to write this command? Thank you again. – Warrio Mar 29 '14 at 15:12
up vote 0 down vote

Yes it worked for me also for the error as java.lang.ClassNotFoundException: com.mysql.jdbc.Driver.

Copied the sql connector jar file to lib folder of web-inf .

After copying this, the value from html to mysql database is sucessfully inserted Thanks for the Help

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.