JDBCRealm & Debug Logging

[Eric Grace <eg...@doubleclick.net>]

Hello,
 
I'm getting an extremely general SQLException on startup and am
wondering if there is a way to get better debugging info that will
illuminate the real problem ( changing the debug level on the realm does
not seem to have any effect ).  It would be nice to not have to edit the
sourcecode, though it's not out of the question.  Could someone give a
bit of direction on what I might be missing here to get a JDBCRealm up
and running?  Thanks in advance.
 
I have the following Realm definition in server.xml..
 <Realm            
className="org.apache.catalina.realm.JDBCRealm" 
            debug="5" 
            driverName="org.gjt.mm.mysql.Driver" 
            connectionName="conname" 
            connectionPassword="conpass" 
            connectionURL="jdbc:mysql://localhost:3306/tomcatusers" 
            userTable="users" 
            userNameCol="login" 
            userCredCol="password" 
            userRoleTable="user_roles" 
            roleNameCol="role_name"/>
 
permissions on the data files..666 ( not for the rest of the path )
 
 
The following occurs at startup..and is dumped to catalina.out
Starting service Tomcat-Standalone
Apache Tomcat/4.0.1
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:615)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
        at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3334
)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at
org.apache.catalina.core.StandardHost.start(StandardHost.java:612)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:388)
        at
org.apache.catalina.core.StandardServer.start(StandardServer.java:505)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:776)
        at
org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
        at
org.apache.catalina.startup.Catalina.process(Catalina.java:179)
        at java.lang.reflect.Method.invoke(Native Method)
        at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)
----- Root Cause -----
java.sql.SQLException: org.gjt.mm.mysql.Driver
        at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:538)
        at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
        at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3334
)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at
org.apache.catalina.core.StandardHost.start(StandardHost.java:612)
        at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123)
        at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307)
        at
org.apache.catalina.core.StandardService.start(StandardService.java:388)
        at
org.apache.catalina.core.StandardServer.start(StandardServer.java:505)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:776)
        at
org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
        at
org.apache.catalina.startup.Catalina.process(Catalina.java:179)
        at java.lang.reflect.Method.invoke(Native Method)
        at
org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243)