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)
Date: Tue, 7 Feb 2006 22:05:19 -0500 (EST)
From: lichtner <lichtner@bway.net>
To: dev@geronimo.apache.org
Subject: Re: Oracle XA RAR for G1.0?
In-Reply-To: <937046e80602071835l6f25db8ar65d7adcb79c2af8f@mail.gmail.com>
Message-ID: <Pine.BSO.4.58.0602072205060.32561@ida.bway.net>
References: <3E5B32EC-F4EF-4F50-8FF1-47CE1DC39AA8@planet57.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>
 <49654.208.240.243.170.1139348384.squirrel@208.240.243.170>
 <937046e80602071437k2a004811rd8544b432a873625@mail.gmail.com>
 <38414.208.240.243.170.1139362760.squirrel@208.240.243.170>
 <937046e80602071835l6f25db8ar65d7adcb79c2af8f@mail.gmail.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


It just sounds like a bug, I guess.


On Tue, 7 Feb 2006, Jason Dillon wrote:

> I'm not saying it won't work... but its defintetly not happy with
> TranQL with its throwing an exception for a metadata query instead of
> returning false.
>
> --jason
>
>
> On 2/7/06, lichtner@bway.net <lichtner@bway.net> wrote:
> >
> > 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
> > >>
> > >>
> > >>
> > >
> >
> >
> >
>