Mailing-List: contact dev-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@geronimo.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <49654.208.240.243.170.1139348384.squirrel@208.240.243.170>
In-Reply-To: <937046e80602071201i848464au15da3c59faa1b283@mail.gmail.com>
References: <3E5B32EC-F4EF-4F50-8FF1-47CE1DC39AA8@planet57.com>
    <7786EDD4-25BC-4D4F-99B0-31FF7A82468E@yahoo.com>
    <Pine.BSO.4.58.0602030401260.7435@ida.bway.net>
    <43E35E31.1020208@hogstrom.org>
    <937046e80602061717m775acd9fvb6eb9d41c25239f6@mail.gmail.com>
    <1C3DA75E-DDAD-47EA-8843-638DF7A8AC83@planet57.com>
    <Pine.BSO.4.58.0602070043500.23769@ida.bway.net>
    <937046e80602071201i848464au15da3c59faa1b283@mail.gmail.com>
Date: Tue, 7 Feb 2006 16:39:44 -0500 (EST)
Subject: Re: Oracle XA RAR for G1.0?
From: lichtner@bway.net
To: dev@geronimo.apache.org
User-Agent: SquirrelMail/1.4.3a
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit

> 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