You should also be able to use connectionUser="dbuser" and connectionPassword="dbpass" in the realm tag instead of putting it in the URL.
Rick ----- Original Message ----- From: "John Murtari" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 23, 2002 2:20 PM Subject: JDBC Realm example > > I am not sure if this has come up or not, but the example showing how > to do a JDBC realm at > http://jakarta.apache.org/tomcat/tomcat-4.1-doc/realm-howto.html#JDBCRealm > is incorrect. > > The example shows : > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > driverName="org.gjt.mm.mysql.Driver" > connectionURL="jdbc:mysql://localhost/authority?user=dbuser&password=dbpass" > userTable="users" userNameCol="user_name" userCredCol="user_pass" > userRoleTable="user_roles" roleNameCol="role_name"/> > > This does not get past the XML parser because the parser does not like > the & all by itself. This should be the HTML entity for the & > instead: > > <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"/> > > > > -- > John > ___________________________________________________________________ > John Murtari Software Workshop Inc. > [EMAIL PROTECTED] 315.695.1301(x-211) "TheBook.Com" (TM) > http://www.thebook.com/ -- To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
