[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - SELECT FOR UPDATE, PostgreSQL vs DB2

[paoletto]

Hi

I have  a method which REQUIRES_NEW transaction, which perform

a SELECT ... FOR UPDATE on one row.

On PostgreSQL everything is fine and the query locks correctly, while if i use DB2 as datasource, it seems
that my select for update doesnt actually lock anything, and if i perform another invocation to this method, or some other selects for update from other consoles, they can succeed...

What's wrong?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4107183#4107183

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4107183