Re: making the XARessource serializable

From: teknokrat <teknokrat(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: making the XARessource serializable
Date: 2007-09-17 12:58:53
Message-ID: fcltmc$56s$
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc

Heikki Linnakangas wrote:
> teknokrat wrote:
>> From what i have managed to make out, Arjuna has a xa recovery module
>> that can recover resources if the XAResource is serializable. Things get
>> more complicated if its not. I've recompiled the jdbc drivers, making
>> PGXAConnection serializable and it worked.
> What exactly did you do to "make PGXAConnection serializable"? If you
> just add "implements Serializable", you'll get an
> NotSerializableException when you actually try to serialize it.

belive or not, thats exactly what i did. I thought that the
BaseConnection instance would stuff things up but it hasn't. No idea why.

>> This is a link illustrating
>> the behaviour we were getting
> According to that, you need to provide an implementation of
> com.arjuna.ats.jta.recovery.XAResourceRecovery. Apparently there's a
> simple implementation that looks up the XADataSource implementation with
> JNDI. See JBoss Transaction API Programmers Guide, chapter 4, title
> "Shipped XAResourceRecovery implementations".

yeah, the JDBCXARecovery module. I guess I'll have to llok into that.
The problem for us being that our password can't be in plaintext.

> I'm surprised Arjuna/JBoss doesn't just connect to every database listed
> in JNDI, or at least all those that were used in the transactions that
> need recovery. That's what other app servers do, I believe.

that would be good.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Eric Faulhaber 2007-09-17 20:34:55 Batch INSERT failing with error 22P02
Previous Message Heikki Linnakangas 2007-09-17 11:58:18 Re: making the XARessource serializable