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

Re: Commitment control on updateable ResultSet

From: "Dave Cramer" <pg(at)fastcrypt(dot)com>
To: "Flavio Palumbo" <flavio(dot)palumbo(at)fastwebnet(dot)it>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Commitment control on updateable ResultSet
Date: 2009-01-02 12:19:40
Message-ID: 491f66a50901020419r68ca8f0cycc000c98c8e6cc94@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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
>

In response to

pgsql-jdbc by date

Next:From: Flavio PalumboDate: 2009-01-02 13:15:58
Subject: R: Re: Commitment control on updateable ResultSet
Previous:From: Flavio PalumboDate: 2009-01-02 11:47:44
Subject: Commitment control on updateable ResultSet

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