Calling Stored Procedure from JDBC Adapter

[former_member189558]

Hello,

I am Updating a SQL Server Table using JDBC Adapter.

Now I have multiple input rows and the procedure needs to be called for each set.

Do I need to use multimapping for this or just generating multiple <b>Statement</b> node will solve?

Also For this will there is any knows/ forseen problem (like Transaction handling) that I need to take care of?

Thanks and Regards,

Himadri

Message was edited by:

Himadri Chakraborty

[Former Member · Accepted solution]

You don't need to handle any transactions. Check the advanced option in JDBC adapter and you can use DEFAUT option, which automatically uses the JDBC transaction level. As others said you don't even need to use the multi mapping, Multiple stmt node will do

Regards,

Ravi

[former_member189558]

Thanks Everyone...

[Former Member]

Hi Himadri,

You can create multiple nodes to solve your issue.Multimapping is not needed in this case.You go for multimapping only when you fetch data from multiple tables

[Former Member]

Himadri,

You can just create multiple statement nodes in one message.

I am not aware of any known or foreseen issues with this approach.

Kind regads,

Koen