cancel
Showing results for 
Search instead for 
Did you mean: 

JBDC Receiver Insert Statement Response

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

MichalKrawczyk
Active Contributor
0 Kudos

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>

Answers (1)

Answers (1)

bhavesh_kantilal
Active Contributor
0 Kudos

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,

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

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

Regards,

Bhavesh