on 09-19-2009 1:30 PM
Hi All
I am doing IDOC to JDBC Scenario.
From one IDOC i have to upload the data into 3 tables.
Table A
Table B
Table C
now the thing is - i have to upload the data in sequence.
concept is - firstly IDOC data should be uploaded to Table A then Table B and then Table C.
I dont want the data to be uploaded parallely in all the 3 tables.
is it possible if yes then how?
Regards
Dheeraj Kumar
The possibility suggested by Siva seems to be an option but in case JDBC receiver went down, all messages will be stuck with System Error. Once you restart the messages, the Order will get lost.
I would suggest using BPM to send the messages sequentially which would ensure proper error handling.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are these tables updated using 3 seperate update/insert statements?? or using some stored proce
If they are using 3 seperate update/insert staements...
During Interface determination, use maintain Order at runtime checkbox.
This will ensure that the 3 messages created (during mapping) are sent to JDBC adapter in that Order..
If using stored proc, the Storedproc should take care of the logic..
-Siva Maranani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.