db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Army <qoz...@gmail.com>
Subject Re: Updating rows with an open cursor...what is the expected behavior?
Date Wed, 13 Jun 2007 15:41:26 GMT
Jørgen Løland wrote:

> I discussed this with Bernt just now, and found the following in the 
> JDBC 4 spec to be of interest as well:

[ snip JDBC 4 quotes ]

> It looks like the default behavior (TYPE_FORWARD_ONLY) is more or less 
> the same as SQL ASENSITIVE. "That is, it contains the rows that satisfy 
> the query ... as the rows are retrieved" should allow different results 
> when index and scan are used.

Thank you *very* much for investigating this, Jørgen!  Both of your emails were 
very helpful--and ultimately provided exactly the info that I was looking for.

Many many thanks!

View raw message