Email Notification when db is getting updated

[ganesh boil]

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]

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]

As for the API you would use, its name is JavaMail.

[Vinod Tiwari]

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