I am using netbeans IDE and mysql database for my development in servlet and JSP. I created a java class as it contains all the configuration code to connect to my db. In another java class file i wrote code to retrieve data from db and to display. And it is working absolutely fine. Even I am getting the display of records on the console. But when i am trying connect to db from servlet, I am getting SQLException stating no drivers found. As I want to use single database connection file and use it within the entire web-application.
i think your driver jars can be deployed to your web container(Tomcat may).
open your web container directory. example in tomcat:
check your jdbc driver jar is it in this path?
if not, redeploy the project with your ide..
subject: creating one jdbc configuration file for the entire web applicaton