File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Tomcat and the fly likes mysql driver  in tomcat problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Tomcat
Bookmark "mysql driver  in tomcat problem" Watch "mysql driver  in tomcat problem" New topic

mysql driver in tomcat problem

michael yue
Ranch Hand

Joined: Nov 20, 2003
Posts: 204
I installed java web service, jwsdp-1_0_01 which also includes tomcat server. I am using it to connect to mysql db server. A driver, mysql-connector-java is provided to help in the connection. Its a jar file. I want to know where i should put this file to enable it to function. I put in C:\jwsdp-1_0_01\common\lib and in C:\jwsdp-1_0_01\shared\lib but nothing seems to be working. Anyone has any experience in this?
surendra kumar H.A

Joined: Sep 29, 2003
Posts: 1
i am facing the same problem with oracle.if you have overcome that problem please help me
Carl Trusiak

Joined: Jun 13, 2000
Posts: 3340
The answer is the same for both of you. It depends! If you want it available to the server, it needs to be in the server classpath. For Tomcat this is server/lib I don't remember oc4j's directory structure well enough but, look for the or jar and place it with that. This will make the jar available for use with JNDI and sounds like that's what you are looking for. The shared lib is good if you are creating your own connection pool in your webapp. Another loction for this is in your webapps lib directory.

I Hope This Helps
Carl Trusiak, SCJP2, SCWCD
I agree. Here's the link:
subject: mysql driver in tomcat problem
It's not a secret anymore!