Using JDBCRealm in JSP application

[Rudy Rusli]

I'm trying to use JDBC-Realm to save username and password information for my JSP application.
But it seems that the username and login doesn't work when I try to login.

I built two tables in MySQL database called 'user' and 'roles'.
There is only one entry in each table:
user (column names: username, password) -> 'myname', 'mypassword'
roles (column names: username, roles) -> 'myname', 'myrole'

Then I put these lines below in my server.xml.
<Realm className="org.apache.catalina.realm.JDBCRealm" debug="99"
driverName="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/startdb?dontTrackOpenResources=true&zeroDateTimeBehavior=convertToNull"
connectionName="myDbUsername" connectionPassword="myDbPassword"
userTable="user" userNameCol="username" userCredCol="password"
userRoleTable="roles" roleNameCol="roles" />

I try to login using 'myname' and 'mypassword' but it doesn't work.

Can somebody please advice?
Thanks.

ps: I'm using Tomcat 5.5