Web app using JDBCRealm runs on Tomcat 5.5.20 but will not run on Tomcat 6.0.26 ...

[Frank Burns]

I have a web app that successfully runs on Tomcat 5.5.20 but will not run on
Tomcat 6.0.26.

Can someone please help me work out why it won't run?

It's on a Windows XP, SP2 machine.

The web app uses JDBCRealm to access a mysql database.

The apps in each Tomcat version are identical (i.e., copied from one Tomcat
webapp directory to the the other) and the context that I use in the
server.xml of each Tomcat version are also identical (apart from the docBase
value). Here it is for Tomcat 5.5.20:

                 <Context path="/sfpfulladmin"
docBase="C:\SoftwareDevelopment\apache-tomcat-5.5.20\webapps\sfpfulladmin"
debug="0">
                      <Realm
className="org.apache.catalina.realm.JDBCRealm"
                             driverName="com.mysql.jdbc.Driver"
                             connectionURL="jdbc:mysql://
127.0.0.1:3306/ppadminsite"
                             connectionName="frank"
connectionPassword="burns"
                             userTable="SFP_USER" userNameCol="USERNAME"
userCredCol="PASSWORD"
                             userRoleTable="USER_ROLE_ASSOCIATION"
roleNameCol="PARENT_ROLE_NAME" />
                </Context>

Here it is for Tomcat 6.0.26.

              <Context path="/sfpfulladmin"
docBase="C:\SoftwareDevelopment\apache-tomcat-6.0.26\webapps\sfpfulladmin"
debug="0">
                      <Realm
className="org.apache.catalina.realm.JDBCRealm"
                              driverName="com.mysql.jdbc.Driver"
                              connectionURL="jdbc:mysql://
127.0.0.1:3306/ppadminsite"
                              connectionName="frank"
connectionPassword="burns"
                             userTable="SFP_USER" userNameCol="USERNAME"
userCredCol="PASSWORD"
                             userRoleTable="USER_ROLE_ASSOCIATION"
roleNameCol="PARENT_ROLE_NAME" />
                </Context>

The version of the web app in Tomcat 5.5.20 works perfectly and it can
access the database.

But the version of the web app in Tomcat 6.0.26 gives the following error in
the localhost_xxx.log file at startup:

05-Jun-2010 22:15:11 org.apache.catalina.realm.JDBCRealm start
SEVERE: Exception opening database connection
java.sql.SQLException: com.mysql.jdbc.Driver
    at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:704)
    at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:786)
    at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4359)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
    at
org.apache.catalina.core.StandardService.start(StandardService.java:519)
    at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
    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:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
05-Jun-2010 22:15:16 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
05-Jun-2010 22:15:16 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()

Any ideas?

Thanks,

Frank