File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other JSE/JEE APIs and the fly likes Email Notification when db is getting updated Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "Email Notification when db is getting updated" Watch "Email Notification when db is getting updated" New topic
Author

Email Notification when db is getting updated

ganesh boil
Greenhorn

Joined: Sep 17, 2009
Posts: 14
Hi team,
I have an application like a shopping cart.
Here I have a table for orders.
And I want to send an email notification to the user with his order details immediately after placing the order.
So can anyone suggest me the way to achieve this? What are the api do I need to use?

And anybody had the code snippet that will be more helpful.

Thanks in advance..

Ganesh
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42950
    
  70
The best approach would be to trigger all actions from the code that updates the DB, instead of from within the DB. This sounds like business logic that should be kept out of the DB.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18992
    
    8

As for the API you would use, its name is JavaMail.
Vinod Tiwari
Ranch Hand

Joined: Feb 06, 2008
Posts: 466
    
    1

Are you using any workflow engine?? You can send email via Java Mail API.


Vinod Tiwari | Twitter | Shikshanirman | Guftgu
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Email Notification when db is getting updated