Subject Re: [Firebird-Java] severe problems
Author Carsten Schäfer
At the second costumer site i've installed Firebird 1.5.2RC1 and Jaybird 1.5.4.
But now the error happens every day.
It's not reproducable, because everytime it happens in another db-operation, but after that the connection is not usable anymore and the connection pool returns this invalid connection everytime.

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544344. I/O error for file ReadFile "E:\IB_DATENBANK\DBAMS_THT_L.GDB"
Error while trying to read from file
null
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:503)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:144)
at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.PooledPreparedStatementHandler.invoke(PooledPreparedStatementHandler.java:174)
at org.firebirdsql.pool.$Proxy1.executeUpdate(Unknown Source)
at com.TTC_Informatik.PAULA.general.Auftrag.speichern(Auftrag.java:1707)
at com.TTC_Informatik.PAULA.server.App_Server.speichereAuftrag(App_Server.java:8749)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichernSync(App_Server.java:7287)
at com.TTC_Informatik.PAULA.server.App_Server.erzeugeSync(App_Server.java:9441)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichern(App_Server.java:7229)
at sun.reflect.GeneratedMethodAccessor208.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: I/O error for file ReadFile "E:\IB_DATENBANK\DBAMS_THT_L.GDB"
Error while trying to read from file
null
at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1816)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1769)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_execute2(GDS_Impl.java:917)
at org.firebirdsql.jca.FBManagedConnection.executeStatement(FBManagedConnection.java:793)
at org.firebirdsql.jdbc.AbstractConnection.executeStatement(AbstractConnection.java:946)
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:499)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:144)
at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.PooledPreparedStatementHandler.invoke(PooledPreparedStatementHandler.java:174)
at org.firebirdsql.pool.$Proxy1.executeUpdate(Unknown Source)
at com.TTC_Informatik.PAULA.general.Auftrag.speichern(Auftrag.java:1707)
at com.TTC_Informatik.PAULA.server.App_Server.speichereAuftrag(App_Server.java:8749)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichernSync(App_Server.java:7287)
at com.TTC_Informatik.PAULA.server.App_Server.erzeugeSync(App_Server.java:9441)
at com.TTC_Informatik.PAULA.server.App_Server.auftrag_speichern(App_Server.java:7229)
at sun.reflect.GeneratedMethodAccessor208.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

...

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544327. invalid request handle
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:503)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeQuery(AbstractPreparedStatement.java:109)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.PooledPreparedStatementHandler.invoke(PooledPreparedStatementHandler.java:174)
at org.firebirdsql.pool.$Proxy1.executeQuery(Unknown Source)
at com.TTC_Informatik.PAULA.general.Arbeitsplan.getArbeitsplaeneUndErgebnisse(Arbeitsplan.java:1247)
at com.TTC_Informatik.PAULA.server.App_Server.getArbeitsplaeneUndErgebnisse(App_Server.java:8077)
at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at org.firebirdsql.gds.GDSException: invalid request handle
at org.firebirdsql.jdbc.AbstractConnection.executeStatement(AbstractConnection.java:945)
at org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:499)
at org.firebirdsql.jdbc.AbstractPreparedStatement.executeQuery(AbstractPreparedStatement.java:109)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.PooledPreparedStatementHandler.invoke(PooledPreparedStatementHandler.java:174)
at org.firebirdsql.pool.$Proxy1.executeQuery(Unknown Source)
at com.TTC_Informatik.PAULA.general.Arbeitsplan.getArbeitsplaeneUndErgebnisse(Arbeitsplan.java:1247)
at com.TTC_Informatik.PAULA.server.App_Server.getArbeitsplaeneUndErgebnisse(App_Server.java:8077)
at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Carsten



[Non-text portions of this message have been removed]