my dog learned polymorphism
The moose likes Mac OS and the fly likes Mac OS X Tomcat classpath issues 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 » Engineering » Mac OS
Bookmark "Mac OS X Tomcat classpath issues" Watch "Mac OS X Tomcat classpath issues" New topic

Mac OS X Tomcat classpath issues

Ramesh Manian

Joined: Nov 10, 2009
Posts: 2
I am running Tomcat 5.5 on my Mac OS X (snow leopard) with MySql 5.0 and I keep getting an error "No suitable JDBC driver found" when I run my app. My Java class which does indeed use MySql works perfectly fine when I run it from my Eclipse dev environment and gives me an error when Tomcat starts up (that starts my java class).

I think it has to do with classpath issue. I do not have an issue when I runt his from my Windows environment.

What could be causing this discrepancy? Any help is greatly appreciated. Thanks
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42959
Welcome to JavaRanch.

How are you adding the driver jar file to the classpath so that Tomcat can find it? If you put it in TOMCAT_HOME/common/lib then all web apps (and Tomcat itself) can use it. If you want a single web app to use it, put it into that web app's WEB-INF/lib directory.
Ramesh Manian

Joined: Nov 10, 2009
Posts: 2
Thanks for the welcome.

I am adding the jdbc connector jar in my app's WEB-INF/lib directory.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63548

Are you using container-managed connection pooling? If so, the jar file with the driver must be in the common/lib folder.

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: Mac OS X Tomcat classpath issues
jQuery in Action, 3rd edition