Distributed Transactions

[JeffLisk]

All, I'm currently running into an issue trying to get distributed
transactions to work through MSDTC and Oracle (ODP.net 11.2.0.2). I'm
getting a "Transaction Aborted" exception every time I try to run an
insert statement utilizing mybatis. I haven't been able to find a log
or trace statement that identifies the exact cause. Is there any
reason why database inserts through mybatis would not play well with
MSDTC? Is anyone successfully using mybatis, ODP.net, and MSDTC? I
have a feeling that it may be some configuration with ODP.net but
MSDTC is not given me a clear reason for the "Transaction Aborted"
message. Any help would be much appreciated.

Thanks,

Jeff

[Michael McCurrey]

I'm not using MSDTC perse; I wrap my distributed transactions through Castle's transaction library.  Do you have a code snippet we can look at?

--
Michael J. McCurrey
Read with me at http://www.mccurrey.com
http://chaoticmindramblings.blogspot.com/

[JeffLisk]

Michael, we were able to track down this problem to a bug within
ODP.net when using Oracle's Proxy Authentication. Mybatis and MSDTC
work fine when using a standard connection string without proxy auth.
We have a ticket open with Oracle and they're currently researching
the problem. Thanks for the response though......

On Oct 13, 8:54 am, Michael McCurrey <mmccur...@gmail.com> wrote:
> I'm not using MSDTC perse; I wrap my distributed transactions through
> Castle's transaction library.  Do you have a code snippet we can look at?
>

[Michael McCurrey]

No worries; Just glad it got figured out!