>how did you told the cause of the error is IOException?

Thanks for your explanation Mark. I also check the your code by Yesterday, i already got that after sending reply to you.

> If you can provide code that reproduces the error easily, that would be very helpful in finding the cause.

This error is occurred in our customer environment. I am unable to reproduce the issue in our test setup and also we didn't face the same problem from other customers. Seems this may be environmental issue.

Okay! i will prepare a setup like our customer setup and i will let you know whether the issue is reproduced or not.

From Many documents in internet links and in your forums, i see that it happens due to Antivirus/firewall. I don't know about hugo's case whether he using any Antivirus/firewall. Our Customer using Sophos Anti virus. But he excluded entire server folder from AV.

> Connection properties.

drivername=org.firebirdsql.jdbc.FBDriver
username=sysdba
password masterkey
url=jdbc:firebirdsql:localhost/33105:${product.home}/firebird/productDB.fdb?encoding=UTF8
# transaction Isolation level
transaction_isolation=TRANSACTION_READ_COMMITTED

> Usage (eg nr of concurrent connections in use etc)

# Minumum Connection pool size
minsize=1
# Maximum Connection pool size
maxsize=20

> Any errors in the firebird.log of the server around the time this exception occurs

Firebird always fills with the error.

SURESH-0616 (Server) Thu Mar 28 09:47:55 2013
INET/inet_error: read errno = 10054


SURESH-0616 (Server) Thu Mar 28 09:48:00 2013
INET/inet_error: read errno = 10054

> Frequency this error occurs

Other Stack Trace:
[08:44:31:319]|[03-27-2013]|[org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/].[action]]|[SEVERE]|[18]: Servlet.service() for servlet action threw exception|
java.sql.SQLException: GDS Exception. 335544721. Unable to complete network request to host "".
Reason: Unable to complete network request to host "".
at com.adventnet.db.adapter.Jdbc20DBAdapter.handleSQLException(Jdbc20DBAdapter.java:1138)
at com.adventnet.db.adapter.Jdbc20DBAdapter.executeQuery(Jdbc20DBAdapter.java:272)
at com.adventnet.db.api.RelationalAPI.executeQuery(RelationalAPI.java:858)
at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:89)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1377)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1367)
at com.adventnet.persistence.interceptor.CorePersistenceInterceptor.process(CorePersistenceInterceptor.java:97)
at com.adventnet.persistence.interceptor.CacheInterceptor.process(CacheInterceptor.java:76)
at com.adventnet.authorization.interceptor.AuthorizationInterceptor.process(AuthorizationInterceptor.java:65)
at com.adventnet.persistence.ReadOnlyPersistenceBean.get(ReadOnlyPersistenceBean.java:78)
at sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.mfw.bean.BeanProxy.invoke(BeanProxy.java:134)
at $Proxy1.get(Unknown Source)
at com.adventnet.netutils.fw.util.CommonUtil.getStaticPropertyData(CommonUtil.java:2508)
at com.adventnet.netutils.fw.util.CommonUtil.getEncryptedStaticProperty(CommonUtil.java:2530)
at com.adventnet.netutils.fw.LicenseCheck.setRestrictedToolProperty(LicenseCheck.java:243)
at com.adventnet.netutils.fw.NetUtilsCommonAction.execute(NetUtilsCommonAction.java:144)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.adventnet.netutils.fw.i18n.EncodingFilter.doFilter(EncodingFilter.java:72)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.adventnet.netutils.fw.xss.XSSFilter.doFilter(XSSFilter.java:149)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.adventnet.netutils.fw.OpUtilsFilter.redirectForHttps(OpUtilsFilter.java:78)
at com.adventnet.netutils.fw.OpUtilsFilter.doFilter(OpUtilsFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.adventnet.authentication.filter.AssociateCredential.doFilter(AssociateCredential.java:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:421)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at com.adventnet.netutils.fw.plugin.OpUtilsPluginValve.invoke(OpUtilsPluginValve.java:71)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)

Jdbc20DBAdapter Source:
public ResultSetAdapter executeQuery(PreparedStatement pstmt) throws SQLException
{
try{
ResultSet rs = pstmt.executeQuery(); // line 272
return getResultSetAdapter(rs);
}
catch(SQLException sqle){
throw handleSQLException(sqle);
}
}

