geronimo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From licht...@bway.net
Subject Re: Oracle XA RAR for G1.0?
Date Wed, 08 Feb 2006 01:39:20 GMT

9.2.x.x does work with XA.

> I'm going to retest everything with the 10.2.0.1.0_g driver... since
> 9.2.* was whack for non-xa I'm not sure that anything would work as
> expected.
>
> --jason
>
>
> On 2/7/06, lichtner@bway.net <lichtner@bway.net> wrote:
>> > I have a feeling that something else is wrong, as I mentioned before I
>> > see hanging transactions when using the local adapter in local-tx
>> > mode.  And when I ctrl-c G it corrupts the txlog each time... which is
>> > very bad IMO.
>>
>> What do you mean by "corrupts"? Do you mean that the transaction manager
>> does not perform recovery properly upon boot?
>>
>> > I'm starting to think this is a god must hate jason problem more than
>> > anything else :-(
>>
>> Since you are getting an XAException.XA_RMERR error while trying to
>> enlist
>> a resource manager, maybe Oracle is not set up properly to do XA
>> transactions for you.
>>
>> I do remember that to get XAResource.recover() to work for example you
>> have to grant the jdbc user certain database catalog privileges -
>> because
>> it has to do a select on the in-doubt transaction table. It's not
>> impossible that you have to do some configuration in the database server
>> to be able to enlist properly.
>>
>> If I were you I would try to run an xa transaction myself by calling new
>> OracleXADataSource(), calling setConnectionURL, setPassword,
>> setUserName,
>> and then getConnection() and getXAResource(), and then
>> start/end/prepare/commit. You can do this from the command line. The
>> Oracle driver has an example class that does this so you can cut and
>> paste.
>>
>> That could be a big sanity check.
>>
>> Guglielmo
>>
>>
>>
>



Mime
View raw message