Using JMS for automatic alert

Hi, guys,

I am now working on a new project. It is similar to stock price alerting. I have some investment bank account and I would like to set an alert which will be sent to the customer via email automatically. If the amount of money in that account drops to a limit, the customer has to be informed by email.

I am thinking about setting a trigger in the oracle database which will send the information to JMS Queue (I am using weblogic server 6.1) and my servlet/EJB will listen to the message. Once it receives the message, it will be sent to the customer.

Any thought about how to implement this? Is there any commercially available beans/components which can fulfil this?

thanks a lot for your help

[742 byte] By [javanovice] at [2007-9-26 3:24:27]
# 1
WHy can't you simply set the trigger to send out an email to the customer directly ?
shirish_wagh at 2007-6-29 11:44:08 > top of Java-index,Enterprise & Remote Computing,Enterprise Technologies...
# 2

start off a simple thread which implements the messagelistener interface. register ur self to the jms topic and implement the onMessage() method of the interface, here u could notify the customer. when ever u get a message on the jms u r onmessage() will be called and automatically the customer is notified...

smnaveen at 2007-6-29 11:44:08 > top of Java-index,Enterprise & Remote Computing,Enterprise Technologies...