Skip to Content
avatar image
Former Member

after writing to database i want the JDBC response

hi forum ..pls help....

i have a file-xi-jdbc scenario.... after writing to database i want the JDBC response also...means no. of records updated/inserted/deleted etc.....means no. of rows returned

what can i do....

1. can i do it with a send step using asynchronous interface and ack....but i don know what ack does?

2. can i do it with send step using Synchronous Message Interface to the database?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 30, 2007 at 06:04 AM

    HI,

    see the below

    JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

    /people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response - XI: How-to on JDBC receiver response

    Regards

    Chilla

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 30, 2007 at 05:55 AM

    ><i>can i do it with send step using Synchronous Message Interface to the database?</i>

    yes you need to use a Synchronous Call to the JDBC adapter.

    On the basis of the Action ( insert / update , delete ) you will get the count of the number of insert / update / delete etc.

    take a look at this link and see what the datatype format for the response would be to make the synch call,

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

    Regards

    bhavesh

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 30, 2007 at 05:55 AM

    Hi,

    >>>>2. can i do it with send step using Synchronous Message Interface to the database?

    this is the only way to go with this case

    you need a sync call 😊

    have a look at this blog:

    /people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

    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