aspose file tools*
The moose likes JDBC and the fly likes Get Alert From Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Get Alert From Database" Watch "Get Alert From Database" New topic
Author

Get Alert From Database

K.Suresh Kumar
Ranch Hand

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


Ping & DNS - my free Android networking tools app
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?

Thanks,
Suresh Kumar.K
Paul Sturrock
Bartender

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: http://aspose.com/file-tools
 
subject: Get Alert From Database