And I also face the error:
getMaxId() : Exception : |
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$AutoCommitCoordinator.ensureTransaction(InternalTransactionCoordinator.java:224)
at org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordinator.executionStarted(InternalTransactionCoordinator.java:213)

In Above code getMaxId() is execute a query, and returns a number(Integer)

One More Trace:
[10:23:01:208]|[03-21-2013]|[org.apache.catalina.authenticator.CustomFormAuthenticator]|[WARNING]|[454]: Unexpected error forwarding to login page|
java.lang.ArrayIndexOutOfBoundsException
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at org.firebirdsql.gds.impl.wire.XdrOutputStream.checkBufferSize(XdrOutputStream.java:406)
at org.firebirdsql.gds.impl.wire.XdrOutputStream.writeInt(XdrOutputStream.java:309)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscStartTransaction(AbstractJavaGDSImpl.java:725)
at org.firebirdsql.gds.impl.GDSHelper.startTransaction(GDSHelper.java:583)
at org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(FBManagedConnection.java:1006)
at org.firebirdsql.jca.FBManagedConnection.internalStart(FBManagedConnection.java:925)
at org.firebirdsql.jca.FBLocalTransaction.internalBegin(FBLocalTransaction.java:140)
at org.firebirdsql.jca.FBLocalTransaction.begin(FBLocalTransaction.java:112)
at org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordinator.ensureTransaction(InternalTransactionCoordinator.java:222)
at org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordinator.executionStarted(InternalTransactionCoordinator.java:213)
at org.firebirdsql.jdbc.InternalTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:38)
at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:235)
at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:226)
at org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:208)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:250)
at com.adventnet.db.adapter.Jdbc20DBAdapter.executeQuery(Jdbc20DBAdapter.java:264)
at com.adventnet.db.api.RelationalAPI.executeQuery(RelationalAPI.java:858)
at com.adventnet.persistence.internal.GetUtil.get(GetUtil.java:89)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1377)
at com.adventnet.persistence.DataAccess.get(DataAccess.java:1367)
at com.adventnet.netutils.ipam.ADUtil.getADDomainDO(ADUtil.java:577)
at com.adventnet.netutils.ipam.ADUtil.getADDomainDO(ADUtil.java:552)
at org.apache.jsp.framework.OpUtilsLogin_jsp._jspService(OpUtilsLogin_jsp.java:217)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at org.apache.catalina.authenticator.CustomFormAuthenticator.authenticate(CustomFormAuthenticator.java:297)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:528)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:394)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at com.adventnet.netutils.fw.plugin.OpUtilsPluginValve.invoke(OpUtilsPluginValve.java:71)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)

Like the above traces, in so many place it throws the error. But in most place it throws the error,

Is any fix available for this java.lang.ArrayIndexOutOfBoundsException??

In Some places:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544721. Unable to complete network request to host "".
Reason: Unable to complete network request to host "".|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.ensureTransaction(InternalTransactionCoordinator.java:313)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:342)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.InternalTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:38)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:235)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:226)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:121)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:41)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at java.lang.reflect.Constructor.newInstance(Unknown Source)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.FBStatementFactory.createPreparedStatement(FBStatementFactory.java:90)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:869)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:824)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:817)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:293)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:383)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:217)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.persistence.DataAccess.processUpdateRows(DataAccess.java:449)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.persistence.DataAccess.update(DataAccess.java:700)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.persistence.DataAccess.update(DataAccess.java:668)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.mfw.Server.updateStatus(Server.java:641)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.mfw.Server.shutDown(Server.java:690)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.mfw.Starter$1.run(Starter.java:527)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at |
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: org.firebirdsql.gds.GDSException: Unable to complete network request to host "".|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscStartTransaction(AbstractJavaGDSImpl.java:737)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.gds.impl.GDSHelper.startTransaction(GDSHelper.java:583)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(FBManagedConnection.java:1006)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jca.FBManagedConnection.internalStart(FBManagedConnection.java:925)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jca.FBLocalTransaction.internalBegin(FBLocalTransaction.java:140)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jca.FBLocalTransaction.begin(FBLocalTransaction.java:112)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.ensureTransaction(InternalTransactionCoordinator.java:311)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:342)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.InternalTransactionCoordinator.executionStarted(InternalTransactionCoordinator.java:38)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:235)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractStatement.notifyStatementStarted(AbstractStatement.java:226)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:121)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:41)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at java.lang.reflect.Constructor.newInstance(Unknown Source)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.FBStatementFactory.createPreparedStatement(FBStatementFactory.java:90)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:869)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:824)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:817)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:293)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:383)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:217)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.persistence.DataAccess.processUpdateRows(DataAccess.java:449)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.persistence.DataAccess.update(DataAccess.java:700)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.persistence.DataAccess.update(DataAccess.java:668)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.mfw.Server.updateStatus(Server.java:641)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.mfw.Server.shutDown(Server.java:690)|
[11:24:53:360]|[03-18-2013]|[SYSOUT]|[INFO]|[229]: at com.adventnet.mfw.Starter$1.run(Starter.java:527)|

