You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Diego Novati <di...@tin.it> on 2001/12/18 23:46:47 UTC
Re: JNDIRealm and Interbase - step 3
Hi falks !
I solved the problem of step 2 copying "interclient.jar" in
$CATALINA\common\lib and now I'm able to start Tomcat again.
Now ther's the last problem: calling
http://localhost:8080/manager/list
I'm getting a "HTTP 500 - Internal server error" and in the "catalina_log" I
have the following exception error:
2001-12-18 23:34:55 HttpProcessor[8080][4] process.invoke
java.lang.NullPointerException
at
interbase.interclient.PreparedStatement.setString(PreparedStatement.java:979
)
at org.apache.catalina.realm.JDBCRealm.credentials(JDBCRealm.java:484)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:376)
at org.apache.catalina.realm.JDBCRealm.authenticate(JDBCRealm.java:326)
....
Anyting to suggest ?
Is tehre someone who was able to use Interbase with Tomcat for JDNRRealm ?
Thanks
Diego
----- Original Message -----
From: "Diego Novati" <di...@tin.it>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Tuesday, December 18, 2001 11:19 PM
Subject: Re: JNDIRealm and Interbase - step 2
> Hi,
> thanks for your tips.
> I downloded and installed Firebird InterClient 2.01 and corrected '\' with
> '/'.
> The problem is that nothing has changed !!!!
>
> <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"/>
>
> and here's the exception:
>
> Starting service Tomcat-Standalone
> Apache Tomcat/4.0
> Catalina.start: LifecycleException: Exception opening database
connection:
> java.sql.SQLException: interbase.interclient.Driver
> LifecycleException: Exception opening database connection:
> java.sql.SQLException: interbase.interclient.Driver
> at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:615)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307)
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:388)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:505)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:776)
> at org.apache.catalina.startup.Catalina.execute(Catalina.java:681)
> at org.apache.catalina.startup.Catalina.process(Catalina.java:179)
> at java.lang.reflect.Method.invoke(Native Method)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:218)
>
> Any ideas ?
>
> Thanks
>
> Diego
>
> ----- Original Message -----
> From: "Michael Weissenbacher" <MW...@net4you.net>
> To: "'Tomcat Users List'" <to...@jakarta.apache.org>
> Sent: Tuesday, December 18, 2001 10:30 PM
> Subject: RE: JNDIRealm and Interbase
>
>
> > beware of interclient 2.0, it has some serious memory leak. i advice you
> to
> > you firebird 1.0.0 rc1 instead of interbase6 open source, it has fixed
> many
> > bugs of the original borland open source version. look at
> > http://firebird.sourceforge.net/ where you can also get interclient 2.01
> > without the memory leak.
> > and it's possible to simply use / instead of \\ for the connection url
in
> > winnt.
> >
> > michael
> >
> > -----Original Message-----
> > From: Guido Medina [mailto:gmedina@mercantil.com.do]
> > Sent: Tuesday, December 18, 2001 10:13 PM
> > To: 'Tomcat Users List'
> > Subject: RE: JNDIRealm and Interbase
> >
> >
> > Yes, it is a Java String problem, remember (again) that tomcat is made
in
> > java and a JVM is running, so instead of put "\" you MUST put "\\",
that's
> > it.
> >
> > Guido
> >
> > -----Original Message-----
> > From: Diego Novati [mailto:dienovat@tin.it]
> > Sent: Tuesday, December 18, 2001 5:13 PM
> > To: Tomcat Users List
> > Subject: JNDIRealm and Interbase
> >
> >
> > 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: <ma...@jakarta.apache.org>
> > For additional commands: <ma...@jakarta.apache.org>
> > Troubles with the list: <ma...@jakarta.apache.org>
> >
> > --
> > To unsubscribe: <ma...@jakarta.apache.org>
> > For additional commands: <ma...@jakarta.apache.org>
> > Troubles with the list: <ma...@jakarta.apache.org>
> >
>
>
> --
> To unsubscribe: <ma...@jakarta.apache.org>
> For additional commands: <ma...@jakarta.apache.org>
> Troubles with the list: <ma...@jakarta.apache.org>
>
--
To unsubscribe: <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>