I remember having problems with this way back
in 8.0.4 (I think). I believe it wasn't supported
at that time and that there was some logical
reason why it shouldn't be done. But I haven't
done anything like that for years, so that can't
be taken as gospel.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated March 9th 2005
"Joe Weinstein" <joeNOSPAM_at_bea.com> wrote in message
news:424c3e10$1_at_news.beasys.com...
> One of my customers wants to use the Oracle dblink within a global
> transaction(XA transaction) on JTA.
>
> The call flow is like :
>
> JSP -> EJB (SLSB/CMT) -> TxDataSource -> Oracle XA JDBC Driver-> Oracle
> DBMS1 ---DBLINK--> Oracle DBMS2
>
> EJB: simply select row from synonym
> just select from one table.
>
> When doing this, the customer is facing the following error.
>
> -------------------
>
> java.sql.SQLException: ORA-02044: transaction manager login denied:
> transaction in progress
>
>
> It seems the answer is no... I checked metalink, and there's one post from
> someone in '00, and
> an Oracle support person not being able to find the answer....
> thanks
> Joe Weinstein at BEA
>
>
>
>
Received on Fri Apr 01 2005 - 12:52:53 CST
