db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michelle Caisse <Michelle.Cai...@Sun.COM>
Subject Re: updatable ResultSet: inserted row "may" become visible?
Date Wed, 24 Oct 2007 23:56:11 GMT
Thank you for the responses. No guarantees is clearly the answer.

-- Michelle

Jørgen Løland wrote:

> 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.

View raw message