I got that error yesterday while installing a jdbc realm for the first time. We had to put the Database Driver Jars in CatalinaRoot/common/lib and the connection worked fine. Putting the jars in Catalina/lib did not work.
-----Original Message----- From: Eric Grace [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 5:12 PM To: [EMAIL PROTECTED] Subject: JDBCRealm & Debug Logging 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) -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
