Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Tomcat Users »

Problem using realm to connect to a database

Peter Ivarsson

2003-10-14

Replies:


Hi,

I have problem with connecting to a Realm database.

I get this error.
Catalina.start: LifecycleException: Exception opening database connection:
java.sql.SQLException: twz1.jdbc.mysql.jdbcMysqlDriver
LifecycleException: Exception opening database connection:
java.sql.SQLException: twz1.jdbc.mysql.jdbcMysqlDriver
 at org.apache.catalina.realm.JDBCRealm.start (JDBCRealm.java:681)
 at
org.apache.catalina.core.StandardContext.start (StandardContext.java:3543)
 at
org.apache.catalina.core.ContainerBase.start (ContainerBase.java:1188)

Useing driver com.mysql.jdbc.Driver version 3.09
MySQL version 3.23.38
Tomcat version 4.1.24

I have put the folowing rows into the server.xml:

<Context path="/esadmin" reloadable="true" docBase="C:\Program Files\Apache
Group\Tomcat 4.1\webapps\esadmin">
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
   driverName="com.mysql.jdbc.Driver"
   connectionName="XXX"
   connectionPassword="YYYY"
   connectionURL="jdbc:mysql://localhost:3306/estid2"
   userTable="admins"
   userNameCol="user_name"
   userCredCol="user_pass"
   userRoleTable="user_roles"
   roleNameCol="role_name" />
</Context>

Please helpTanks

/ Peter Ivarsson


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)


©2008 junlu.com - Jax Systems, LLC, U.S.A.