DatabaseMetada.supportOpenCursorsAcrossCommit() return wrong information.

From: "Dario V(dot) Fassi" <software(at)sistemat(dot)com(dot)ar>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: DatabaseMetada.supportOpenCursorsAcrossCommit() return wrong information.
Date: 2004-07-18 00:25:24
Message-ID: 40F9C374.1040106@sistemat.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I believe that this methods return wrong information.:

DatabaseMetada.supportOpenCursorsAcrossCommit() return false /
would return TRUE
DatabaseMetada.supportOpenCursorsAcrossRollBack() return false /
would return TRUE

Code like this was user to say that.

rs = executeQuery( ... );
while ( rs.next() ) {
con.rollback();
con.commit();
System.err.println( n++ ) ;
}

Count all the rows in the result set.

Dario.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-07-18 01:21:40 Re: DatabaseMetada.supportOpenCursorsAcrossCommit() return
Previous Message Dario V. Fassi 2004-07-17 23:31:23 Re: revisiting transaction isolation