I put jdbc driver in all directories, in "regular directory" and in jar file. In Tomcat 3.2 it worked, not in 4.0.
Pawel -----Original Message----- From: John Gregg [mailto:[EMAIL PROTECTED]] Sent: Monday, June 17, 2002 7:12 PM To: 'Tomcat Users List' Subject: RE: Database connection - Catalina Tomcat probably isn't finding your jdbc driver. The exception's getMessage() method is returning a class name, which usually means ClassNotFoundException or ClassCastException. Read this: http://jakarta.apache.org/tomcat/tomcat-4.0-doc/class-loader-howto.html john -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]. org]On Behalf Of Skorupski Pawel ,(PZUZ) Sent: Monday, June 17, 2002 7:32 AM To: '[EMAIL PROTECTED]' Subject: Database connection - Catalina Hello, I've got a problem with Tomcat 4.0 (Catalina). After setting up REALM: <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="org.gjt.mm.mysql.Driver" connectionURL="jdbc:mysql://localhost/authority?user=test&password=test" userTable="users" userNameCol="user_name" userCredCol="user_pass" userRoleTable="user_roles" roleNameCol="role_name" /> I can not connect to mysql server which is running on localhost. The error I received is: Catalina.start:Lifecycle Exception: Exception opening database connection: java.sql.SQLException: org.gjt.mm.mysql.Driver I ran through many faq's lists and the only solution I found was: check tables, all names etc. I've checked not twice but ten times receiving the same type of error. I use FORM type of authentication. Everything was ok with Tomcat 3.2 and got worse after installing new version of Tomcat. Libraries: org.jar, servlet.jar are added to classpath. I would be grateful for any help. Pawel -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>