Hi tribe,

I've set up a resource and realm in my server.xml and placed the mysql
driver in ~DOMAIN_DOCROOT/WEB-INF/lib. I get an exception on Tomcat
startup [1].

It seems that driver must be in shared/lib for my tomcat to start
without errors, but due to the "shared" nature of my tomcat installation
that is not an option.

Indeed, the same setup works fine on a machine of my control when the
driver is in the common library folder, but fails with the same error
when i change the driver's position to app/WEB-INF/lib.

So I mkdired a new directory for that purpose on my home folder and
added that in my catalina.properties like:

shared.loader=${catalina.base}/shared/classes,${catalina.base}/shared/lib/*.jar,/home/mbatsis/common/lib/*.jar

but it doesn't work (also tried common.loader). My path is correct...
Can this be a catalina.properties bug related to [2] and are there any
workarounds? I'm using 5.0.19 on linux.


[1] Stacktrace:


2004-04-21 02:35:22 JDBCRealm[]: Exception opening database connection
java.sql.SQLException: com.mysql.jdbc.Driver
     at org.apache.catalina.realm.JDBCRealm.open (JDBCRealm.java:635)
     at org.apache.catalina.realm.JDBCRealm.start (JDBCRealm.java:709)
     at
org.apache.catalina.core.StandardContext.start (StandardContext.java:4190)
     at
org.apache.catalina.core.ContainerBase.start (ContainerBase.java:1126)
     at
org.apache.catalina.core.StandardHost.start (StandardHost.java:832)
     at
org.apache.catalina.core.ContainerBase.start (ContainerBase.java:1126)
     at
org.apache.catalina.core.StandardEngine.start (StandardEngine.java:521)
     at
org.apache.catalina.core.StandardService.start (StandardService.java:519)
     at
org.apache.catalina.core.StandardServer.start (StandardServer.java:2345)
     at org.apache.catalina.startup.Catalina.start (Catalina.java:594)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at
sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)
     at
sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke (Method.java:324)
     at org.apache.catalina.startup.Bootstrap.start (Bootstrap.java:297)
     at org.apache.catalina.startup.Bootstrap.main (Bootstrap.java:398)

2004-04-21 02:35:41 StandardContext[]cgi: init: loglevel set to 6

[2]
http://www.faqchest.com/prgm/tomcat-l/tmct-03/tmct-0309/tmct-030958/tmct03092302_04163.html

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)