Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Mac OS X Tomcat classpath issues  RSS feed

 
Ramesh Manian
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the welcome.

I am adding the jdbc connector jar in my app's WEB-INF/lib directory.
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 66203
151
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you using container-managed connection pooling? If so, the jar file with the driver must be in the common/lib folder.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!