Subject Most of the time I got "Get Connection Error "
Author Mohd. Jeffry
Hi All,

One of my Java apps is having difficult times to connect to firebird
db. Only this one app. Below is the error log that I got from the
apps. The thing about this problem is, it happens with out any pattern
which make it hard for me to troubleshoot. The apps and the db are in
different server but in the same 1GB network segments. The apps server
also host another java web apps which is connecting to the same db
without any problem. Any helps/ hint/ clue will be appreciated. Thanks
in advance.

Get Connection Error, Logged Date Time ::: 2005-04-05 01:14:29.485
org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unable to
complete network request to host "192.168.1.73".
Reason: Unable to complete network request to host "192.168.1.73".
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:106)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:221)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.ies.jco.server.ConnectionHelper.getConnection(ConnectionHelper.java:31)
at com.ies.jco.server.PostingQueueProcessor.run(PostingQueueProcessor.java:114)
at java.lang.Thread.run(Thread.java:534)
at org.firebirdsql.gds.GDSException: Unable to complete network
request to host "192.168.1.73".
at org.firebirdsql.jgds.GDS_Impl.connect(GDS_Impl.java:1662)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:282)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:258)
at org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:540)
at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:88)
at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:366)
at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:60)
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:103)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:221)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.ies.jco.server.ConnectionHelper.getConnection(ConnectionHelper.java:31)
at com.ies.jco.server.PostingQueueProcessor.run(PostingQueueProcessor.java:114)
at java.lang.Thread.run(Thread.java:534)

server setup:

Application server:
OS : RHEL
jdk/jre : sun-1.4.2-7
the other java web apps is running on tomcat 4.1


DB server
OS:RHEL
db: Firebird-1.5.2