db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Craig L Russell <Craig.Russ...@Sun.COM>
Subject Re: Select records that are not locked?
Date Thu, 05 Jan 2006 23:59:07 GMT
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:Craig.Russell@sun.com
P.S. A good JDO? O, Gasp!


Mime
View raw message