File to JDBC scenario

[Former Member]

Hi All,

My req is to insert the data into two tables one by one and after successful completion of that, we need to execute a stored procedure.

I have gone through the thread " which explains inserting data into two tables one by one.

And, shall i use statement3 for executing the stored procedure in continution with statement2..? will it work for SP call or only for insert statements????

if not, is there a way to achieve this through BPM...???

Please help me...

Thanks in advance,

Naresh

Edited by: naresh j on Sep 21, 2010 5:13 PM

[rodrigoalejandro_pertierr]

go throw this blog to solve your issue

/people/francesco.bersani/blog/2009/11/27/preparedstatement-with-jdbc-receiver-adapter

[Former Member]

Hi Naresh,

No need to use the BPM here,

You can add " Statementname3" after "StatementName2" in your message type.

Generally ,These statements are executed sequentially, First your Statement1 structure to insert the table after that "Statement2" structure to insert data into the table and after the third "Statement3" structure to call the stored procedure.

So you can this way.

Thank you,

Sateesh

[Former Member]

Use 3 statements - those will be executed in the order you define them. No need for BPM.

[rodrigoalejandro_pertierr]

thats solution does not guarantee that the info will be saved in the second table once all the info was saved in the first table.

[Former Member]

If the solution does not guarantee the execution order, do we have any other procedure to achieve this.???

[rodrigoalejandro_pertierr]

take a look to this