Thanks Rick, I did solve it by changing the "&" to "&" and that worked. But it's good to know that there is an alternative and how to go about using it.
Ken -----Original Message----- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 3:08 PM To: Tomcat Users List Subject: Re: JDBC realm problems Hi Ken, The spec allows the values: connectionName="username" connectionPassword="password" in the realm tag in server.xml. You might try that instead of putting the username and password in the connection URL. Tomcat then builds the string for the URL with the connection parameters in it. Rick > Yes I have. After some more investigation I think the problem is this: the > entry in server.xml is like this user=ken;password=ken. But mySQL wants a > "&" and xml parser demands a ";". With a ";" mySQL thinks no password was > sent and so denies me with 'password: no'. With "&" debug=99 comes into play > and tells me "The reference to entity 'password' must end with the ';' > delimiter". But as soon as I do that then mySQL no longer sees the > password!! > > I have read about the need to change the ";" to "&" while investigating on > google so I know some people have found that necessary. My problem is that I > then get the parser error. > > So it seems to me I'm sitting on the horns of a dilemma from which I hope > someone can remove me. > > Thanks! -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
