db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: Row level locking
Date Fri, 18 May 2007 14:57:34 GMT
Umakanth Srinivasan wrote:
> No Iam not performing anything with respect to AutoCommit. I observed that
> this problem is related to the isolation level. In MySQL the problem did not
> occur. When I checked the default isolation level of MySQL it is
> REPEATABLE_READ, in Derby it is READ_COMMITED. 
>
> Hope I must have the AUTOCOMMIT set to on.
>   
My only point is that locks are released at commit or rollback and with 
AUTOCOMMIT ON a commit is issued at the end of the execution of a 
statement.  Thus I find using SELECT ... FOR UPDATE ... most effective 
with AUTOCOMMIT OFF.


Mime
View raw message