When I get rid of the single quotes, the Mysql JDBC driver throws an SQLException that says something like "column USERNAME not found"
I originally had it without the single quotes. To solve the error I added them just to try it and it worked, so I left them. Justin Tim Funk <[EMAIL PROTECTED]> 11/19/2003 05:37 PM Please respond to "Tomcat Users List" <[EMAIL PROTECTED]> To Tomcat Users List <[EMAIL PROTECTED]> cc Subject Re: JDBC Realm Get rid of the single quotes. userNameCol="USERNAME" -Tim Justin Wesbrooks wrote: > > > > I have a JDBCRealm set up in Tomcat 4.1.29. The realm config is as > follows.. > > <Realm className="org.apache.catalina.realm.JDBCRealm" > debug="99" driverName="org.gjt.mm.mysql.Driver" > connectionURL="jdbc:mysql://localhost:3306/cofc?user=root;password=root" > userTable="users" > userNameCol="'USERNAME'" > userCredCol="'USERPASS'" > userRoleTable="user_roles" > roleNameCol="'UR_ROLENAME'"/> > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
