https://issues.apache.org/bugzilla/show_bug.cgi?id=53047
--- Comment #5 from Dennis Verbeek <dverb...@hotmail.com> 2012-04-10 18:02:42 UTC --- (In reply to comment #4) > FWIW, JDBCRealm isn't appropriate for production use IMO. If you can, you > should switch to DataSourceRealm which performs much better. Sure, just using JDBCRealm for kickstarting and rapid prototyping my projects. The stacktrace as requested: Apr 10, 2012 11:44:38 AM org.apache.catalina.realm.JDBCRealm getRoles SEVERE: Exception performing authentication org.postgresql.util.PSQLException: ERROR: relation "tomcat_role" does not exist Position: 18 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) at org.apache.catalina.realm.JDBCRealm.getRoles(JDBCRealm.java:644) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:436) at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:361) at org.apache.catalina.authenticator.BasicAuthenticator.authenticate(BasicAuthenticator.java:181) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:528) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:877) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:594) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1675) at java.lang.Thread.run(Thread.java:679) -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@tomcat.apache.org For additional commands, e-mail: dev-h...@tomcat.apache.org