Cursors removed with commit - Mailing list pgsql-jdbc

From Christophe Canovas
Subject Cursors removed with commit
Date
Msg-id 10564239.43.1408541952917.JavaMail.root@zimbra.cy.cassidian.net
Whole thread Raw
Responses Re: Cursors removed with commit  (Christophe Canovas <cc.ais40@wanadoo.fr>)
List pgsql-jdbc
Hello,

I have a problem with my huge database ; using cursors (so using a transaction with noautocommit, statement with
type_forward_only)make cursors removed if I update and save (commit) database values in the same transaction during the
fetchloop. 

Error message is : portal "C_03" doesn't exist

All is fine if the commit is done in a different transaction.

In more details, in the statement creation :
  con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);
the last parameter seems to have no effect ... ?


Best Regards,
Christophe


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: JDBC build broken by commit 9f9019b
Next
From: Christophe Canovas
Date:
Subject: Re: Cursors removed with commit