Hi,
we are using connection pooling and statemt pooling. (with
FBWrappingDataSource)
I think there is again a memroy leak with statement pooling that crashes
the whole firebird-server process.
We have a batch Update with many selects, updates and inserts. (about
50 statements, running about 5000 times)
(Similar issue was reported by me in October 2004)
When running it the firebirdserver process' (fbserver.exe) memory
consuption is growing and growing until the server crashes.
With statemet pooling turned off there is no growing memory at all.
(Besides the batch-update i have randomly seen high memory consumption
at some customer sides, but never had any explanation for the problem)

Heres my configuration:
WinXp with Servicepack2, Java 1.4.2_10, tested with Firebird 1.5.3 and
FB2.0RC (both SuperServer), Jaybird 1.5.6 and Jaybird 2.0.1.
This is the log entry from firebird.log:
C:\Programme\Firebird\Firebird_2_0\bin\fbserver.exe: terminated
abnormally (4294967295)
or
C:\Programme\Firebird\Firebird_1_5\bin\fbserver.exe: terminated
abnormally (4294967295)

And this are logs from Jaybird after the crash: (Jaybird 2)
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544485. invalid
statement handle
at
org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:118)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
at
org.firebirdsql.pool.PingablePooledConnection.prepareStatement(PingablePooledConnection.java:399)
at
org.firebirdsql.pool.XPreparedStatementCache.take(XPreparedStatementCache.java:117)
at
org.firebirdsql.pool.PingablePooledConnection.getPreparedStatement(PingablePooledConnection.java:376)
at
org.firebirdsql.pool.PooledConnectionHandler.handlePrepareStatement(PooledConnectionHandler.java:295)
at
org.firebirdsql.pool.PooledConnectionHandler.invoke(PooledConnectionHandler.java:223)
at $Proxy0.prepareStatement(Unknown Source)
at
com.TTC_Informatik.PAULA.general.AbstractPreis.getNeuenNachfolgerAusDB(AbstractPreis.java:2210)
at
com.TTC_Informatik.PAULA.general.AbstractKundePreis.getNeuenNachfolgerAusDB(AbstractKundePreis.java:180)
at
com.TTC_Informatik.PAULA.general.AbstractSeriePreis.getNeuenNachfolgerAusDB(AbstractSeriePreis.java:224)
at
com.TTC_Informatik.PAULA.general.SerieAGPreis.speichern(SerieAGPreis.java:449)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.bearbeiteDatensatz(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:180)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.runUpdate(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:58)
at com.TTC_Informatik.PAULA.db.DBUpdate.<init>(DBUpdate.java:36)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.<init>(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at
com.TTC_Informatik.PAULA.server.App_Server.init_main_finished(App_Server.java:9742)
at
com.TTC_Informatik.PAULA.server.App_Server.access$700(App_Server.java:226)
at
com.TTC_Informatik.PAULA.server.App_Server$6.finished(App_Server.java:9867)
at
com.TTC_Informatik.PAULA.Tools.SwingWorker$1.run(SwingWorker.java:103)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
at org.firebirdsql.gds.GDSException: invalid statement handle
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2104)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2054)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlPrepare(AbstractJavaGDSImpl.java:1478)
at
org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:194)
at
org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1107)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:1145)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:116)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
at
org.firebirdsql.pool.PingablePooledConnection.prepareStatement(PingablePooledConnection.java:399)
at
org.firebirdsql.pool.XPreparedStatementCache.take(XPreparedStatementCache.java:117)
at
org.firebirdsql.pool.PingablePooledConnection.getPreparedStatement(PingablePooledConnection.java:376)
at
org.firebirdsql.pool.PooledConnectionHandler.handlePrepareStatement(PooledConnectionHandler.java:295)
at
org.firebirdsql.pool.PooledConnectionHandler.invoke(PooledConnectionHandler.java:223)
at $Proxy0.prepareStatement(Unknown Source)
at
com.TTC_Informatik.PAULA.general.AbstractPreis.getNeuenNachfolgerAusDB(AbstractPreis.java:2210)
at
com.TTC_Informatik.PAULA.general.AbstractKundePreis.getNeuenNachfolgerAusDB(AbstractKundePreis.java:180)
at
com.TTC_Informatik.PAULA.general.AbstractSeriePreis.getNeuenNachfolgerAusDB(AbstractSeriePreis.java:224)
at
com.TTC_Informatik.PAULA.general.SerieAGPreis.speichern(SerieAGPreis.java:449)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.bearbeiteDatensatz(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:180)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.runUpdate(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:58)
at com.TTC_Informatik.PAULA.db.DBUpdate.<init>(DBUpdate.java:36)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.<init>(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at
com.TTC_Informatik.PAULA.server.App_Server.init_main_finished(App_Server.java:9742)
at
com.TTC_Informatik.PAULA.server.App_Server.access$700(App_Server.java:226)
at
com.TTC_Informatik.PAULA.server.App_Server$6.finished(App_Server.java:9867)
at
com.TTC_Informatik.PAULA.Tools.SwingWorker$1.run(SwingWorker.java:103)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544332. invalid
transaction handle (expecting explicit transaction start)
at
org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:210)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.firebirdsql.pool.StatementHandler.invoke(StatementHandler.java:105)
at $Proxy3.executeQuery(Unknown Source)
at com.TTC_Informatik.PAULA.general.Auftrag.speichern(Auftrag.java:1756)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.bearbeiteDatensatz(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:115)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.runUpdate(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:58)
at com.TTC_Informatik.PAULA.db.DBUpdate.<init>(DBUpdate.java:36)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.<init>(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at
com.TTC_Informatik.PAULA.server.App_Server.init_main_finished(App_Server.java:9742)
at
com.TTC_Informatik.PAULA.server.App_Server.access$700(App_Server.java:226)
at
com.TTC_Informatik.PAULA.server.App_Server$6.finished(App_Server.java:9867)
at
com.TTC_Informatik.PAULA.Tools.SwingWorker$1.run(SwingWorker.java:103)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
at org.firebirdsql.gds.GDSException: invalid transaction handle
(expecting explicit transaction start)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2104)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2054)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlPrepare(AbstractJavaGDSImpl.java:1478)
at
org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:194)
at
org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1107)
at
org.firebirdsql.jdbc.AbstractStatement.internalExecute(AbstractStatement.java:1086)
at
org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:201)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.firebirdsql.pool.StatementHandler.invoke(StatementHandler.java:105)
at $Proxy3.executeQuery(Unknown Source)
at com.TTC_Informatik.PAULA.general.Auftrag.speichern(Auftrag.java:1756)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.bearbeiteDatensatz(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:115)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.runUpdate(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:58)
at com.TTC_Informatik.PAULA.db.DBUpdate.<init>(DBUpdate.java:36)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.<init>(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at
com.TTC_Informatik.PAULA.server.App_Server.init_main_finished(App_Server.java:9742)
at
com.TTC_Informatik.PAULA.server.App_Server.access$700(App_Server.java:226)
at
com.TTC_Informatik.PAULA.server.App_Server$6.finished(App_Server.java:9867)
at
com.TTC_Informatik.PAULA.Tools.SwingWorker$1.run(SwingWorker.java:103)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

This is from Jaybird 1.5.6:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544327. invalid
request handle
at
org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:118)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
at
org.firebirdsql.pool.PingablePooledConnection.prepareStatement(PingablePooledConnection.java:399)
at
org.firebirdsql.pool.XPreparedStatementCache.take(XPreparedStatementCache.java:117)
at
org.firebirdsql.pool.PingablePooledConnection.getPreparedStatement(PingablePooledConnection.java:376)
at
org.firebirdsql.pool.PooledConnectionHandler.handlePrepareStatement(PooledConnectionHandler.java:295)
at
org.firebirdsql.pool.PooledConnectionHandler.invoke(PooledConnectionHandler.java:223)
at $Proxy0.prepareStatement(Unknown Source)
at
com.TTC_Informatik.PAULA.general.AbstractPreis.getNeuenVorgaengerAusDB(AbstractPreis.java:2350)
at
com.TTC_Informatik.PAULA.general.AbstractKundePreis.getNeuenVorgaengerAusDB(AbstractKundePreis.java:200)
at
com.TTC_Informatik.PAULA.general.AbstractWerkstoffPreis.getNeuenVorgaengerAusDB(AbstractWerkstoffPreis.java:230)
at com.TTC_Informatik.PAULA.general.Preis.ersetzen(Preis.java:265)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.bearbeiteDatensatz(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:192)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.runUpdate(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:58)
at com.TTC_Informatik.PAULA.db.DBUpdate.<init>(DBUpdate.java:36)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.<init>(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at
com.TTC_Informatik.PAULA.server.App_Server.init_main_finished(App_Server.java:9742)
at
com.TTC_Informatik.PAULA.server.App_Server.access$13(App_Server.java:9735)
at
com.TTC_Informatik.PAULA.server.App_Server$6.finished(App_Server.java:9867)
at
com.TTC_Informatik.PAULA.Tools.SwingWorker$1.run(SwingWorker.java:103)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
at org.firebirdsql.gds.GDSException: invalid request handle
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2104)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2054)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlPrepare(AbstractJavaGDSImpl.java:1478)
at
org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:194)
at
org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1107)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:1145)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:116)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:40)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:849)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:812)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:805)
at
org.firebirdsql.pool.PingablePooledConnection.prepareStatement(PingablePooledConnection.java:399)
at
org.firebirdsql.pool.XPreparedStatementCache.take(XPreparedStatementCache.java:117)
at
org.firebirdsql.pool.PingablePooledConnection.getPreparedStatement(PingablePooledConnection.java:376)
at
org.firebirdsql.pool.PooledConnectionHandler.handlePrepareStatement(PooledConnectionHandler.java:295)
at
org.firebirdsql.pool.PooledConnectionHandler.invoke(PooledConnectionHandler.java:223)
at $Proxy0.prepareStatement(Unknown Source)
at
com.TTC_Informatik.PAULA.general.AbstractPreis.getNeuenVorgaengerAusDB(AbstractPreis.java:2350)
at
com.TTC_Informatik.PAULA.general.AbstractKundePreis.getNeuenVorgaengerAusDB(AbstractKundePreis.java:200)
at
com.TTC_Informatik.PAULA.general.AbstractWerkstoffPreis.getNeuenVorgaengerAusDB(AbstractWerkstoffPreis.java:230)
at com.TTC_Informatik.PAULA.general.Preis.ersetzen(Preis.java:265)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.bearbeiteDatensatz(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:192)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.runUpdate(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:58)
at com.TTC_Informatik.PAULA.db.DBUpdate.<init>(DBUpdate.java:36)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.<init>(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at
com.TTC_Informatik.PAULA.server.App_Server.init_main_finished(App_Server.java:9742)
at
com.TTC_Informatik.PAULA.server.App_Server.access$13(App_Server.java:9735)
at
com.TTC_Informatik.PAULA.server.App_Server$6.finished(App_Server.java:9867)
at
com.TTC_Informatik.PAULA.Tools.SwingWorker$1.run(SwingWorker.java:103)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544726. Error
reading data from the connection.
null
Reason: Error reading data from the connection.
null
at
org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.commit(InternalTransactionCoordinator.java:324)
at
org.firebirdsql.jdbc.InternalTransactionCoordinator.commit(InternalTransactionCoordinator.java:80)
at
org.firebirdsql.jdbc.AbstractConnection.commit(AbstractConnection.java:433)
at
org.firebirdsql.pool.PooledConnectionHandler.handleConnectionCommit(PooledConnectionHandler.java:398)
at
org.firebirdsql.pool.PooledConnectionHandler.invoke(PooledConnectionHandler.java:250)
at $Proxy0.commit(Unknown Source)
at com.TTC_Informatik.PAULA.general.Auftrag.speichern(Auftrag.java:1918)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.bearbeiteDatensatz(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:131)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.runUpdate(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:58)
at com.TTC_Informatik.PAULA.db.DBUpdate.<init>(DBUpdate.java:36)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.<init>(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at
com.TTC_Informatik.PAULA.server.App_Server.init_main_finished(App_Server.java:9742)
at
com.TTC_Informatik.PAULA.server.App_Server.access$13(App_Server.java:9735)
at
com.TTC_Informatik.PAULA.server.App_Server$6.finished(App_Server.java:9867)
at
com.TTC_Informatik.PAULA.Tools.SwingWorker$1.run(SwingWorker.java:103)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
at org.firebirdsql.gds.GDSException: Error reading data from the connection.
null
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2070)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscCommitTransaction(AbstractJavaGDSImpl.java:788)
at
org.firebirdsql.jca.FBManagedConnection.internalCommit(FBManagedConnection.java:602)
at
org.firebirdsql.jca.FBLocalTransaction.internalCommit(FBLocalTransaction.java:193)
at
org.firebirdsql.jca.FBLocalTransaction.commit(FBLocalTransaction.java:167)
at
org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.commit(InternalTransactionCoordinator.java:322)
at
org.firebirdsql.jdbc.InternalTransactionCoordinator.commit(InternalTransactionCoordinator.java:80)
at
org.firebirdsql.jdbc.AbstractConnection.commit(AbstractConnection.java:433)
at
org.firebirdsql.pool.PooledConnectionHandler.handleConnectionCommit(PooledConnectionHandler.java:398)
at
org.firebirdsql.pool.PooledConnectionHandler.invoke(PooledConnectionHandler.java:250)
at $Proxy0.commit(Unknown Source)
at com.TTC_Informatik.PAULA.general.Auftrag.speichern(Auftrag.java:1918)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.bearbeiteDatensatz(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:131)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.runUpdate(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:58)
at com.TTC_Informatik.PAULA.db.DBUpdate.<init>(DBUpdate.java:36)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.<init>(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at
com.TTC_Informatik.PAULA.server.App_Server.init_main_finished(App_Server.java:9742)
at
com.TTC_Informatik.PAULA.server.App_Server.access$13(App_Server.java:9735)
at
com.TTC_Informatik.PAULA.server.App_Server$6.finished(App_Server.java:9867)
at
com.TTC_Informatik.PAULA.Tools.SwingWorker$1.run(SwingWorker.java:103)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
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$LocalTransactionCoordinator.ensureTransaction(InternalTransactionCoordinator.java:313)
at
org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:342)
at
org.firebirdsql.jdbc.InternalTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:38)
at
org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:220)
at
org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:198)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.firebirdsql.pool.StatementHandler.invoke(StatementHandler.java:105)
at $Proxy1.executeQuery(Unknown Source)
at com.TTC_Informatik.PAULA.general.Auftrag.speichern(Auftrag.java:1756)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.bearbeiteDatensatz(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:131)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.runUpdate(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:58)
at com.TTC_Informatik.PAULA.db.DBUpdate.<init>(DBUpdate.java:36)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.<init>(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at
com.TTC_Informatik.PAULA.server.App_Server.init_main_finished(App_Server.java:9742)
at
com.TTC_Informatik.PAULA.server.App_Server.access$13(App_Server.java:9735)
at
com.TTC_Informatik.PAULA.server.App_Server$6.finished(App_Server.java:9867)
at
com.TTC_Informatik.PAULA.Tools.SwingWorker$1.run(SwingWorker.java:103)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
at org.firebirdsql.gds.GDSException: Unable to complete network request
to host "".
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscStartTransaction(AbstractJavaGDSImpl.java:700)
at
org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(FBManagedConnection.java:1076)
at
org.firebirdsql.jca.FBManagedConnection.internalStart(FBManagedConnection.java:995)
at
org.firebirdsql.jca.FBLocalTransaction.internalBegin(FBLocalTransaction.java:140)
at
org.firebirdsql.jca.FBLocalTransaction.begin(FBLocalTransaction.java:112)
at
org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.ensureTransaction(InternalTransactionCoordinator.java:311)
at
org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:342)
at
org.firebirdsql.jdbc.InternalTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:38)
at
org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:220)
at
org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:198)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.firebirdsql.pool.StatementHandler.invoke(StatementHandler.java:105)
at $Proxy1.executeQuery(Unknown Source)
at com.TTC_Informatik.PAULA.general.Auftrag.speichern(Auftrag.java:1756)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.bearbeiteDatensatz(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:131)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.runUpdate(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:58)
at com.TTC_Informatik.PAULA.db.DBUpdate.<init>(DBUpdate.java:36)
at
com.TTC_Informatik.PAULA.db.DBUpdateAuftraegeUndSerienAusArbeitsplaenen.<init>(DBUpdateAuftraegeUndSerienAusArbeitsplaenen.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:308)
at java.lang.Class.newInstance(Class.java:261)
at
com.TTC_Informatik.PAULA.server.App_Server.init_main_finished(App_Server.java:9742)
at
com.TTC_Informatik.PAULA.server.App_Server.access$13(App_Server.java:9735)
at
com.TTC_Informatik.PAULA.server.App_Server$6.finished(App_Server.java:9867)
at
com.TTC_Informatik.PAULA.Tools.SwingWorker$1.run(SwingWorker.java:103)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:178)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:454)
at
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)