I want to push the data from database to application instead of application pull the data.I have installed ms sql server and apache tomcat server. I have my application in apache tomcat, here I made connection to database. Now I want database send the data whenever there is update in data. But all I know is fetch the data from database is not good idea, because application needs to monitor the database for updated data will lead to fire the query for every 5 sec, this is not efficient as well.
I read some tutorials in Google for this, Finally I found one method name as
Query Notification is useful as per requirements.But I don't know how to implement.
- Tell me,
query Notificationis it good way for me.
- where will I get good examples.