Has someone looked at this ?
Or is statement pooling no longer supported by Jaybird ?


Carsten

Carsten Schäfer schrieb:

> 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)
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>