Re[2]: Difficulties getting JDBCRealm to work with MySQL driver

[hische]

Thanks Ignacio!

The realm specification in server.xml now reads:

<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
             driverName="org.gjt.mm.mysql.Driver"
          connectionURL="jdbc:mysql://localhost/authority?user=root&amp;
password=apassword"
              userTable="User" userNameCol="uname" userCredCol="password"
          userRoleTable="UserRoles" roleNameCol="rname" />

and it works.

However the main reason for me to migrate to tomcat4 at this moment is the
ability to specify a JDBC realm per webapp.
I tried to move the Realm tag above to a web.xml file but got the following
error:

org.xml.sax.SAXParseException: Element "web-app" does not allow "Realm" here.

I checked $TOMCAT/conf/web_23.dtd and there is no mention of a realm tag indeed.

Do you have a suggestion on how to proceed?

Thanks,

Wilko






"Ignacio J. Ortega" <[EMAIL PROTECTED]> on 31-01-2001 12:13:15

Please respond to [EMAIL PROTECTED]

To:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:    (bcc: Wilko Hische/HADV/NL)
Subject:  RE: Difficulties getting JDBCRealm to work with MySQL driver



> Changing the semicolon in the connectionURL to an ampersand (= correct
> org.gjt.mm.mysql syntax) was refused by the SAX parser?
>
> Am I overlooking something?  I am using Tomcat4-4.0-b1.1

in XML the ampersand is a special character, is forbidden in XML to
insert and "&" as is , to insert an ampersand you need use "&amp;"


Saludos ,
Ignacio J. Ortega


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]








---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]