From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: PGXAConnection and autocommit problem |
Date: | 2011-02-10 09:45:09 |
Message-ID: | 201102101145.10201.achill@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Στις Thursday 10 February 2011 10:42:44 ο/η Heikki Linnakangas έγραψε:
> On 10.02.2011 09:50, Maurin, Marion wrote:
> > Yes, I think I saw that too, that the autocommit shouldn't be set from outside. But shouldn't the driver itself set it to false at the beginning of the transaction?
> > ________________________________________
> > De : pgsql-jdbc-owner(at)postgresql(dot)org [pgsql-jdbc-owner(at)postgresql(dot)org] de la part de rsmogura [rsmogura(at)softperience(dot)eu]
> > Date d'envoi : mercredi 9 février 2011 21:13
> > À : pgsql-jdbc(at)postgresql(dot)org
> > Objet : Re: [JDBC] PGXAConnection and autocommit problem
> >
> > Driver should prevent set auto commit, or change it value in any case.
> > I thought I saw exception in code preventing this.
> > On Wed, 9 Feb 2011 14:28:44 +0000, Maurin, Marion wrote:
> >> Hi,
> >>
> >> I hope I'm in the right mailing list.
> >>
> >> I'm currently facing a problem with Postgresql XA connections. I'm
> >> trying to have my transactions working but no rollback seems to take
> >> effect. After searching, I think the problem is about the autoCommit
> >> mode which is set to true even during the transaction.
>
> It's quite possible that there's a bug somewhere in the XA driver -
> we've had several bugs related to autocommit and XA in the past.
>
I remember my similar case one year ago :
http://archives.postgresql.org/message-id/201003021629.07368.achill%40matrix.gatewaynet.com
Anyways Heikki helped a lot on this one i remember, and also wrote a patch. Thanx Heikki!
> And I think this one is still pending:
> http://archives.postgresql.org/message-id/4D01DFA8.3060207@emaze.net.
> Could it be related?
>
> Can you create a small self-contained test program to reproduce the
> issue, and post it to the list?
>
> --
> Heikki Linnakangas
> EnterpriseDB http://www.enterprisedb.com
>
--
Achilleas Mantzios
From | Date | Subject | |
---|---|---|---|
Next Message | Lukas Eder | 2011-02-10 09:45:17 | Re: UDT arrays |
Previous Message | Heikki Linnakangas | 2011-02-10 08:42:44 | Re: RE : PGXAConnection and autocommit problem |