| Author |
Message
|
| balareddy |
 Posted: Thu Feb 09, 2006 11:14 pm Post subject: Transactions for MQSeries Queue with standard JMS |
 |
|
Acolyte
Joined: 06 Feb 2006
Posts: 54
|
Hi,
I am using Websphere MQ for Messaging Queues with standard JMS in application. I am trying in AIX5.3. My client application not using any app server. it is just normal Java application with JMS and MQ Queue for message store.
I wanted to use Transactions which will support both Oracle and MQ JMS. Oracle Transaction will take care of even for System crash. Is there any transaction which will support both(Oracle and MQ JMS) ?
Please suggest me which transaction i have to support both Oracle and JMS.
note: In my Application, i am not using any App server. it is just standalone Java application with JMS on AIX machine.
Regards
Bala
_________________
bala |
|
| Back to top |
|
 |
| BenR |
| Posted: Thu Feb 09, 2006 11:57 pm Post subject: |
|
|
Acolyte
Joined: 31 Jan 2006
Posts: 60
Location: Hursley, UK
|
If you want to do distributed transactions with MQ and a database outside an applicaiton server, you need to use the base Java API, not JMS.
JMS will only support distributed transactions within WebSphere Application Server or WebLogic (the latter may require the extended transactional client, depending on your configuration). The base Java API allows MQ to act as transaction manager for a distributed transactions involving DB2 or Oracle. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Feb 10, 2006 3:26 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
I would beg to differ. I haven't tried it but it is worth investigating.
You will have to use a J2EE TM and a way to instantiate your coordinator (TM).
As you obviously will not have a J2EE container you will need to use a User Transaction and get your TM to instantiate it.
Instantiate the DB Connection as an XA Resource. Possibly the most challenging without the Container. Need for a DataSource factory...
Use the XAConnectionFactory and XAConnection for MQ.
Then enroll both XA Resources into the transaction and let the TM handle it.
In other words a LOT OF WORK.
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| BenR |
| Posted: Fri Feb 10, 2006 7:33 am Post subject: |
|
|
Acolyte
Joined: 31 Jan 2006
Posts: 60
Location: Hursley, UK
|
| It might work, but I don't believe it would be supported. Depends if that matters. The only supported JMS/XA environments that i'm aware of are WebSphere Application Server and WebLogic. The Base Java API would allow the poster to do what he wants in a supported environment. |
|
| Back to top |
|
|
| fjcarretero |
| Posted: Tue Feb 14, 2006 3:01 am Post subject: |
|
|
Voyager
Joined: 13 Oct 2003
Posts: 88
|
|
| Back to top |
|
|
|
|
