Meaningless Drivel is fun!
The moose likes Tomcat and the fly likes MY SQL database connectivity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "MY SQL database connectivity" Watch "MY SQL database connectivity" New topic

MY SQL database connectivity

yash Vi
Ranch Hand

Joined: Jul 17, 2005
Posts: 41
I have got the Type 4 JDBC Driver as follows,
I downloaded the zip file from the following site,

I have put the following part of the extracted file
into the folder \Tomcat 4.1\webapps\ROOT\WEB-INF\lib

How do I set the Classpath for this and what is the connection dtring to be mentioned in the Class.forname statement.. Please help

Thanks for your reply and time.<br />Windows 2000,j2sdk1.4.2_08
Ben Souther

Joined: Dec 11, 2004
Posts: 13410

You should look at the documentation on the Tomcat site -- especially this page:

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

Moving to the Apache/Tomcat forum.


Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
Rahul Singh Khokhar
Ranch Hand

Joined: Feb 23, 2005
Posts: 36
Hi Yash,
I believe the easiest way to get your class4 drivers working is to simply place the jdbc driver (.jar file) into your /java/jre/lib/ext folder.
Tomcat will happily work with this arrangement if you have set up the JVM correctly in your Tomcat.

wood burning stoves
subject: MY SQL database connectivity
It's not a secret anymore!