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