Hello dear firebird experts,

for some days, we had a problem with our firebird-java connection.
Firebird.log and the database-server-Event History does not report any
problems.

But the Java-Application brings the follow error messages:

2010-03-30 23:34:36,984 INFO Insert:168 - insert HALLE: FGNR: 124 Target:
PID: FBID:

2010-03-30 23:34:40,328 ERROR Select:3030 - Fehler bei der Abfrage von
Auftrgasdaten

org.firebirdsql.jdbc.FBSQLException: Result set is already closed.

at
org.firebirdsql.jdbc.FBStatementFetcher.checkClosed(FBStatementFetcher.java:
232)

at
org.firebirdsql.jdbc.FBStatementFetcher.fetch(FBStatementFetcher.java:187)

at org.firebirdsql.jdbc.FBStatementFetcher.next(FBStatementFetcher.java:119)

at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:250)

at com.carnet.DB.LVSDBData.Select.get_Auftragsdaten(Select.java:3021)

at Main.TTaskRBGAA.run(TTaskRBGAA.java:68)

at java.util.TimerThread.mainLoop(Unknown Source)

at java.util.TimerThread.run(Unknown Source)

2010-03-30 23:42:10,796 INFO Insert:168 - insert HALLE: FGNR: 400 Target:
PID: FBID:

2010-03-30 23:42:11,109 ERROR Select:3030 - Fehler bei der Abfrage von
Auftrgasdaten

org.firebirdsql.jdbc.FBSQLException: The resultSet is closed

at
org.firebirdsql.jdbc.AbstractResultSet.getField(AbstractResultSet.java:616)

at
org.firebirdsql.jdbc.AbstractResultSet.getField(AbstractResultSet.java:599)

at
org.firebirdsql.jdbc.AbstractResultSet.getString(AbstractResultSet.java:547)

at com.carnet.DB.LVSDBData.Select.get_Auftragsdaten(Select.java:3025)

at Main.TTaskRBGAA.run(TTaskRBGAA.java:68)

at java.util.TimerThread.mainLoop(Unknown Source)

at java.util.TimerThread.run(Unknown Source)

2010-04-01 01:58:26,671 ERROR Select:920 - SQL-Fehler beim Suchen nach
optimalen Platz aufgetreten:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL
Error

SQL error code = -504

Invalid cursor reference

Cursor is not open

at
org.firebirdsql.jdbc.FBStatementFetcher.fetch(FBStatementFetcher.java:206)

at org.firebirdsql.jdbc.FBStatementFetcher.next(FBStatementFetcher.java:137)

at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:250)

at com.carnet.DB.LVSDBData.Select.selectOptPlace2(Select.java:868)

at Main.LVS.findOptPlace(LVS.java:178)

at Main.LVS.generateFDRBG_RQ(LVS.java:789)

at Main.LVS.einlagernPlatz(LVS.java:1493)

at Main.LVS.analyzeXE(LVS.java:1132)

at ConnectionSPS.SPSrecieve.checkTelegramm(SPSrecieve.java:400)

at ConnectionSPS.SPSrecieve.run(SPSrecieve.java:130)

at java.lang.Thread.run(Unknown Source)

at

org.firebirdsql.gds.GDSException: Dynamic SQL Error

SQL error code = -504

Invalid cursor reference

Cursor is not open

at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJ
avaGDSImpl.java:2124)

at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJa
vaGDSImpl.java:2074)

at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlFetch(AbstractJavaG
DSImpl.java:1333)

at org.firebirdsql.gds.impl.GDSHelper.fetch(GDSHelper.java:264)

at
org.firebirdsql.jdbc.FBStatementFetcher.fetch(FBStatementFetcher.java:201)

at org.firebirdsql.jdbc.FBStatementFetcher.next(FBStatementFetcher.java:137)

at org.firebirdsql.jdbc.AbstractResultSet.next(AbstractResultSet.java:250)

at com.carnet.DB.LVSDBData.Select.selectOptPlace2(Select.java:868)

at Main.LVS.findOptPlace(LVS.java:178)

at Main.LVS.generateFDRBG_RQ(LVS.java:789)

at Main.LVS.einlagernPlatz(LVS.java:1493)

at Main.LVS.analyzeXE(LVS.java:1132)

at ConnectionSPS.SPSrecieve.checkTelegramm(SPSrecieve.java:400)

at ConnectionSPS.SPSrecieve.run(SPSrecieve.java:130)

at java.lang.Thread.run(Unknown Source)



Can you help me please, what was not ok at this time.

After we restart the Application, it works fine again.

We don't have problems with transactions, the gstat-result ist very well.

Thanks for helping.


Best regards

Olaf