Problem with Transaction of 100.000 queries

[jlmartinez]

We sent 100.000 queries (updates and inserts). In the query 99.708 the server report the next exception:

disconnect(ManagedConnection mc: null, Object c: org.jboss.resource.adapter.jdbc.local.LocalConnection@91f022) called with unknown managed connection; nested exception is:
java.lang.IllegalArgumentException: disconnect(ManagedConnection mc: null, Object c: org.jboss.resource.adapter.jdbc.local.LocalConnection@91f022) called with unknown managed connection.

We tested :
jboss-3.0.1 + Jdk1.4/Jdk1.3 + postgres 7.2+ winNT/Linux RedHat 7.2.

We don't know what to do?, we have been having that problem for 5 months

Some idea?

[davidjencks]

Can you come up with a simple test case, preferably a junit test? I haven't seen this problem, but I also haven't run any tests this large.

Are you closing the connections before the method returns or holding connections across method calls?

[jlmartinez]

We are testing our application with JUnit.

For this requirement we are using a Session Bean.
The service iterate over a collection of queries and send
the statements to the DB.

*****
. . .
for (int i = 0; i < listaQueries.size(); i++) {
try {
int result = statement.executeUpdate((String) listaQueries.elementAt(i));
ejecutado = true;
} catch (Exception e) {
e.printStackTrace();
ejecutado = false;
}

}
try {
connection.close();
} catch (Exception e) {
e.printStackTrace();
ejecutado = false;
}
***********

Thank you for your possible help