Skip to Content

populating JDBC table based on content

Hi All,

I have SOAP to JDBC scenario. Based on value in message, i need to populate different tables. Tables are populated using action 'INSERT'.

Please suggest how to achieve this.

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 28 at 07:02 AM

    Hi,

    You can create multiple "Statement" structure in Data type, where each Statment refers to the structure of an individual table. Then you can have a condition using createIf for this individual statement based on source field value.

    Br,

    Manoj


    jdbc.png (27.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28 at 07:06 AM

    Hi Mohammad!

    Agree with Manoj.

    Another option would be to use dynamic SQL statement for JDBC message.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded