Maximum No of Insert Statements JDBC receiver adapter sap po

[gurudatta]

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 ...

Thanks,

Guru

[former_member190293 · Accepted solution]

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.