wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 41089
    
  43
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
 
Don't get me started about those stupid light bulbs.
 
subject: Get Alert From Database
 
Similar Threads
Problem in LWUIT Theme
Javascript Variable scope
re:To get alert messages like when we sign in google talk
Wanted job hunting suggestion
WA #2 ..... word association