Subject Re: Need help with JCA/JDBC driver install to connect to Firebird Database - Linux
Author Bijilal Poikayil
Rick,

Finally I figured out the Tomcat part it is working fine. But still
the JDBC part seems to not working.

Current software version I have:

Webserver
==========
Server version: Apache Tomcat/5.5.17
OS Name: Linux
OS Version: 2.6.9-5.EL
Architecture: i386
JVM Version: 1.5.0_01-b08
JVM Vendor: Sun Microsystems Inc.

Firebird version:
================
SQL> show version;
ISQL Version: LI-V1.5.3.4870 Firebird 1.5
Firebird/linux Intel (access method), version "LI-V1.5.3.4870
Firebird 1.5"
Firebird/linux Intel (remote server), version "LI-V1.5.3.4870
Firebird 1.5/tcp (hostname)/P10"
Firebird/linux Intel (remote interface), version "LI-V1.5.3.4870
Firebird 1.5/tcp (hostname)/P10"
on disk structure version 10.1
SQL>


Jbird Version
=============
Using file - jaybird-full-2.0.1.jar extracted from JayBird-
2.0.1JDK_1.5.zip

Can you please suggest me what other setup I am missing here since I
am pretty much on the new version of software now.
Thanks a bunch for your help and time.

Error stack from tomcat logs
============================
May 4, 2006 1:19:03 AM org.apache.catalina.realm.JDBCRealm
authenticate
SEVERE: Exception performing authentication
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544721.
Unable to complete network request to host "localhost".
Reason: Unable to complete network request to host "localhost".
at org.firebirdsql.jdbc.FBDataSource.getConnection
(FBDataSource.java:122)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:131)
at org.apache.catalina.realm.JDBCRealm.open
(JDBCRealm.java:699)
at org.apache.catalina.realm.JDBCRealm.authenticate
(JDBCRealm.java:344)
at
org.apache.catalina.authenticator.FormAuthenticator.authenticate
(FormAuthenticator.java:257)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java:416)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
at org.firebirdsql.gds.GDSException: Unable to complete network
request to host "localhost".
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.connect
(AbstractJavaGDSImpl.java:1947)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.isc_attach_database
(AbstractJavaGDSImpl.java:386)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscAttachDatabase
(AbstractJavaGDSImpl.java:362)
at org.firebirdsql.jca.FBManagedConnection.<init>
(FBManagedConnection.java:89)
at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnectio
n(FBManagedConnectionFactory.java:462)
at
org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection
(FBStandAloneConnectionManager.java:69)
at org.firebirdsql.jdbc.FBDataSource.getConnection
(FBDataSource.java:119)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:131)
at org.apache.catalina.realm.JDBCRealm.open
(JDBCRealm.java:699)
at org.apache.catalina.realm.JDBCRealm.authenticate
(JDBCRealm.java:344)
at
org.apache.catalina.authenticator.FormAuthenticator.authenticate
(FormAuthenticator.java:257)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java:416)
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
$


Biji

--- In Firebird-Java@yahoogroups.com, "Bijilal Poikayil"
<bijilal@...> wrote:
>
> Hi Rick,
>
> Thanks for your reply. As you suggested I tried to install Tomcat
> 5.5.17. The install went fine and tomcat was able to run fine. I
did
> configure the manager role to login, which also worked.
>
> But when I added the context which I had on my Tomcat 5.5.9
install
> the directory that used to show up is not coming up now.
>
> This is how I have it set in the server.xml file, right above
> </Host> entry.
>
> ++
> <Context path="/picture" docBase="test" debug="0"
> reloadable="true" />
> </Host>
> ++
>
> Where "test" is a directory located as $CATALINA_HOME/webapps/test
>
> When I try to access www.mydomain.com/picture, I get the error
> below. This used to work just fine with my Tomcat 5.5.9, but not
on
> 5.5.17. I did bounce tomcat after these changes, but did not help.
I
> also read that you need to have the context entry in the
context.xml
> file for tomcat version 5.5.x, but not really clear on this.
> ++
> HTTP Status 404 - /picture/
> -------------------------------------------------------------------
--
> -----------
> type Status report
> message /picture
> description The requested resource (/picture) is not available.
> -------------------------------------------------------------------
--
> ----------
> Apache Tomcat/5.5.17
> ++
>
> I would like to keep Tomcat 5.5.17, but before I could test my
JDBC
> connection I need this context entry to work. Any one who has ran
> into this before can you please suggest what is the best fix or
work
> around here. Appreciate every one valuble time.
>
> Thanks
> Biji
>
>
> --- In Firebird-Java@yahoogroups.com, Rick Fincher <rnf@> wrote:
> >
> > Hi All,
> >
> > I'm using 2.0.1 with Tomcat 5.9.12 with no problems. I had
> already
> > updated to Tomcat 5.5.12 from 5.5.9 when JayBird 2.0 was
released
> so I
> > haven't tried it with Tomcat 5.5.9.
> >
> > If that is the problem, the update to Tomcat 5.5.12 is
painless.
> Or go
> > to 5.5.17, the current stable release. All the settings are the
> same.
> >
> > This is on Fedora Core 3 (Redhat).
> >
> > Rick
> >
> >
> > Catalin Florean wrote:
> >
> > >Jaybird 2.0.1 did not work with my Tomcat/Firebird enviroment
but
> > >Jaybird 1.5.6 worked just fine.
> > >I did not have the time to investigate the cause.
> > >
> > >I am waiting for the release of the new Firebird 2.0 to migrate
my
> > >database and have another try with Jaybird 2.
> > >
> > >Catalin Florean.
> > >
> > >On 5/3/06, Roman Rokytskyy <rrokytskyy@> wrote:
> > >
> > >
> > >>>5. You should use Jaybird 1.5.6 JDBC driver.
> > >>>
> > >>>
> > >>May I ask you what is the reason for such recommendation?
> > >>
> > >>Roman
> > >>
> > >>
> > >>
> > >
> > >
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>