How can I call web Application through Ms sql server 2012 ?
posted 3 years ago
I have web Application built with JSP code also I have DB(ms sql server 2012).
what I want,If any data was modified,created,inserted and deleted inside any table of DB(any operation on DB),it sends Notification to Application.
After receiving the Notification,Application communicate with DB and it will fetch data from DB after that inside Application some computation will be happen finally the computed data was inserted in another DB.
I read some tutorials for this,I found through QueryNotification concept we can Solve this.
again for this queryNotification concept purpose,I read some tutorials
what I understood, If you want to send any Notification from DB to any external Application you need to create Services,queue,Message-Type and contract in DB. So I created all.
Here,I faced two problems.
1. How can I send Notification to Application.
2. How Application receives Notification from DB(for this shall we need to monitor DB)
Note: End users should not interact with Application,it's for internal computations purpose. so End user can't call Application through browser.