Experimented successfully with the UserDatabaseRealm - and I'm now attempting to implement a JDBCRealm with PostgreSQL 9.05
Receiving the following
Tomcat error when trying to open the admin/manager GUIs:
Tried
JDBC drivers postgresql-8.4-702.jdbc3.jar & postgresql-8.4-702.jdbc4.jar - both produce the same error.
Tomcat Console output:
Ruled out a problem with the connectionURL, connectionName, connectionPassword and userTable by systematically snarking these up to see how/if Tomcat would fail. All presently have reasonable values that seem to be acceptable to Tomcat.
I have tried renaming the userName and userCredCol database columns/realm attributes - the same problem persists - the only difference being that the cred column it complains about has the new name.
What have I got wrong? I'm at a loss with regard to what else to try...