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

From: Joe Weinstein <joeNOSPAM_at_bea.com>
Date: Fri, 01 Apr 2005 19:37:01 -0800
Message-ID: <424E135D.5090503@bea.com>

HansF wrote:

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

thanks
Joe Received on Fri Apr 01 2005 - 21:37:01 CST