tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sarah Parrott" <parrott.sa...@googlemail.com>
Subject Re: Problem with tomcat realms - can't connect to MySQL
Date Sun, 04 Jun 2006 12:06:54 GMT
That works! Thank you!

Sarah :)

On 04/06/06, Guido Schoepp <gus-apache@guxx.net> 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: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message