Return-Path: <jlim@thinkspice.com>
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 1964 invoked from network); 8 Feb 2001 04:26:53 -0000
Received: from mail01.san.yahoo.com (209.132.1.35)
  by h31.sny.collab.net with SMTP; 8 Feb 2001 04:26:53 -0000
Received: from johnson (202.137.13.251) by mail01.san.yahoo.com (5.1.056)
        id 3A81952500035959 for tomcat-user@jakarta.apache.org;
 Wed, 7 Feb 2001 20:20:22 -0800
From: "Johnson Lim" <jlim@thinkspice.com>
To: "Tomcat-User" <tomcat-user@jakarta.apache.org>
Subject: JDBCRealm for Interbase
Date: Thu, 8 Feb 2001 11:29:41 +0700
Message-ID: <MFECLPAEKJGJBIEDLNFLOECECEAA.jlim@thinkspice.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Importance: Normal
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

Hi all,

I have tried JDBCRealm for Hypersonic, it works very well, thanks for the
TOMCAT GUYS!!

When I tried to do it on Interbase, it seem not works (please help !)

on server.xml

<RequestInterceptor className="org.apache.tomcat.request.JDBCRealm"
            debug="99"
	    driverName="interbase.interclient.Driver"
	    connectionURL="jdbc:interbase://localhost/c:\db\test.gdb"
	    connectionName="sysdba"
            connectionPassword="masterkey"
	    userTable="users"
            userNameCol="user_name"
            userCredCol="user_pass"
	    userRoleTable="user_roles"
            roleNameCol="role_name" />

when i run any authentication process an error occur:

Error: 500
Location: /Secure/admin/index.html
Internal Servlet Error:

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:839
)
	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:857)
	at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
1)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:745)
	at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC
onnectionHandler.java:210)
	at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:407)
	at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
	at java.lang.Thread.run(Thread.java:484)


Thanks in advance, any one have the clues.

Regards
Johnson