Skip to Content

Calling Stored Procedure from JDBC Adapter

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 07, 2007 at 08:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 07, 2007 at 09:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 07, 2007 at 05:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 10, 2007 at 05:15 PM

    Thanks Everyone...

    Add comment
    10|10000 characters needed characters exceeded