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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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:
From | Date | Subject | |
---|---|---|---|
Next Message | Flavio Palumbo | 2009-01-02 13:59:35 | R: Re: R: Re: Commitment control on updateable ResultSet |
Previous Message | Dave Cramer | 2009-01-02 12:19:40 | Re: Commitment control on updateable ResultSet |