Skip to Content

Update_insert in JDBC Recevier Channel

Hi Team,

i have a scenario proxy to jdbc. I want insert/update JDBC based on the account number existance. so when i am trying for 500 records itself it is taking 2 min time which is very high what i believe. i am usuing maximum cuncurrency as 3 and tables at sql server also indexed.

can any one please post me the strcture how it should be for improving performance.

as per sap below is strcture format for UPDATE_INSERT. my question is where should be 0..unbound either StatementName1 or access?


<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 02, 2016 at 09:59 AM

    Hi Allamudi,

    The sap help says access should be one for update_insert. Check below link.

    Defining an UPDATE_INSERT Statement

    Enter the new column values in the <access> element.
    Enter exactly one <access>element.
    

    Regards,

    Praveen.

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Praveen for reply.

      But when i run 500 records so 500 statements will be executed in parallel right so think of in Production i may expect 20000 records which means 20000 statements/times the query run at SQL server which will take more time. can you please let me know do you know any options how to increase the performance.

      Regards,

      Loordh.

  • Nov 03, 2016 at 12:41 AM
    Add comment
    10|10000 characters needed characters exceeded