Skip to Content

jdbc receiver update_count=0 and insert_count=0

Hello,

I have a jdbc receiver scenario on PI 7.0 for one table on MS SQL Server and I'm using the update_insert action.

When the entry already exists, it's generated the statements for insert and for update (the 2 statements are visible on RWB) and returns insert_count=0 and update_count=0.

Any error occurs and in the RWB the log shows the request was processed with success.

I've already enabled the log for sql statements on the channel, but the statements are correct.

Have you already seen this problem?

Thank you very much.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 22, 2011 at 03:54 PM

    Have you used the SAP recommended JDBC response message structure to get response?

    Your jdbc request root tag starts with <Statement> then jdbc response root tag should start with <Statement_response>.

    If you follow the above syntax, you should be able to get it.

    ● action=UPDATE_INSERT

    The response document has the following format; one of the two values is always 0 because either an UPDATE or an INSERT action is always executed:

    <update_count>count</update_count>

    <insert_count>count</insert_count>

    Add comment
    10|10000 characters needed characters exceeded