Postgres Pro
Downloads
Home   >   mailing lists

Thread: SENSITIVE resultset

SENSITIVE resultset

From
"Stefano B."
Date:
Hi,
 
I'm trying to use TYPE_SCROLL_SENSITIVE, CONCUR_UPDATABLE cursors but
it seems that I can't see the result set changes made by others.
 
Is it possible use sensitive cursor with the JDBC postgresql driver?
 
thanks in advance.
Stefano
 

Re: SENSITIVE resultset

From
Dave Cramer
Date:
Stefano,

This is pretty orthogonal to the postgresql MVCC model. Postgresql cursors are not CONCUR_UPDATEABLE by their nature. The driver would have to do quite a bit of work to make this happen for you transparently.

Dave
On 9-Oct-06, at 4:53 AM, Stefano B. wrote:

Hi,
 
I'm trying to use TYPE_SCROLL_SENSITIVE, CONCUR_UPDATABLE cursors but
it seems that I can't see the result set changes made by others.
 
Is it possible use sensitive cursor with the JDBC postgresql driver?
 
thanks in advance.
Stefano