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]