File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Tomcat and the fly likes mysql driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "mysql driver" Watch "mysql driver" New topic
Author

mysql driver

James Hoare
Greenhorn

Joined: Aug 11, 2006
Posts: 9
Hi Guys, I have just set up Tomcat 5.5 on my XP machine and I have mysql installed also. If I want to start using JDBC in my servlets with mysql, what jar file do I need and where in Tomcat do I install it to?

Thanks
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14268
    
  21

You can get a JDBC driver from MySQL on the MySQL website.

The best place to install it is put it in the WEB-INF/lib directory of your web application.


Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 8 API documentation
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

Originally posted by Jesper Young:
The best place to install it is put it in the WEB-INF/lib directory of your web application.


Unless you're using container managed connection pooling, in which case, Tomcat needs access to the driver so it should go under tomcat/common/lib.


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: mysql driver