|Subject||Re: [Firebird-Java] "invalid request handle" in FB 2.0 with Java|
> - sometimes a query would not execute because the resultset is alreadyMost likely you use auto-commit mode and database connection is shared
> closed (but it works after going back to the page straight away)
between multiple threads (e.g. one connection per application). The issue is
that JDBC 3.0 specification requires us to close the result set when another
statement is executed on the same connection. The fact that the bug is
intermittent is very likely caused by a race condition between two or more
concurrent page invocations that access the same connection.
Use connection-per-page scenario (e.g. use connection pool, obtain the
connection when request arrives and return it back when response is
> - and most of all, some prepared statements or resultset closing returnRace condition on the Statement object between two or more concurrent page
> the following error:
> org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544327. invalid
> request handle
invocations. One thread has closed the statement and another one tries to do
the same thing (or, do anything else with the statement).