| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to control Unit of work in Message flow using Databse Tr |
« View previous topic :: View next topic » |
| Author |
Message
|
| Fady |
 Posted: Tue Jan 21, 2003 11:55 pm Post subject: How to control Unit of work in Message flow using Databse Tr |
 |
|
Novice
Joined: 15 Jan 2003
Posts: 15
Location: Egypt , KSA
|
Hello :
I'm trying to control the unit of work inside a message flow
in this flow i'm using java plugin node that insert record in Database
and i'm using the class provided with MQSI MBNode that support unit of work and transaction failure handling.
after the java plugin node which insert record in the database i put compute node has the following Exp. Set I = 3/0; cause i need a failure happen.
the message goes to the fail queue prefctly but the Database transaction is not rolled back
bSQLStatement sqls=createSQLStatement("Trans",StrAdd,MbSQLStatement.SQL_TRANSACTION_AUTO);
sqls.execute(assembly);
I'm using the Constant MbSQLStatement.SQL_TRANSACTION_AUTO
which mean transaction commite at the end of the message follow
but it commite in the Database
thank you |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Jan 23, 2003 7:34 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Few things to check,
1. Have you configured your queue manager for 2-phase commit? If so, have you deployed your message flow in Globally Coordinated Transaction mode? What database are you using?
2. Is your catch terminal connected? At the end of MQInput node's catch path attach a Throw node to thrown back the Exception to MQInput node. Connect the failure terminal of MQInput node to FAIL queue.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| 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
|
|
|
|
