Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How can I call web Application through Ms sql server 2012 ?

subbu grandhi
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

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.

I hope, you understand ,what my problem

Thank you.

  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic