Subject Firebird and JDBC, critical problem
Author a_broekhuis
Hi,

I am using firebirdsql with JDBC, me process has to add messages
constantly to the database, but somehow at some point the connection
with the database is lost and messaged don't get added in the database.

As far as i can tell it has to do with firebird, the memory it uses
grows until some point and then gets processed or something (not sure
how and what) At this point some messages get lost.

Stack trace:
org.firebirdsql.jdbc.FBSQLException: Resource Exception. 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:106)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:221)

And also:
org.firebirdsql.gds.GDSException: Error reading data from the connection.
null
at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1726)
at org.firebirdsql.jgds.GDS_Impl.isc_start_transaction(GDS_Impl.java:546)
at
org.firebirdsql.jca.FBManagedConnectionFactory.getCurrentIscTrHandle(FBManagedConnectionFactory.java:485)
at
org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(FBManagedConnection.java:1098)
at
org.firebirdsql.jca.FBManagedConnection.internalStart(FBManagedConnection.java:655)
at
org.firebirdsql.jca.FBLocalTransaction.internalBegin(FBLocalTransaction.java:107)
at
org.firebirdsql.jca.FBLocalTransaction.begin(FBLocalTransaction.java:94)
at
org.firebirdsql.jdbc.AbstractConnection.ensureInTransaction(AbstractConnection.java:814)
at
org.firebirdsql.jdbc.AbstractStatement.executeUpdate(AbstractStatement.java:195)

Does someone know what this is? And how I can fix this?

Besides that, what is happening with the memory usage? Are there some
settings that I can change that have to do something with this problem?

Thanx in advance,

Alexander