JNDIRealm and Interbase

[Diego Novati]

Hi,
I need to use Interbase 6.0 OpenEdition with JNDIRealm.
Using InterClient 1.6 Tomcat start but throws an Exception during the
Authentication; using InterClient 2.0 I'm not able to start Tomcat. Is there
anyone who is able to use Interbase ?

Tomcat 4.0.1
Interbase 6.0
InterClient 1.6/InterClient 2.0

server.xml:
    ....
     <Realm className="org.apache.catalina.realm.JDBCRealm"
             driverName="interbase.interclient.Driver"
             connectionName="SYSDBA"
             connectionPassword="masterkey"
             connectionURL="jdbc:interbase://localhost/C:\Program
Files\Apache Group\Tomcat 4.0\DBUsers\DBUSERS.GDB"
             userTable="USERS" userNameCol="USER_NAME"
userCredCol="USER_PASS"
             userRoleTable="USER_ROLES" roleNameCol="ROLE_NAME"/>
   ....

Interbase:

CREATE TABLE "USERS"
(
  "USER_NAME" VARCHAR(15) NOT NULL,
  "USER_PASS" VARCHAR(15) NOT NULL,
CONSTRAINT "USERSPRIMARYKEY" PRIMARY KEY ("USER_NAME")
);

CREATE TABLE "USER_ROLES"
(
  "USER_NAME" VARCHAR(15) NOT NULL,
  "ROLE_NAME" VARCHAR(15) NOT NULL,
CONSTRAINT "USER_ROLESPRIMARYKEY" PRIMARY KEY ("USER_NAME", "ROLE_NAME")
);

Can you help me ?

Thanks

Diego Novati


--
To unsubscribe:   <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>