| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQSeries, Oracle and XA transactions |
« View previous topic :: View next topic » |
| Author |
Message
|
| bartek_n |
 Posted: Thu Sep 29, 2005 3:55 am Post subject: MQSeries, Oracle and XA transactions |
 |
|
Novice
Joined: 28 Sep 2005
Posts: 10
|
I've just take a look into following documentation: http://www.hofsvang.no/books/IBM/WebSphereMQ.5.2/html/en_US/amqzag/amqzag2v.htm#HDREGUOW
and I am confused if my current aproach is wrong or not...
The scenario is, that I have this java appliaction (running unfortunatelly on ATG Dynamo app server) which uses MQSeries (via JMS) and Oracle database (XADataSource using the racle.jdbc.xa.client.OracleXADataSource, not this FakeXADataSource crap!). Access to both is enclosed within XA transactions. What I believe is happening is, that we get TransactionManager instance from Dynamo (however, from the instance of repository working on the top of Oracle), than I open connection with MQSeries (enlisting it explicitly as a resource) and also do some stuff with database (I assume that enlisting is done by TM behind the scene). Then I commit/rollback the global transaction and expect that all is happy and consistent. But somethimes strange things happen (like long-lasting uncommited msgs in the queue, lock held by in-doubt transactions in Oracle)...
So, is this approach correct?
In docs in the link I put above there is info about how to get the queue manager know about the Oracle resource manager. What is the purpose of it and when it has to be used? In case the queue manager acts as transaction manager? There is a strange 'switch file' used, so it would suggest that the MQSeries and Oracle have to run on same machine?
Bartek |
|
| Back to top |
|
 |
| wschutz |
| Posted: Thu Sep 29, 2005 6:04 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
|
| Back to top |
|
|
| bartek_n |
| Posted: Thu Sep 29, 2005 6:15 am Post subject: |
|
|
Novice
Joined: 28 Sep 2005
Posts: 10
|
You've got me 
Basically it is, but here I wanted to ask if the whole concept is right, without getting into details of problems - just to make sure I haven't done any stupid basic mistake in understanding how it should be used.
And this is Java-releated section, so I though maybe also other people are visiting this branch. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Sep 29, 2005 12:36 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
The concept is sound. It is just that you are using the ATG transaction manager and not a J2EE transaction manager for a J2EE pattern.
Welcome to surprises and pain. Have you tried yet using the JTA transaction manager supplied by ATG in your scenario ?  |
|
| 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
|
|
|
|
