Subject Re: [Firebird-Java] reuse of connection after failure.
Author Roman Rokytskyy
> I am currently forcing a fatal error in FBManagedConnection.start() when it cannot start a transaction to try and force jboss to discard the connection. I will run this tonight and see if it helps. I guess that Jboss's transaction manager should discard a connection it cannot create a transaction on, But I am hoping that the XA_UNKNOWN(0) error code may be confusing it.

I think this is ok for now, but I will check whether better solution is
possible.

> I also noticed that are a number of places in with managed connections where we throw isc_network errors which are now fatal but because the function is called via the Managed connection rather then GDSHelper we do not notify anyone that the connection is potentially dead. I am wondering if this is likely to be a problem. Specifically in areas where we try and recover transaction. In this area we are using GDS_java_impl directly.

This is bad. I will review such places, and use some different error
code in this case.

Thanks!
Roman