I am developing a java application (client-server), that is supposed
to support lots of users (over 100). I am encoutering a problem with
DB2 commit statement.
There is an portion of code on the server side, that needs to be
thread safe. Therefore I've made that method synchronized. Inside that
method, i have to do an "select max(some_id) from .... " and
imediately after i do an "insert some_id+1 ...". I close the
connection (it is obtained through JNDI datasource), and exit the
However, if multiple clients try to access that method at the same
time, they are ...