That works! Thank you! Sarah :)
On 04/06/06, Guido Schoepp <[EMAIL PROTECTED]> wrote:
Sarah Parrott schrieb: > and in my servers.xml document: > <Realm className="org.apache.catalina.realm.JDBCRealm" > connectionName="tomcat" connectionPassword="pword" > connectionURL="jdbc:mysql://localhost/authority" driverName=" > org.gjt.mm.mysql.Driver" roleNameCol="role_ID" userCredCol="pword" > userNameCol="username" userRoleTable="user_roles" userTable="members"/> > [...] > I've added the jar file for the jdbc driver to the classpath for the > project, and I can connect to the database fine through eclipses 'Database > Explorer' using the same connection URL. > > Any ideas why this is not working? By configuring the realm in tomcats server.xml it is necessary that the jdbc driver jar file is in the classpath of tomcat/catalina. Look at http://tomcat.apache.org/tomcat-5.0-doc/realm-howto.html#JDBCRealm: Place a copy of the JDBC driver you will be using inside the $CATALINA_HOME/server/lib directory (if you do not need it visible to web applications) or $CATALINA_HOME/common/lib (if it will be used both by Tomcat 5 and by your apps). Note that only JAR files are recognized! Guido --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
