| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| XA Support with SQL Server |
« View previous topic :: View next topic » |
| Author |
Message
|
| NickB |
 Posted: Thu May 01, 2003 1:11 am Post subject: XA Support with SQL Server |
 |
|
Centurion
Joined: 20 May 2001
Posts: 107
Location: Zurich Financial Services
|
I've done lots of digging but still can't get a definitive answer.
Does WMQI (with WMQ under the covers) support SQL Server within a co-ordinated transaction? the WMQI manuals state that SQL Server is not supported but I read elsewhere that SQL Server is XA-compliant.
Presumably if I wasn't using WMQI I could use MTS and then MQ would co-ordinate the UOW correctly, whereas I have no control over the MQ application code when I'm using WMQI.
TIA |
|
| Back to top |
|
 |
| Ian |
| Posted: Thu May 01, 2003 3:26 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Nick,
| Quote: |
Does WMQI (with WMQ under the covers) support SQL Server within a co-ordinated transaction?
|
No.
Without going into a debate about whether SQL Server is XA-compliant, I can point out that Websphere MQ (base MQSeries) does not support SQL Server with co-ordinated transaction (using XA) and it therefore follows that Websphere MQ Integrator will not support this either.
This makes sense when considered with the following reference :
Websphere MQ Integrator v2.1 - Introduction and Planning Guide, Chapter 6, Transaction Support :
| Quote: |
If the message flow processing includes interaction with an external database, the
transaction can be coordinated using XA technology to assure all participants
update or return to a consistent state. This external coordination support is
provided by the underlying MQSeries facilities and the ODBC support provided
for the database. This level of XA support is only available if the database you are
using is DB2, Oracle, or Sybase.
|
Hope this helps.
_________________
Regards, Ian |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
