--- In Firebird-Java@yahoogroups.com, Mark Rotteveel <mark@...> wrote:

>
> On Mon, 13 May 2013 04:54:46 -0000, "psureshkumar14@..."
> <sureshkumar.p@...> wrote:
> > Hi Mark,
> >
> > For the exception "Unable to complete network request to host ""
> ",
> > I got an clue. Whenever an IOException throws in our product
> > server/running environment, this error occurs. If i properly
> handled
> > in my server(tomcat/java program), this issue fixed. what i am
> > telling is, this issue is not happened due to Firebird.
> >
> > Please let me if i am wrong!.
>
> I have no clue how an unrelated IOException elsewhere could cause an
> IOException and thus "Unable to complete network request to host "" " in
> the driver. The only guess is that the IOException causes the termination
> of the thread and the connection is - eventually - returned to a connection
> pool in an inconsistent state. Subsequent use of that connection throws
> this exception.
>
> That is a nice theory, but the connection shouldn't be in an inconsistent
> state if a Jaybird method completed before the IOException occurred in a
> different part of your application.
>
> > Note: Two of customers faced that issue, from analyzing java logs the
> > IOException is throwed in our code(This code is not related to DB Call.
> I
> > am still wondering, how this is possible!!). After handling that
> > IOException, the reported above issue not reproduced in our setup.
> >
> > Trust this helps.
>
> It is good to know, but I am not yet closer to a solution ;)
>
> Could you try to reproduce the issue with Jaybird 2.2.3 and share the
> exception that should now include the IOException stacktrace?
>
> Mark
>

Hi Mark,

Here is the Exception from Jaybird 2.2.3:

See com.borland.dx.dataset.DataSetException error code: BASE+66
com.borland.dx.dataset.DataSetException: GDS Exception. 335544721. Unable to complete network request to host "".
at com.borland.dx.sql.dataset.Database.<unknown>(Unknown Source)
at com.borland.dx.sql.dataset.o.a(Unknown Source)
at com.borland.dx.sql.dataset.o.d(Unknown Source)
at com.borland.dx.sql.dataset.o.f(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.refresh(StorageDataSet.class:0)
at com.borland.dx.sql.dataset.QueryDataSet.refresh(QueryDataSet.class:0)
at web.dxweb.MyQueryDataSet.refresh(MyQueryDataSet.java:79)
at videoport.DebitAction.debit(DebitAction.java:313)
at foodport.PanelRegisterTest.jButtonDebit_actionPerformed(PanelRegisterTest.java:869)
at foodport.PanelRegisterTest_jButtonDebit_actionAdapter.actionPerformed(PanelRegisterTest.java:1905)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.<unknown>(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.<unknown>(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at videoport.MainPort$EventQueueProxy.dispatchEvent(MainPort.java:614)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Chained exception:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544721. Unable to complete network request to host "".
at org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordinator.ensureTransaction(Unknown Source)
at org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordinator.executionStarted(Unknown Source)
at org.firebirdsql.jdbc.InternalTransactionCoordinator.executionStarted(Unknown Source)
at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(Unknown Source)
at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(Unknown Source)
at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(Unknown Source)
at org.firebirdsql.jdbc.FBPreparedStatement.<init>(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.<unknown>(Unknown Source)
at org.firebirdsql.jdbc.FBStatementFactory.createPreparedStatement(Unknown Source)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(Unknown Source)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(Unknown Source)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(Unknown Source)
at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(Unknown Source)
at com.borland.dx.sql.dataset.Database.<unknown>(Unknown Source)
at com.borland.dx.sql.dataset.o.a(Unknown Source)
at com.borland.dx.sql.dataset.o.d(Unknown Source)
at com.borland.dx.sql.dataset.o.f(Unknown Source)
at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
at com.borland.dx.dataset.StorageDataSet.refresh(StorageDataSet.class:0)
at com.borland.dx.sql.dataset.QueryDataSet.refresh(QueryDataSet.class:0)
at web.dxweb.MyQueryDataSet.refresh(MyQueryDataSet.java:79)
at videoport.DebitAction.debit(DebitAction.java:313)
at foodport.PanelRegisterTest.jButtonDebit_actionPerformed(PanelRegisterTest.java:869)
at foodport.PanelRegisterTest_jButtonDebit_actionAdapter.actionPerformed(PanelRegisterTest.java:1905)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.<unknown>(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.<unknown>(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at videoport.MainPort$EventQueueProxy.dispatchEvent(MainPort.java:614)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.firebirdsql.gds.GDSException: Unable to complete network request to host "".
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscStartTransaction(Unknown Source)
at org.firebirdsql.gds.impl.GDSHelper.startTransaction(Unknown Source)
at org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(Unknown Source)
at org.firebirdsql.jca.FBManagedConnection.internalStart(Unknown Source)
at org.firebirdsql.jca.FBLocalTransaction.internalBegin(Unknown Source)
at org.firebirdsql.jca.FBLocalTransaction.begin(Unknown Source)
... 53 more
Caused by: java.net.SocketException: Socket closed
at java.net.SocketOutputStream.socketWrite0(Unknown Source)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at org.firebirdsql.gds.impl.wire.XdrOutputStream.flush(Unknown Source)
... 59 more