|
Home > Archive > SQL Server JDBC > May 2005 > XA and NON-XA Transactions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
XA and NON-XA Transactions
|
|
|
| Hello,
In a profiler how to find out if a particular transaction is an XA
transaction or an non-XA transaction.
Thanks In Advnace!
| |
| Gert E.R. Drapers 2005-05-02, 8:23 pm |
| If it is an XA transaction there will be a distributed transaction started,
so if you include event 19, DTCTransaction with columns for EventSubClass,
TextData and BinaryData, you will see the distributed transaction events,
which if they come from a JDBC clients are XA events. You will not see the
XA info inside SQL, since SQL does not understand XA directly, it gets
mapped using xaswitch in to a MS-DTC transaction, in to which SQL Server
will enlist.
GertD@SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.
"chinn" <chinn@discussions.microsoft.com> wrote in message
news:B9EF0F66-A379-4073-8E4E- 08CC61861D81@microso
ft.com...
> Hello,
>
> In a profiler how to find out if a particular transaction is an XA
> transaction or an non-XA transaction.
>
> Thanks In Advnace!
>
| |
|
| Ok then..all the DTC transactions are XA transactions and all the sp_Cursoropen
statements are non-xa transactions am i right,because i wanted to see where
there
are more xa or non-xa transactions coming to the database i wanted to change
the selctmode to direct instead of cursor ..just to try but the vendor of
one particular app says it wouldn't work for xa datasources so i wanted to
see if there
are more xa or non-xa transactions so that if we change for non-xa.it will
make the difference.
Thanks Very Much..
"Gert E.R. Drapers" wrote:
> If it is an XA transaction there will be a distributed transaction started,
> so if you include event 19, DTCTransaction with columns for EventSubClass,
> TextData and BinaryData, you will see the distributed transaction events,
> which if they come from a JDBC clients are XA events. You will not see the
> XA info inside SQL, since SQL does not understand XA directly, it gets
> mapped using xaswitch in to a MS-DTC transaction, in to which SQL Server
> will enlist.
>
> GertD@SQLDev.Net
>
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use.
> Copyright © SQLDev.Net 1991-2005 All rights reserved.
>
> "chinn" <chinn@discussions.microsoft.com> wrote in message
> news:B9EF0F66-A379-4073-8E4E- 08CC61861D81@microso
ft.com...
>
>
>
| |
| Gert E.R. Drapers 2005-05-03, 8:23 pm |
| sp_cursoropen can be part of both transaction types.
GertD@SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.
"chinn" <chinn@discussions.microsoft.com> wrote in message
news:3372D66E-E3A9-4CFB-A2D0- 17FE2521BF7B@microso
ft.com...[color=darkred]
> Ok then..all the DTC transactions are XA transactions and all the
> sp_Cursoropen
> statements are non-xa transactions am i right,because i wanted to see
> where
> there
> are more xa or non-xa transactions coming to the database i wanted to
> change
> the selctmode to direct instead of cursor ..just to try but the vendor of
> one particular app says it wouldn't work for xa datasources so i wanted to
> see if there
> are more xa or non-xa transactions so that if we change for non-xa.it will
> make the difference.
>
> Thanks Very Much..
>
>
>
> "Gert E.R. Drapers" wrote:
>
|
|
|
|
|