db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Select records that are not locked?
Date Fri, 06 Jan 2006 17:38:35 GMT
Derby does not support that.  I have heard it referred to as "read past"
locking.  I don't believe there is any SQL standard or JDBC standard
description of such a mode.

It tends to be useful for queue management applications where the app 
just wants a set of rows to work on and it is ok to skip those that 
someone else is looking at.  Do you know of any DB's that currently
support such a feature?

Danny wrote:
> Is there a way on a select statement to select all rows that match the where
> clause criteria, except for any rows that are locked?
> Danny Gallagher
> The Gainer Group
> 6525 The Corners Parkway
> Suite 215
> Norcross Ga, 30092

View raw message