Subject JDBC related exceptions with Firebird.
Author kkona06
Hi,

I wrote a simple Java App that connects to the Firebird 1.5 database
using the JayBird JDBC driver and inserts data into two tables.
There is a FK referential Integrity constraint between the two
tables, PK on both and a Unique Index on a col in the child table.I
insert 9 rows into the child table for each row into the parent
table. The Firebird db is on the same machine on which I am running
the App.
When I run the App with the JayBird's autocommit on, I am running
into a (GDS Exception. 335544721. Unable to complete network request
to host ""), after putting about 1638 records into the parent table.

If I turn the auto commit off, I am getting a (GDS Exception.
335544726. Error reading data from the connection.) . I am attaching
the stack traces for both the errors.

Can anybody give me some pointers on what might be happening here? I
am running this App to generate some bench marks for comparing the
Performance metrics for our Application System.

Thanks in advance for any help.

-KKona

Stack traces:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544721.
Unable to complete network request to host "".

Reason: Unable to complete network request to host "".

at
org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordin
ator.ensureTransaction(InternalTransactionCoordinator.java:224)

at
org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordin
ator.executionStarted(InternalTransactionCoordinator.java:213)

at
org.firebirdsql.jdbc.InternalTransactionCoordinator.executionStarted
(InternalTransactionCoordinator.java:38)

at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted
(AbstractStatement.java:220)

at org.firebirdsql.jdbc.AbstractStatement.executeUpdate
(AbstractStatement.java:243)


------------------
Trace 2:
org.firebirdsql.gds.GDSException: Error reading data from the
connection.

at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlAllocateStat
ement(AbstractJavaGDSImpl.java:1022)

at org.firebirdsql.gds.impl.GDSHelper.allocateStatement
(GDSHelper.java:124)

at org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement
(AbstractStatement.java:1100)

at org.firebirdsql.jdbc.AbstractStatement.internalExecute
(AbstractStatement.java:1086)

at org.firebirdsql.jdbc.AbstractStatement.executeUpdate
(AbstractStatement.java:246)