Hi Howard, I am writing this direct since, its little of topic. I too had similar problems, what i did was that in the jdbc realm howto document, there is connectionPassword and connectionNAme attributes so I removed the attributes from connectionURL and had the atributes separately (in server.xml). Anyways, I still could get the thing done, since after that I got error a "can't set auto-commit off" I wrote this couple of times in user list but didn't get any response... is it that in mysql there is no such option to turn off auto-commit? If you don't mind, would you please let me know if it worked for you? and how. I am using Tomcat 4.0.4, MySQL3.23, the driver mm.mysql.2.14.jar.. I am quite a beginner in all this..(am student) and would appriciate your feed back, Thanks, Khozaima
>From: Howard Miller <[EMAIL PROTECTED]> >Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> >To: 'Tomcat Users List' <[EMAIL PROTECTED]> >Subject: RE: JDBCReal / MySql /server.xml problem >Date: Thu, 5 Sep 2002 11:44:42 +0100 > >Ahh, logical - thanks... I'm not too hot on XML sorry! > >So, does somebody want to update the example in the Tomcat docs then? >Wasted >half a day because of that! > >Cheers, > >Howard > >-----Original Message----- >From: Barney Hamish [mailto:[EMAIL PROTECTED]] >Sent: 05 September 2002 11:38 >To: 'Tomcat Users List' >Subject: RE: JDBCReal / MySql /server.xml problem > > >In xml you can't just write & because it has special meaning. It's used to >escape special characters. To get an & you'll have to write >....&password=foo.... >Hamish > > > -----Original Message----- > > From: Howard Miller [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, September 05, 2002 12:39 PM > > To: '[EMAIL PROTECTED]' > > Subject: JDBCReal / MySql /server.xml problem > > > > > > Hi, > > > > I am trying to set up a JDBCRealm using MySql. I have pretty > > much followed > > the documentation to the letter. > > > > However my <Realm... tag declaration, generates the > > following parse error > > > > "The reference to entity "password" must end with the ";" delimter." > > > > This points to the &password=mypassword bit of the > > connectionURL attribute. > > Removing the &password bit of the string gets rid of the error, but of > > couurse it then won't connect to the database. As there is no DTD for > > server.xml I am somewhat stumped. I don't think I have done anything > > different from the documentation > > > > BTW I am using Tomcat version 4.1.9. > > > > Any help appreciated. > > > > Howard > > > > -- > > To unsubscribe, e-mail: ><mailto:[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]> > >-- >To unsubscribe, e-mail: ><mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: ><mailto:[EMAIL PROTECTED]> _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
