db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Re: AW: locking problem when selecting data
Date Thu, 07 Jun 2007 15:21:15 GMT
Kasper, Kay wrote:
> thanks for your answer. But why is there already a lock on the row. All
> outher statements have been committed or have not selected the row. So there
> should be no other lock.
I suspect that the update statement has left the row locked. In general 
you can't rely on a database locking only the minimum necessary set of 
rows. This is determined by the database implementation and can change 
between releases.

Mark Thornton

View raw message