More JDBC Realm

[jby1]

I have managed to locate more information regarding my query about setting up JDBC Realm in Tomcat. I have encountered an exception in a catalina log file :

2003-05-02 15:49:50 JDBCRealm[Standalone]: Exception performing authentication
java.sql.SQLException: ERROR:  Attribute 'username' not found

	at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
	at org.postgresql.Connection.ExecSQL(Connection.java:398)
.
.
etc
.
.

Any ideas what may be causing this?

 

[jby1]

Sorted it out, I was looking at the wrong table for the roles!

Took me a while to figure it out though!