Re: Oracle and MTS

Welcome to N-Tier....

It has been a while since I did any developement so forgive me if I get some of this wrong.

A client will connect to your business server that has your business objects running inside of MTS (microsoft transaction server). Your business object will make calls to the database regardless of where the database is or what platform it is running on. When you start a transaction (assuming the object is marked as supports transactions) a MSDTC transaction will begin if one doesn't exists already in the current context. When you call SetComplete or SetAbort the MS-DTC (distributed transaction co-ordinator) will send a message to Oracle using a standard called XA. At this point the transaction will either commit or rollback depending on the method you called or bla bla bla you know how it works. Anyway, in version 7 and 8 of Oracle this was handeled by XA transactions. I believe that 8i has better support for MTS and it might be supported without using the XA standard but I have not looked into it. See the reference guide for Oracle with MTS in you documentation.

Hope that helps
Scott.

"Dirk Hartung" <dirk.hartung2_at_gmx.de> wrote in message news:tr0aatghhdvglj8ego6drt2mnms1odsrt3_at_4ax.com...
> Hi there!
>
> Up to now we are using in our development business object running
> under Microsoft Transaction Server and a database on MS SQL Server.
>
> We plan to offer our product to support Oracle databases as well.
>
> My question is: Is it possible to use Oracle databases running on
> something else than Windows?
> We control database transactions over MTS which means that we use
> MSDTC. Is it even possible to communicate with something else than
> Windows?
>
> Thanks in advance for any answer.
>
> Best regards
> Dirk
>
> --
> Dirk Hartung, Software-Engineering
> CODES Communication Design GmbH - the c_at_talog company
> http://www.codes.de/
>
> "Use the source, Luke!" - Dr. GUI, Microsoft
Received on Tue Mar 06 2001 - 17:53:48 CST