Skip to Content

Maximum No of Insert Statements JDBC receiver adapter sap po

Nov 23, 2017 at 07:20 AM


avatar image

Hi Guys,

I have Idoc-->> PO-->> Jdbc(Receiver) Scenario where in i have to insert the data into 6 different tables

1)Can i create 6 different Statements at jdbc end?

2)Is there any limit on the no of statements in one interface ?

3)Going forward will be there be any performance issues.

4)what is the alternative if I do not use 6 statements

Please some throw light on the above ...



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Evgeniy Kolmakov Nov 23, 2017 at 12:50 PM

Hi Gurudatta!

1. Yes.

2. Have never heard about such kind of limitation.

3. As per JDBC FAQ (SAP Note 831162): In JDBC receiver side processing, use SQL Bind Mode(i.e. , sqlBindMode parameter) which makes use of precompiled PreparedStatement for improved performance. This option is switched ON if you add the additional parameter 'sqlBindMode' with a value 'true' in the Advanced Mode table of the JDBC receiver channel configuration. Please follow the SAP Note no.1404778 for more details about this parameter. Additionally make sure that the option "Database Auto-Commit-Enabled(No Transaction Handling)" is NOT selected.

4. Another option might be using stored procedure at receiver side instead (as addition, using XML-type parameters it's possible to pass the required data to SP in the form of XML tree for further processing by database engine).

Regards, Evgeniy.

10 |10000 characters needed characters left characters exceeded