| Author |
Message
|
| skrv |
 Posted: Wed Aug 27, 2014 8:48 am Post subject: XA Transactions on WMQ 7.0 |
 |
|
Centurion
Joined: 26 Oct 2012
Posts: 118
|
Hi,
We have MQ onZ-Linux system and is at version 7.0. We have message broker at 8.0.
In our environment all applications use WAS and use BINDINGS mode to connect to MQ. Client connections are not allowed.
We want to know what we need to do at MQ side, if an application wants to use XA transactions?
application will be deployed on WAS 8.0 and also use oracle DB at backend.
We need help to understand XA transaction and how to setup on MQ 7 on Z-Linux. |
|
| Back to top |
|
 |
| skrv |
| Posted: Wed Aug 27, 2014 9:42 am Post subject: |
|
|
Centurion
Joined: 26 Oct 2012
Posts: 118
|
Just wanted to let you know about hoe message will flow as well.
Message from app running on WAS --> Message comes to Broker QMgr --> message goes to backend application queue running on WAS again ---> backend application reads the message ----> backend application communicates with Oracle database ----> backend application puts the reply back to broker queue ------> broker flow forwards the reply back to application where it came from.
So if you see the broker in between doesnt contact the oracle database. the backend WAS application connects to oracle DB.
So considering above setup we want to know - if application wants to use XA transactions, what exactly we need to do at MQ level.
also we have 2 full repository queue managers just to let you know. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Aug 27, 2014 9:59 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Nothing to be done on MQ. I expect the application on WAS to be J2EE and the mdb descriptor will determine transactionality...
At this point you want to think more about compensating transactions...
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| skrv |
| Posted: Wed Aug 27, 2014 11:00 am Post subject: |
|
|
Centurion
Joined: 26 Oct 2012
Posts: 118
|
So you mean to say we don't need to setup any thing at MQ level to support XA transactions as MQ/Nroker doesn't connect directly to Oracle database?
Applications are JMS applications deployed on Web sphere application server 8.0.
Since WAS connect to Oracle DB, both WAS and DB needs to be configured to support XA transactions? and not MQ? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Aug 27, 2014 11:07 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| skrv wrote: |
So you mean to say we don't need to setup any thing at MQ level to support XA transactions as MQ/Nroker doesn't connect directly to Oracle database?
Applications are JMS applications deployed on Web sphere application server 8.0.
Since WAS connect to Oracle DB, both WAS and DB needs to be configured to support XA transactions? and not MQ? |
MQ will support the WAS XA transaction. Remember you have to declare an XAConnectionFactory to WAS.
Have fun
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| skrv |
| Posted: Wed Aug 27, 2014 11:16 am Post subject: |
|
|
Centurion
Joined: 26 Oct 2012
Posts: 118
|
| declare an XAConnectionFactory to WAS is supposed to be done on WAS JVM settings right? not on MQ side? |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Aug 27, 2014 6:13 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| skrv wrote: |
| declare an XAConnectionFactory to WAS is supposed to be done on WAS JVM settings right? not on MQ side? |
It is part of the WAS MQ JNDI setup.
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| skrv |
| Posted: Thu Aug 28, 2014 12:14 pm Post subject: |
|
|
Centurion
Joined: 26 Oct 2012
Posts: 118
|
Thanks.
We will contact WAS admin to make these changes. |
|
| Back to top |
|
|
|
|