If you need any things else then let me know.

--- In Firebird-Java@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>
> On 27-3-2013 10:46, psureshkumar14@... wrote:
> > First of all thanks for your reply Mark and all others. It is much Appreciated.
> >
> >>> The cause of the error is an IOException, but the exact cause is an
> > unknown right now.
> >
> > Could you please explain(It will really help me to find the root cause), how did you told the cause of the error is IOException. Do you have any documents/forum links?
>
> All place in the Jaybird code where the exception with this message (aka
> error isc_network_error / 335544721) is thrown, is in a catch-block that
> catches an IOException.
>
> For example the error in your stacktrace originates from:
> org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscStartTransaction(AbstractJavaGDSImpl.java:737)
>
> For Jaybird 2.1.6 this is:
> // Next line 722:
> try {
> if (debug)
> log.debug("op_transaction ");
> db.out.writeInt(op_transaction);
> db.out.writeInt(db.getRdb_id());
>
> db.out.writeTyped(ISCConstants.isc_tpb_version3, tpbImpl);
> // db.out.writeSet(ISCConstants.isc_tpb_version3, tpb);
> // db.out.writeBuffer(tpb, tpb_length);
> db.out.flush();
> if (debug)
> log.debug("sent");
> // out.flush();
> receiveResponse(db, -1);
> } catch (IOException ex) {
> throw new GDSException(ISCConstants.isc_network_error);
> }
> // Previous line 738
>
> The statement new GDSException(ISCConstants.isc_network_error) creates
> an exception with the message "Unable to complete network request to
> host ""."
>
> In other cases I would suggest to switch to Jaybird 2.2.2 and see if
> that fixes it, but Hugo has the same exception and he has already
> switched to 2.2.2.
>
> >>> Jaybird 2.2.3 will include the exception cause when
> > this error occurs.
> >
> > Does Jaybird 2.2.3 had any fixes to this issue?
>
> I don't expect Jaybird 2.2.3 to fix this. The only thing I did was
> adding the IOException to the stacktrace. I hope this will allow me to
> pinpoint the problem. I did fix a synchronization bug that might be a
> cause when interleaving requests to the connection from multiple threads
> at the same time. But that won't apply here as you aren't sharing a
> connection with multiple threads.
>
> > Do you have any workaround for this issue? since i tried my best. Nothing Helps.
>
> I don't have a workaround as I don't know what is causing it. If you can
> provide code that reproduces the error easily, that would be very
> helpful in finding the cause.
>
> If that isn't possible, at least provide some details:
> * Connection properties
> * What the code that triggers this exception does (or the actual code)
> * Frequency this error occurs
> * Usage (eg nr of concurrent connections in use etc)
> * Any errors in the firebird.log of the server around the time this
> exception occurs
>
> I do notice that in your trace, the error is triggered from
> org.firebirdsql.jdbc.InternalTransactionCoordinator$LocalTransactionCoordinator.ensureTransaction
> And in Hugo's:
> org.firebirdsql.jdbc.InternalTransactionCoordinator$AutoCommitCoordinator.ensureTransaction
>
> I will look into that part of the code to see if I can find any
> potential causes, but without a - preferably simple - reproducible
> example that is like trying to find a needle in a haystack. And if I
> find something suspicious and fix that I won't be able to verify that it
> actually fixes this issue as long as I can't reproduce it.
>
> Mark
> --
> Mark Rotteveel
>