Re: Select records that are not locked?

[Craig L Russell]

Hi Danny, On Jan 5, 2006, at 11:14 AM, 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? I hope not. That's not the way I understand databases are supposed to work. The result of a query is not dependent on the state of the internal exclusion mechanisms. Perhaps what you want is "dirty read" (isolation level 0) where the select statement is not blocked by any locks... Craig Danny Gallagher The Gainer Group 6525 The Corners Parkway Suite 215 Norcross Ga, 30092 Craig Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp!

smime.p7s
Description: S/MIME cryptographic signature