Resource problelm in Tomcat deployment

Hi,

I have got a connection to MySQL5.0 from TomCat 5.5.13, that was test correctly in development (JSC Upd 1) but I encounter the following deployment error :

com.sun.rave.web.ui.appbase.ApplicationException: org.apache.jasper.JasperException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

When I verify, I found that if I put the mysql Connector JDBC driver in<tomcat>/common/lib, there is no error.

But when the MySql Connector JDBC driver resides in<tomcat>/shared/lib, the error persists.

What's the difference ? shouldn't it work for both ?

Thanks in advance for any pointers and advise.

[739 byte] By [merlin_aa] at [2007-10-3 5:16:28]
# 1

> When I verify, I found that if I put the mysql

> Connector JDBC driver in

> <tomcat>/common/lib, there is no

> error.

Because that's where Tomcat expects driver jars; as mentioned in the documentation.

> But when the MySql Connector JDBC driver resides in

> <tomcat>/shared/lib, the error

> persists.

Because that directory is intended for a different purpose. The jars inside that are available to all web applications, but not in the server classpath.

> What's the difference ? shouldn't it work for both ?

As above!

aniseeda at 2007-7-14 23:23:07 > top of Java-index,Core,Core APIs...