Skip to Content
avatar image
Former Member

I need to raise excpetion if we are inserting a record in database instead of updtaing.

I need to raise excpetion if we are inserting a record in database instead of updating.however mapping shold nt fail..it should process properly.

jdbc is reciever channel

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 19, 2017 at 10:16 AM

    Hi Supriya,

    You can use JDBC lookup for this purpose. Here in mapping, through JDBC lookup and current data you can determine what would be the new entries to be inserted into the database and then from mapping itself you can send a notification. However, this approach may slow down the overall performance of the interface as for every interface run, PI has to connect to database for JDBC lookup.

    Secondly, you can ask third party database team to check on new entries inserted in database based on key values and time stamp and send notification from database.

    Regards, Supriya.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2017 at 12:44 PM

    Hi Supriya!

    Another approach might be to use stored procedure at DB side which could control processing mode and return results accordingly.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded