Transaction Control in BODS

[former_member472604]

Hi All,

I have implemmented transaction control in my BODS real time jobs which will get data from IBM MQs through JMS adapter and load the data into two tables which are in two different schemas.

i have noticed that transaction control is not working as expected. Does transaction control works loading the data into two different tables which are in two different schemas ?

Your quick help is appreaciated much.

[former_member208402]

Hi nagaraju baligola

Test your flow by with tables in same schema.

[former_member472604]

hi ,

Can any one reply on this please ? We are in early stage of our job development .

i have tested this by implementing transaction control in two tables which are there in two different schema. and found not working ?

should i keep the tables in same schema/database to implement transaction control ?