MQSeries.net :: View topic - Control the unit of work inside msg flow using java plugin

Fady

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