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]
