Peter Ivarsson wrote:
>
> 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
>
> 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>
>

Are you sure of your configuration? There used to be 2 jdbc drivers for
MySQL, the twzl driver, and Mark Matthews mm driver. twzl stopped being
maintained (IIRC), and the mm driver became the 'official' driver. Do
you have both drivers visible to the classloader? If so, it looks as
though it's choosing the wrong one. Delete (or move out of harms way)
the twzl driver, and see if things improve.

HTH
Martin


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