wood burning stoves 2.0*
The moose likes JDBC and the fly likes Why my JDBC not working in servlet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Why my JDBC not working in servlet" Watch "Why my JDBC not working in servlet" New topic

Why my JDBC not working in servlet

Ming Chen

Joined: Mar 14, 2002
Posts: 13
My JDBC connection with MySQL has been always working on general java classes on command line, but when I call a class(JDBC) from servlet, there is always a connection problem. I check all classpath, it was right. I don't know if I should do sth with web.xml file, I use Tomcat 4.0.
Anybody know how?
Ming Chen

Joined: Mar 14, 2002
Posts: 13

I have solved this problem.
I add MySQL driver mm.mysql-2.0.4-bin.jar file on the tomcat folder:
D:\Apache Tomcat 4.0\common\lib, restart tomcat server, it then works.
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

Glad you solved it
This is quite a common problem when connecting databases to Servlet Engines.
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
It is sorta covered in the JavaRanch Style Guide.
subject: Why my JDBC not working in servlet
Similar Threads
Newbie: How doy I connect to Oracle Using JDBC
JSP--> Servlet --> JDBC
JSP --> Servlet --> JDBC
Using Java EE 5 @Resource injection in a servlet
Implementing multi-tire application and persistent DB connection in WebLogic