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.