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

R: Re: Commitment control on updateable ResultSet

From: Flavio Palumbo <flavio(dot)palumbo(at)fastwebnet(dot)it>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: R: Re: Commitment control on updateable ResultSet
Date: 2009-01-02 13:15:58
Message-ID: 8006633.2153931230902158269.JavaMail.root@pr004msr (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi Dave,

thanks for your replay, I followed in debug mode my program and I've seen that the executeQuery method raised the exception.

It appears as if commitment control cannot be applied to an updateable ResultSet ; I cannot understand, what's wrong ?

Thanks
Flavio






----Messaggio originale----

Da: pg(at)fastcrypt(dot)com

Data: 02/01/2009 13.19

A: "Flavio Palumbo"<flavio(dot)palumbo(at)fastwebnet(dot)it>

Cc: <pgsql-jdbc(at)postgresql(dot)org>

Ogg: Re: [JDBC] Commitment control on updateable ResultSet



One of the statements between setAutoCommit(false) and execute query is generating an error.

Dave

On Fri, Jan 2, 2009 at 6:47 AM, Flavio Palumbo <flavio(dot)palumbo(at)fastwebnet(dot)it> wrote:

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

l.ResultSet.CONCUR_UPDATABLE);

- 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 ?



Thanks

Flavio





--

Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)

To make changes to your subscription:

http://www.postgresql.org/mailpref/pgsql-jdbc







pgsql-jdbc by date

Next:From: Flavio PalumboDate: 2009-01-02 13:59:35
Subject: R: Re: R: Re: Commitment control on updateable ResultSet
Previous:From: Dave CramerDate: 2009-01-02 12:19:40
Subject: Re: Commitment control on updateable ResultSet

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