File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Get Alert From Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Get Alert From Database" Watch "Get Alert From Database" New topic

Get Alert From Database

K.Suresh Kumar
Ranch Hand

Joined: Nov 21, 2007
Posts: 41
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

Joined: Mar 22, 2005
Posts: 42965
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

Joined: Nov 21, 2007
Posts: 41
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?

Suresh Kumar.K
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

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?

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: Get Alert From Database
It's not a secret anymore!