mysql connector Class NotFound error

[shawn peter]

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?

[Vinod K Singh]

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

[Nishan Patel]

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.

[Vijitha Kumara]

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?

[shawn peter]

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

[VIJAY Yadlapati]

Try setting the classpath, not in build path

[VIJAY Yadlapati]

Try setting the classpath

[shawn peter]

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

[Albareto McKenzie]

Hi there!

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

[shawn peter]

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)

[Albareto McKenzie]

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

[shawn peter]

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

[shawn peter]

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

[Albareto McKenzie]

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.