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
