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
JDBC Adapter execution mode Chained or Unchained ??
Database Auto-Commit Enabled ( No Transaction Handling )
on advance options of the jdbc reciever adapter?
thx , Shai