JDBC Reciever - Chained Mode

[Former Member]

Hello

My scenario is Proxy -> XI -> JDBC

I have to update 2 tables

1 table contains primary key

and the second table contrains forigen key

thats why I have to make sure that modification is succesfull for both tables.

and If the insert statments fails for each one of the tables , the other insert to the second table should accour

my question is how to do that in XI ?

Can I use 1 mapping and map the source proxy message type to couple of tables ? or should I set the flag

Database Auto-Commit Enabled ( No Transaction Handling )

on advance options of the jdbc reciever adapter?

thx , Shai

[ravi_raman2]

Shai,

I am a bit confused here..You want one or the other to work..or one should work only if the other works....

thats why I have to make sure that modification is succesfull for both tables.

and If the insert statments fails for each one of the tables , the other insert to the second table should or should not accour

Regards

Ravi Raman

[VijayKonam]

If you have SQL people then I would suggest to go with stored procedures for such requirements. It would easier to achieve this inside a SP.

VJ

[Former Member]

hi

procedd according to the blog

regards

kummari