SAP PO jdbc receiver commit on demand

[#1]

Hi all,

my requirement is to build a sequence of steps in SAP PO so to insert/update a db table. Let's say step1 updates some records, step2 updates some other records of the same table. Easy. But I need to commit step1 and step2 only after checking the result of step3, if it fails I have to rollback it.

Is it possibile to do it with SAP PO?

Regards.

Cristian

[manoj_khavatkopp]

Hi Cristian,

Try updating your mapping to have several operations in one mapping itself like :

<Statement  action ="insert">
.......
</Statement> 
<Statement  action ="update">
.......
</Statement> .....

The set the transaction isolation in the receiver channel to SERIALIZABLE. Check this link .

If the above solution does not works then you can ask DB to have a store procedure and then you can invoke the same SP from PI/PO.

Thanks,

Manoj

[digirolamocristian60]

I'm afraid I have to keep the steps apart because I have to run other programs between one step and another. I thought of achieving it with a bpm but I need PO not to automaticallysend the commit.

BR