Using JDBCRealm in tomcat

Add the following to conf/server.xml :
- <!-- uncomment if digests should be used (i.e. encrypted passwords)
digest="MD5"
-->
<Realm className="org.apache.catalina.realm.JDBCRealm" driverName="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/schemaName" connectionName="dbUser" connectionPassword="dbPasswd" userTable="user" userNameCol="alias" userCredCol="password" userRoleTable="user_roles" roleNameCol="role_name" />

Remember to put the JDBC-drivers jar in ${cataline.home}/lib.