tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nigel Stirzaker <NStirza...@softwright.co.uk>
Subject FW: Form based authentication and JDBC Realm with Interbase
Date Tue, 23 Jan 2001 12:18:55 GMT
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:	'tomcat-user@jakarta.apache.org'
> 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
> NStirzaker@Softwright.Co.Uk
> www.Softwright.co.uk
> 

Mime
View raw message