It makes sense to put the JDBC driver jars in the war but I had problems
when I had a resource like the following in my context.xml:
<Resource
name="jdbc/database"
url="jdbc:mysql://localhost:3306/art"
driverClassName="com.mysql.jdbc.Driver"
username="art"
password="art"
validationQuery="select 1"
type="javax.sql.DataSource"
maxIdle="2"
maxWait="5000"
maxActive="4"
/>
And doing a JNDI lookup for the Datasource. I ended up getting Class Not
Found exceptions until I moved the Jar files into the Common Tomcat Lib
directory. This was with Tomcat 6.0.14 and it was about 4-6 months ago.
I've never got back into looking at it closer.
Just food for thought.
jfk
-----Original Message-----
From: Caldarale, Charles R [mailto:[EMAIL PROTECTED]
Sent: Friday, February 22, 2008 12:30 PM
To: Tomcat Users List
Subject: RE: JDBC driver JARs in a shared production environment
> From: Kirchhoff, Florian [mailto:[EMAIL PROTECTED]
> Subject: JDBC driver JARs in a shared production environment
>
> Question: if you cannot place the JDBC driver jars in
> CATALINA_HOME/commons/lib, where can you put them?
>
> 1) Place the JDBC jars in $CATALINA_BASE/jdbc and modify the start-up
> script to include these jars on the CLASSPATH?
> 2) Deploy the JDBC jars in the WAR file (e.g. WEB-INF/lib/jdbc) and
> modify the start-up script to include these jar on the CLASSPATH?
NEVER, NEVER, NEVER set CLASSPATH for use with Tomcat.
> 3) Deploy the JDBC jars and commons-dbcp.jar in the WAR in
> WEB-INF/lib?
Yes.
- Chuck
THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you
received this in error, please contact the sender and delete the e-mail
and its attachments from all computers.
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
