receiver JDBC structure

[former_member209912]

Hi

in JDBC receiver adapter structure,normally the node " statement"occurence will be 1..1 and in "statement_response" occurence is 1..1 and sub element "row" occurence will be 1..unbound.

when we go for statement in request and statement_response in response occurence as 1..unbound??

what is the use??

the node ( statement and statement_response) may be 1..1 and 1..unbound but row occurence should be 1..unbound. am i right??

for one query the resulrset will come in multiple rows but not multiple statement_response..??

Thanks

[former_member209912]

issue is resolved by myself.

[former_member200962]

the occurence depends on the number of statements that you want to execute....INSERT/ UPDATE/ SELECT etc on one or more tables of the DB.....if there is only one INSERT statement that you have to do on one Table then have the occurence as 1..1 ....if more then have the occurence accordingly.

[former_member181985]

>when we go for statement in request and statement_response in response occurence as 1..unbound??

>what is the use??

one main advantage would be, we can do multiple JDBC SQL operations on multiple tables/stored procedures in one shot.

check this link: [http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm]