Strange, I found this non-";"-separated example in:

http://jakarta.apache.org/tomcat/tomcat-4.1-doc/realm-howto.html#JDBCRea
lm


<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
      driverName="org.gjt.mm.mysql.Driver"
 
connectionURL="jdbc:mysql://localhost/authority?user=dbuser&password=dbp
ass"
       userTable="users" userNameCol="user_name" userCredCol="user_pass"
   userRoleTable="user_roles" roleNameCol="role_name"/>

Your note for the & in xml is true, but shouldn't matter in a quoted
string, or do I mix something up now?

Anyway... Using the connectionName, connectionPassword attributes and
you are on the safe side...

Michael


> -----Original Message-----
> From: Ralph Einfeldt [mailto:[EMAIL PROTECTED]] 
> Sent: Dienstag, 14. Januar 2003 14:25
> To: Tomcat Users List; [EMAIL PROTECTED]
> Subject: RE: JDBCRealm problem with MySQL after adding 
> password and changing user account
> 
> 
> If you want to use & inside xml you have to encode it.
> 
> ?user=praksis&password=foo
> should be changed to
> ?user=praksis&amp;password=foo
> 
> 
> BTW: In the JDBCRealm-howto they use ; to seperate
> the password from the user.
> 
> ?user=praksis;password=foo
> 
> As I'm not using mysql I'm not shure if that is correct.
> 
> > -----Original Message-----
> > From: mech [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 14, 2003 2:06 PM
> > To: [EMAIL PROTECTED]
> > Subject: JDBCRealm problem with MySQL after adding password
> > and changing
> > user account
> > 
> > 
> > connectionURL="jdbc:mysql://localhost:3307/praksis?user=praksi
> > s&password
> > =siskarp"
> >                     userTable="benutzer" userNameCol="email" 
> > userCredCol="passwort"
> >             userRoleTable="rollen" roleNameCol="rollenname" 
> digest="SHA-1"/>
> > 
> > Now I only get weird error messages from the xml parser:
> >     org.xml.sax.SAXParseException: The reference to entity 
> "password" 
> > must end with the ';' delimiter.
> > 
> 
> --
> To unsubscribe, e-mail:   
> <mailto:tomcat-user-> [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]>

Reply via email to