Skip to Content
avatar image
Former Member

IDOC to JDBC scenario

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 19, 2009 at 11:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Prateek Raj Srivastava

      Hi Prateek

      This stored Procedure where i will use means how i will use. Can you plz explain in detail.

      Thanks

      Dheeraj Kumar

  • avatar image
    Former Member
    Sep 19, 2009 at 02:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded