Hi, I want to get alert or notification in the java application once the database trigger has executed.
Please give me the idea.
Thanks & Regards, Suresh Kumar.K
Ulf Dittmer
Marshal
Joined: Mar 22, 2005
Posts: 35249
7
posted
0
This depends highly on what the capabilities of the database are. But calling from a database into a desktop application would be difficult in any case, in addition to being bad design.
How about the desktop app checking the condition in the DB regularly, maybe once per minute?
Ulf Dittmer , Currently my desktop application checking the DB every 1 minute once.But I want to change this logic. Because some times the changes in the database will happen two days once. So I need to identify my java application once the DB gets updated. Any other way is there?
As Ulf says, pushing data from a database to client is not really what dtabases are deigned for. You can do it (depending on your database), but before you try, what is wrong with polling the database as you currently are?
0
