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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 > > >> > > >> > > >> > > > > > > > > > >