Re: PGXAConnection and autocommit problem - Mailing list pgsql-jdbc

Thanks for those two inputs. I couldn't save time today to check but it seems interesting. I'll test to see if it's
related.

-----Message d'origine-----
De : pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] De la part de Achilleas Mantzios
Envoyé : jeudi 10 février 2011 10:45
À : pgsql-jdbc@postgresql.org
Objet : Re: [JDBC] PGXAConnection and autocommit problem

Στις 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
itto false at the beginning of the transaction?
 
> > ________________________________________
> > De : pgsql-jdbc-owner@postgresql.org [pgsql-jdbc-owner@postgresql.org] de la part de rsmogura
[rsmogura@softperience.eu]
> > Date d'envoi : mercredi 9 février 2011 21:13
> > À : pgsql-jdbc@postgresql.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

-- 
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc


Think green - keep it on the screen.

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary
material,confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained
orused by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any
attachmentand all copies and inform the sender. Thank you.