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 MY SQL database connectivity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "MY SQL database connectivity" Watch "MY SQL database connectivity" New topic
Author

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,
http://www.mysql.com/downloads/api-jdbc-stable.html

I have put the following part of the extracted file
mysql-connector-java-3.0.17-ga-bin
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
Sheriff

Joined: Dec 11, 2004
Posts: 13410

You should look at the documentation on the Tomcat site -- especially this page:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html


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

Joined: Feb 05, 2001
Posts: 17249
    
    6

Moving to the Apache/Tomcat forum.

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
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.

regards,
Rahul
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MY SQL database connectivity
 
Similar Threads
JDBC Connection to MS Access DB without ODBC
mysql JDBC driver classpath problem.
MySQL-Java Forms
Setting up MySQL dataSource in WSAD 5.1.1
JDBC-Mysql relation