Skip to Content
0

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

Dec 23, 2016 at 08:55 AM

22

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Supriya Parab Jan 19, 2017 at 10:16 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Evgeniy Kolmakov Jan 19, 2017 at 12:44 PM
0

Hi Supriya!

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

Regards, Evgeniy.

Share
10 |10000 characters needed characters left characters exceeded