Multiple Stored Procs in Receiver JDBC with transaction handling

[former_member189558]

Hi All,

We have a requirement to call two Stored procedured in Receiver JDBC -- such that if any one of those procedure fails it should rollback the transaction/ or in other words commit only when both are successful.

Is this handled in Receiver JDBC adapter?

Thanks,

Himadri

[kkram]

How about combining both stored procedures in to a single one in the database and calling the new one from XI. It is probably an easier option to do.

KK

[former_member189558]

Hello KK,

Combining is not an option available for us.

Our requirement is there are two SPs. -- SP1 and SP2. SP1 is mapped from the header segment and called only once. SP2 is from Item segment and called multiple times based on number of items. If anyone of those calls fails the transaction should be rolled back.

Is it possible in the standard JDBC call in PI?

Thanks and Regards,

Himadri Chakraborty