jdbc error at runtime - org.postgresql.Driver

[Eduardo Ponce de Leon]

I am getting this error when trying to conncet to my DB...

org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.ClassNotFoundException: org.postgresql.Driver
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:548)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:456)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

it is funny because it only hapens when running my app, when I run it in a simple java file it works fine...

conn = abc.connection("Users");

rs = abc.exeQuery(conn,"SELECT \"public\".\"Users\".\"Password\" FROM \"public\".\"Users\" WHERE \"public\".\"Users\".\"Password\" ='agosto97';");
rs.next();
System.out.println(rs.getString(1));

Why am I getting this error..

I am attaching a pic showing that the driver has been configured on my IDE.

[Muhammad Saifuddin]

It looks like the driver isn't in the classpath. put this jar under your tomcat/lib or in WEB-INF/lib directory.

hope its helps.

[Eduardo Ponce de Leon]

I am running my app from eclipse, i dunno if that makes a difference.. I dont have anything on my tomcat folder!

[Patryk Sosinski]

You got ServletException so it is some kind of web application (maybe you got embedded tomcat server in eclipse). It is normal that when you run standalone java class all jars are taken from classpath, but when you deploy application to servlet container you need to put those jars in for example WEB-INF/lib directory as they are not deployed.

[hemantha kumar k]

I am running my app from eclipse, i dunno if that makes a difference.. I dont have anything on my tomcat folder!

Really it does make difference, since your adding the jar file to eclipse, only eclipse knows where actually jar file is located, but when it comes to running on the any server(tomcat), server should know where jar files are located, when we consider tomcat you should place jar files inside WEB-INF/lib folder then only tomcat come to know about that project an your getting the error from tomcat not from eclipse, eclipse is an IDE which helps while coding, if you add you jar in class path then it will only eclipse come to know not your web server, always your web server search jar file in WEB-INF/lib folder

[Eduardo Ponce de Leon]

Well, that is weird, yesterday it was working fine. The .jar was in that folder, i delete the file and add it again and it is working fine now.

[Eduardo Ponce de Leon]

Thank you all for the help!