Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Get Alert From Database

 
K.Suresh Kumar
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
K.Suresh Kumar
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

Thanks,
Suresh Kumar.K
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic