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 amp;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]
RE: JDBCReal / MySql /server.xml problem
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 amp;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]
RE: JDBCReal / MySql /server.xml problem
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 amp;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]