Skip to Content
avatar image
Former Member

JBDC Receiver Insert Statement Response

Hi,

I would like to use the JDBC Receiver adapter in a synchronous szenario where I insert rows in a table. Does the adapter return a response e.g. the number of inserted rows?

Kind regards,

Heiko

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 29, 2006 at 08:32 AM

    hi,

    >>> Does the adapter return a response e.g. the number of inserted rows?

    yes of course it does

    have a look at:

    section:

    <insert_count>count</insert_count>

    on:

    http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    Regards,

    michal

    -


    <a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 29, 2006 at 08:35 AM

    Hi,

    Yes, you can do this.

    Use a BPM and have a SEND synchronous step that is asscoaiated with the RECEIVER JDBC adapter.

    Now, the Response will be returned stating the Number of Insertions as INSERT_COUNT.

    For every STATEMENT tag, there will be an INSERT_COUNT in the response. So, if you need to calculate the total number of insertions / updations just use a count function from the response.

    Take a look at this link,

    Document" target="_blank">http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for Receiver JDBC adapter

    <a href="/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response">JDBC Response HOW TO</a>

    Regards,

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded