Skip site navigation (1) Skip section navigation (2)

Commitment control on updateable ResultSet

From: Flavio Palumbo <flavio(dot)palumbo(at)fastwebnet(dot)it>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Commitment control on updateable ResultSet
Date: 2009-01-02 11:47:44
Message-ID: 16566495.2149901230896864322.JavaMail.root@pr004msr (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Hi all,

I try to control the commitment on an updatable ResultSet but I get a strange ex
ception : 
"ERROR: current transaction is aborted, commands ignored until end of transactio
n block"

I do this :
- Connection.setAutoCommit(false);
- Connection.setSavepoint(point);
- Connection.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE, java.sq
- Statetement.executeQuery("SELECT T1.*  FROM  public.teststrike T1 for update")

at this point a I get the above exception.

Can somebody help me to figure out why this happens ?



pgsql-jdbc by date

Next:From: Dave CramerDate: 2009-01-02 12:19:40
Subject: Re: Commitment control on updateable ResultSet
Previous:From: CromaxDate: 2008-12-31 21:56:21
Subject: Re: Support of getting generated keys in driver version 8.4devel

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group