db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jørgen Løland <Jorgen.Lol...@Sun.COM>
Subject Re: updatable ResultSet: inserted row "may" become visible?
Date Wed, 24 Oct 2007 06:17:34 GMT
Michelle Caisse wrote:
> The Derby Developer's Guide states:
> 
>    Rows inserted to the table may become visible in the result set. (p. 57)
> 
>    If the inserted row satisfies the query predicate, it may become
>    visible in the result set. (p. 58)
> 
> What does "may" mean? Are there no circumstances in which the insert is 
> guaranteed to become visible in the result set?
> 
> -- Michelle
> 

This looks similar to a discussion on derby-dev for update operations 
and open cursors a few months back:
 
http://www.nabble.com/Updating-rows-with-an-open-cursor...what-is-the-expected-behavior--t3908926.html#a11083342

In that discussion, it became clear that the cursor would return rows 
that satisfied the query at the time the row was retrieved. That could 
be any point in time between the cursor creation and when the cursor 
reached that record in the result set. Hence, updates *may* be visible 
to open cursors, but with no guarantees.

-- 
Jørgen Løland

Mime
View raw message