Skip to Content
0
Former Member
Jul 22, 2008 at 12:18 PM

JDBC Reciever - Chained Mode

20 Views

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