title: How to push the data from database to application?
body: <p>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.</p>
  
  <p>I google it I got some answers they are Query Notification <a href="http://msdn.microsoft.com/en-us/library/ms130764.aspx" rel="nofollow">here</a>, Sql server Agent Job to schedule the task automatically. If you have any other suggestion please post it.</p>