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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
