-
1. Re: Problem with Transaction of 100.000 queries
davidjencks Aug 14, 2002 3:57 PM (in response to jlmartinez)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? -
2. Re: Problem with Transaction of 100.000 queries
jlmartinez Aug 14, 2002 4:52 PM (in response to 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