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! Army
