mysql connector Class NotFound error

in my servlet there is a database connection.
if i put mysql connector.jar file to the lib folder in web.INF derectory then it is working.
but if i set the buildPath to the mysql connector using configureBuildPath it says class NotFound error?

That means class path is not set properly. BTW when you face this error compile time or run time?

Hi,

That will not happen Put your mySql connection jar to your lib folder of web inf will automatically add to your build path.

Or if it will not add just right click on jar and select add to build path.

aruna sameera wrote: but if i set the buildPath to the mysql connector using configureBuildPath it says class NotFound error?

Which context are you setting these? In IDE?

no i mean if i put jar file to the lib folder it is working.
but if not doing that if i set the build path to the mysql.jar it gives class Not Found error

Try setting the classpath, not in build path

Try setting the classpath

I am using eclips IDE .How to set classpath using eclips.

Hi there!

In Eclipse: Window > Preferences > Java > Build Path > Classpath Variables > New (or edit if you have one)

this is my servlet

package my;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class check extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
     
		Connection con;
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		this.doPost(request, response);
	}  	
	
	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		getcon();
	}
	
	public Connection getcon(){
		System.out.println("super.init();super.init();");
		   String url = "jdbc:mysql://localhost:3306/";
	    String db = "student";
	    String driver = "com.mysql.jdbc.Driver";
	    String user = "root";
	    String pass = "admin";
	    try{
	      Class.forName(driver).newInstance();
	      con = DriverManager.getConnection(url+db, user, pass);
	      
	    }
	    catch (Exception e){
	      e.printStackTrace();
	    }
	    return con;
	}

}

this is the error i got.
i set the class path to the mysql-connector.jar file using window-preference.......
but still error remain

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1355)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1201)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at my.check.getcon(check.java:33)
	at my.check.doPost(check.java:22)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)

But does your classes see that class? If you import com.mysql.jdbc.Driver an error is displayed or something like that?

Yes.i put the
import com.mysql.jdbc.Driver;
but error is still remain.

this is happening for only web application
i used this methed(getcon()) in a java application.it is working.

Ok, that seems to be that you don't have that librarie included in your project, you have to add it and the problem is gone.