JDBC Adapter Receiver - Multiple Statements

[former_member96037]

Hi,

I have a scenario using one JDBC Receiver with multiple statements, actually 5 statements in the same message, this statements have to be executed in order, first statement 1, then statement 2... until statement 5.

My doubt is how does JDBC Adapter work? The adapter will be execute all statements in the same time or execute them one by one following the sequence?

I can’t use a store procedure in this case, just because the customer doesn’t want to developer this function.

Thanks a lot,

Carolina

[Former Member]

Hi Carolina,

The processing is done one statement at a time in the order of the statements.

cheers,

Prashanth

[former_member184619]

Hi Carolina,

Just check these links

http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Regards

Sachin

[Former Member]

Yes , it execute in order statement 1 and 2 ... like that for each message

I thing your using each statement for each table entries, is it. then it works.

If you clear your doubt ,please give points.

Ram