Re: making the XARessource serializable - Mailing list pgsql-jdbc

From Heikki Linnakangas
Subject Re: making the XARessource serializable
Date
Msg-id 46EE6BDA.5020503@enterprisedb.com
Whole thread Raw
In response to Re: making the XARessource serializable  (teknokrat <teknokrat@yahoo.com>)
Responses Re: making the XARessource serializable  (teknokrat <teknokrat@yahoo.com>)
List pgsql-jdbc
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.

> This is a link illustrating
> the behaviour we were getting
> http://wiki.jboss.org/wiki/Wiki.jsp?page=TxNonSerializableXAResource

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".

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.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

pgsql-jdbc by date:

Previous
From: teknokrat
Date:
Subject: Re: making the XARessource serializable
Next
From: teknokrat
Date:
Subject: Re: making the XARessource serializable