Form based authentication and JDBC Realm with Interbase
Hi I'am try to get form based authentication working with jBoss/Tomcat and interbase 5.6 but I'am getting the following error. Interbase is working fine for the CMP and code and general setup works fine with mySQL (our other trial database). It looks to me like the param being setup for the query by PreparedStatement.setString is Null and hence the error Version used Interclient 1.6 jBoss 2.0 Final Tomcat 3.2 Win 2000 2001-01-23 10:23:17 - ContextManager: JDBCRealm: JDBCRealm.authenticate: SELECT USER_PASS FROM USERS WHERE USER_NAME = ? 2001-01-23 10:23:18 - Ctx( /war ): Exception in: R( /war + /member/test.jsp + null) - java.lang.NullPointerException at interbase.interclient.PreparedStatement.setString(Unknown Source) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:306) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:480) at org.apache.tomcat.core.ContextManager.doAuthenticate(ContextManager.java, Compiled Code) at org.apache.tomcat.core.RequestImpl.getRemoteUser(RequestImpl.java:341) at org.apache.tomcat.request.JDBCRealm.authorize(JDBCRealm.java:501) at org.apache.tomcat.core.ContextManager.doAuthorize(ContextManager.java, Compiled Code) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:78 9) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java, Compiled Code) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java, Compiled Code) at java.lang.Thread.run(Thread.java:479) Anybody got any ideas Thanks in advance Nigel Nigel Stirzaker Software Consultant SSA Softwright (01753) 811833 Ext 265 [EMAIL PROTECTED] www.Softwright.co.uk - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
FW: Form based authentication and JDBC Realm with Interbase
Sorry to post this again but I was asked to include the relevant section of the server.xml file RequestInterceptor className="org.apache.tomcat.request.JDBCRealm" debug="99" driverName="interbase.interclient.Driver" connectionURL="jdbc:interbase://localhost:3060/D:/Development/DBs/authority. gdb" connectionName="sysdba" connectionPassword="masterkey" userTable="USERS" userNameCol="USER_NAME" userCredCol="USER_PASS" userRoleTable="USER_ROLES" roleNameCol="ROLE_NAME" / RequestInterceptor className="org.apache.tomcat.request.Jdk12Interceptor" debug="0" / Thanks Nigel -Original Message- From: Nigel Stirzaker Sent: Tuesday 23 January 2001 11:41 To: '[EMAIL PROTECTED]' Subject: Form based authentication and JDBC Realm with Interbase Hi I'am try to get form based authentication working with jBoss/Tomcat and interbase 5.6 but I'am getting the following error. Interbase is working fine for the CMP and code and general setup works fine with mySQL (our other trial database). It looks to me like the param being setup for the query by PreparedStatement.setString is Null and hence the error Version used Interclient 1.6 jBoss 2.0 Final Tomcat 3.2 Win 2000 2001-01-23 10:23:17 - ContextManager: JDBCRealm: JDBCRealm.authenticate: SELECT USER_PASS FROM USERS WHERE USER_NAME = ? 2001-01-23 10:23:18 - Ctx( /war ): Exception in: R( /war + /member/test.jsp + null) - java.lang.NullPointerException at interbase.interclient.PreparedStatement.setString(Unknown Source) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:306) at org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:480) at org.apache.tomcat.core.ContextManager.doAuthenticate(ContextManager.java, Compiled Code) at org.apache.tomcat.core.RequestImpl.getRemoteUser(RequestImpl.java:341) at org.apache.tomcat.request.JDBCRealm.authorize(JDBCRealm.java:501) at org.apache.tomcat.core.ContextManager.doAuthorize(ContextManager.java, Compiled Code) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java: 789) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(Htt pConnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java, Compiled Code) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java, Compiled Code) at java.lang.Thread.run(Thread.java:479) Anybody got any ideas Thanks in advance Nigel Nigel Stirzaker Software Consultant SSA Softwright (01753) 811833 Ext 265 [EMAIL PROTECTED] www.Softwright.co.uk - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
RE: Form based authentication and JDBC Realm with Interbase
Thanks
I've posted it onto the list. Here is a copy aswell
RequestInterceptor
className="org.apache.tomcat.request.JDBCRealm"
debug="99"
driverName="interbase.interclient.Driver"
connectionURL="jdbc:interbase://localhost:3060/D:/Development/DBs/authority.
gdb"
connectionName="sysdba"
connectionPassword="masterkey"
userTable="USERS"
userNameCol="USER_NAME"
userCredCol="USER_PASS"
userRoleTable="USER_ROLES"
roleNameCol="ROLE_NAME" /
RequestInterceptor
className="org.apache.tomcat.request.Jdk12Interceptor"
debug="0"
/
thanks
Nigel Stirzaker
Software Consultant
SSA Softwright
(01753) 811833 Ext 265
[EMAIL PROTECTED]
www.Softwright.co.uk
-Original Message-
From: Ignacio J. Ortega [mailto:[EMAIL PROTECTED]]
Sent: Tuesday 23 January 2001 12:07
To: '[EMAIL PROTECTED]'
Subject: RE: Form based authentication and JDBC Realm with Interbase
Please post your server.xml JDBRealm config, to have a look at it..
Saludos ,
Ignacio J. Ortega
-Mensaje original-
De: Nigel Stirzaker [mailto:[EMAIL PROTECTED]]
Enviado el: martes 23 de enero de 2001 12:41
Para: '[EMAIL PROTECTED]'
Asunto: Form based authentication and JDBC Realm with Interbase
Hi
I'am try to get form based authentication working with
jBoss/Tomcat and
interbase 5.6 but I'am getting the following error. Interbase
is working
fine for the CMP
and code and general setup works fine with mySQL (our other
trial database).
It looks to me like the param being setup for the query by
PreparedStatement.setString
is Null and hence the error
Version used
Interclient 1.6
jBoss 2.0 Final
Tomcat 3.2
Win 2000
2001-01-23 10:23:17 - ContextManager: JDBCRealm:
JDBCRealm.authenticate:
SELECT USER_PASS FROM USERS WHERE USER_NAME = ?
2001-01-23 10:23:18 - Ctx( /war ): Exception in: R( /war +
/member/test.jsp
+ null) - java.lang.NullPointerException
at
interbase.interclient.PreparedStatement.setString(Unknown Source)
at
org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:306)
at
org.apache.tomcat.request.JDBCRealm.authenticate(JDBCRealm.java:480)
at
org.apache.tomcat.core.ContextManager.doAuthenticate(ContextMa
nager.java,
Compiled Code)
at
org.apache.tomcat.core.RequestImpl.getRemoteUser(RequestImpl.java:341)
at
org.apache.tomcat.request.JDBCRealm.authorize(JDBCRealm.java:501)
at
org.apache.tomcat.core.ContextManager.doAuthorize(ContextManager.java,
Compiled Code)
at
org.apache.tomcat.core.ContextManager.internalService(ContextM
anager.java:78
9)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processCo
nnection(HttpC
onnectionHandler.java:210)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java,
Compiled Code)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java,
Compiled Code)
at java.lang.Thread.run(Thread.java:479)
Anybody got any ideas
Thanks in advance
Nigel
Nigel Stirzaker
Software Consultant
SSA Softwright
(01753) 811833 Ext 265
[EMAIL PROTECTED]
www.Softwright.co.uk
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
