Re: Is it possible to use DBLink in XA transactions?

From: HansF <News.Hans_at_telus.net>
Date: Sat, 02 Apr 2005 02:07:22 GMT
Message-Id: <pan.2005.04.02.03.09.01.533957@telus.net>

On Thu, 31 Mar 2005 10:16:42 -0800, Joe Weinstein interested us by writing:

> One of my customers wants to use the Oracle dblink within a global
> transaction(XA transaction) on JTA.

> java.sql.SQLException: ORA-02044: transaction manager login denied: transaction in progress

Intriguing problem.

A quick check identified this on Metalink: Note:1005968.6 (update Apr'04) "Oracle Server and Unix Transaction Processing Monitors" which has a minor section (3/4 though) on XA and DBLink. Reading between the lines, and speculating a lot, I get the impression that you might need Oracle's Connection Manager involved (derived from the SQL*Net V2 and MTS comment).

Also Note:33293.1 discusses configuring XA.

Let us know what happenss ...

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Fri Apr 01 2005 - 20:07:22 CST