Skip to Content
author's profile photo Former Member
Former Member

Large data through JDBC adapters - restart

We have a big file with more than 20000 records, that needs to be loaded onto database table.

Should we split the files into multiple messages (1000 records each) and try to insert into Database table? Or Should we insert all record in one stretch.

If we follow the first approach, how do we go about restarting the message if there are any insert failures?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Feb 18, 2008 at 09:21 PM

    Hi,

    > Should we split the files into multiple messages (1000 records each) and try to insert into Database table? Or Should we insert all record in one stretch.

    1) From the Source side you can split and send

    2) Multiple messages is advicable

    Shall we know the Source ?

    Regards

    Agasthuri Doss

    Add a comment
    10|10000 characters needed characters exceeded

    • Kris,

      Since you are using Content conversion, just set Recordset per message for ex 1000 and do the rest of the stuff. Do u want to see the error in SXMB_MONI if it fails? If yes then make it as Synchronous Inbound.

      The best process as mentioned above

      - Split the file.

      - Create Asynh O/B and Synch I/B

      If you finalize the above steps then u can go ahead with mapping.

      raj.

  • Posted on Feb 18, 2008 at 08:58 PM

    Kris,

    Are u going to use BPM? Is it one time Mass upload or this data is expected all the time?

    raj.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.