well the Begin transaction u talked abt is SQL severs
own transaction

COM+ transaction is MSDTC and it is differnt - it
can co-orrdinate with multiple databases / resources
and as u guessed it costlier -

it can also maintain chain of calls u propogate from
ur initial method call within a single MSDTC transaction
or one or more within the same chain can start another
transaction seperate from the original one on its own...
and so forth, depending on their transactional settings

there are also transactional levels to be aware of
- read Ted pattisons MSDn column

good luck
arun

----- Original Message -----
From: "Chris Lawton" <clawtonCSC.COM>
To: <DCOMDISCUSS.MICROSOFT.COM>
Sent: Wednesday, February 20, 2002 3:41 AM
Subject: COM+ - Getting Started...

> Hi all -
>
> We've started a project to move our workflow library into the world COM+.
> As we get started and are learning (mostly by reading _Transactional COM+
> Building Scalable Applications_ by Tim Ewald), we'd like to get started
> moving some code
> into objects...
>
> I've got code that does SQL as such...
>
> BEGIN TRANSACTION
> Do some SQL updates, etc...
> COMMIT TRANSACTION (or ROLLBACK)
>
> So my question is, seeing that COM+ supports transactions, the COM+
> transactions don't replace
> the SQL Server transactions, do they? If so, durring our port, I'll need
> to make methods that
> are wholly contained within a transaction if it needs one. True?
>
> But how do I write a method to not use a transaction. (Or...is there
> something you write to tell a
> method to begin/commit a transaction.)
>
> OR...are the COM+ trasactions there to provide a transaction service for
> resources that don't normally
> have one, such as files? (and I don't use the COM+ transaction service for
> SQL?)
>
>
> Lastly, any general advice on where to concentrate study? Transactions?
> Isolation? Apartments?
> (I'm pretty familiar with DCOM and its model, but this will be my first
> work with MTS and SQL Server from
> a COM+ object)
>
> Chris
>
> ----------------------------------------------------------------
> Users Guide http://discuss.microsoft.com/archives/mailfaq.asp
> contains important info. Save time, search the archives at
> http://discuss.microsoft.com/archives/index.html .
> To unsubscribe, mailto:DCOM-signoff-requestDISCUSS.MICROSOFT.COM

----------------------------------------------------------------
Users Guide http://discuss.microsoft.com/archives/mailfaq.asp
contains important info. Save time, search the archives at
http://discuss.microsoft.com/archives/index.html .
To unsubscribe, mailto:DCOM-signoff-requestDISCUSS.MICROSOFT.COM

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]