JDBCRealm problem

["Hirschmann, Bernhard" <Be...@t-systems.com>]

Hello tomcat users!

I have a problem using the security constraint feature of tomcat.

I want to use the JDBCRealm to make a container managed authentication like
in the example in the tomcat documentation. So I declared a realm in the
server.xml with a DB table for user and role.

In my web.xml I have the <security-constraint> and the <login-config>
defining a authentication for every request (/*) on the URL of this appl.

It seems, that the authentication works fine, but right after that, a SQL
exception occures (see stack trace below) The column name is correct, and
the table name too. 

Any help highly appretiated.



2003-05-26 15:57:46 JDBCRealm[/to]: Username test@user.de successfully
authenticated
2003-05-26 15:57:46 JDBCRealm[/to]: Exception performing authentication
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0206N
"USR_EMAIL" is invalid in the used context.  SQLSTATE=42703

	at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throw_SQLException(SQLExceptionGe
nerator.java:230)
	at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGen
erator.java:394)
	at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code(SQLExceptionGen
erator.java:372)
	at
COM.ibm.db2.jdbc.net.DB2PreparedStatement.executeQuery(DB2PreparedStatement.
java:573)
	at
org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:476)
	at
org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:394)
	at
org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthent
icator.java:263)
	at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:481)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
	at java.lang.Thread.run(Thread.java:536)



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org