Catalina.out
Is reporting the following error:
Starting service Tomcat-Standalone
Apache Tomcat/4.0-b5
Catalina.start: LifecycleException: Exception opening database connection:
java.sql.SQLException: org.gjt.mm.mysql.Driver
LifecycleException: Exception opening database connection:
java.sql.SQLException: org.gjt.mm.mysql.Driver
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:609)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:278)
at org.apache.catalina.core.StandardService.start(StandardService.java:353)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:458)
at org.apache.catalina.startup.Catalina.start(Catalina.java:725)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:647)
at org.apache.catalina.startup.Catalina.process(Catalina.java:177)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:196)
----- Root Cause -----
java.sql.SQLException: org.gjt.mm.mysql.Driver
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:529)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:607)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:278)
at org.apache.catalina.core.StandardService.start(StandardService.java:353)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:458)
at org.apache.catalina.startup.Catalina.start(Catalina.java:725)
at org.apache.catalina.startup.Catalina.execute(Catalina.java:647)
at org.apache.catalina.startup.Catalina.process(Catalina.java:177)
at java.lang.reflect.Method.invoke(Native Method)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:196)
My Realm is setup as follows:
<Realm className="org.apache.catalina.realm.JDBCRealm"
connectionName="webuser"
connectionPassword="password"
connectionURL="jdbc:mysql://localhost/tori"
digest="no"
driverName="org.gjt.mm.mysql.Driver"
roleNameCol="role_name"
userCredCol="user_pass"
userNameCol="user_name"
userRoleTable="user_roles"
userTable="users"
debug="99"
/>
And mm.mysql-2.0.4-bin.jar is located in the lib directory.
Further, I've have a simple JSP which can access the data in question.
I've got no clue why this isn't working?
Any ideas?
Ken