Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases and the fly likes Where to put jdbc jar files Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Where to put jdbc jar files" Watch "Where to put jdbc jar files" New topic

Where to put jdbc jar files

Steve Campbell
Ranch Hand

Joined: Dec 18, 2000
Posts: 41
I'm writing my first java application which doesn't use odbc. (Up till now I've been writing servlets which run under Tomcat). I'm using the mm mysql driver. I've tried putting the jar file under the jdk1.3\lib & jdk1.3\lib\ext. Do I need to use the "classpath" variable (I'm using windows 2000)? I already have a "java_home" variable which I created for Tomcat, does this do anything for applications?
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

If the problem is with using Tomcat, have a look at this thread.
Steve Campbell
Ranch Hand

Joined: Dec 18, 2000
Posts: 41
I already have it working under Tomcat (I put the jdbc driver jar file in "jakarta\lib"). My problem is that I'm trying to write an "application". I've since found that I can make it work by using the "-classpath" option when using the "java" command to run the program. I had read that if you place the jar files into "jdk\jre\lib\ext", and create a "java_home" environment variable pointing to the jdk, then the "java" command will pick up the jar files.
I agree. Here's the link:
subject: Where to put jdbc jar files
It's not a secret anymore!