I'm not the original developer who set this up, but I'm told we had to do it this way because our main database where most of the data for our web app would not authenticate with Tomcat, so they set up a MySQL database on the webserver whose only reason for existence is to authenticate the users. Now we have an updated version of the main database we use (which we connect to over ODBC, not JDBC--yeah, don't ask), and so we're curious as to whether or not we might now be able to authenticate with this updated database instead of still having to rely on this second MySQL database.
I'm not really familiar with how to change this part of our web.xml, though:
Any ideas? Since there's no JDBC driver for our main database, I'm thinking we can't even use that JDBCRealm stuff anymore, and wondering if we might have to convert from basic authentication to form-based authentication. Thanks a bunch for any suggestions!