You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@tomcat.apache.org by Ken Torimaru <ke...@clickz.com> on 2001/07/19 02:50:46 UTC

JDBCRealm Errors with Tomcat/4.0-b5

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

RE: JDBCRealm Errors with Tomcat/4.0-b5

Posted by Ken Torimaru <ke...@clickz.com>.

Ok, first one solved.
mm.mysql-2.0.4-bin.jar should be in "{$CATALINA_HOME}/server/lib" not
"{$CATALINA_HOME}/lib"

-----Original Message-----
From: Ken Torimaru [mailto:ken@clickz.com]
Sent: Wednesday, July 18, 2001 5:51 PM
To: Tomcat-User
Subject: JDBCRealm Errors with Tomcat/4.0-b5


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