Thanks in advance.
Also, JSP is well suited to serving as a template for responses, but not so much for general-purpose templating.
For that, most people would use a more general-purpose templating tool such as FreeMarker.
Chaitra Kear wrote:Ok, suppose I make use of MySQL triggers instead of the cron job,then will it be possible?
Triggers has nothing at all to do with JSP. Again, you are barking up the wrong tree. I don't think JSP is the right tool for the job.
The app has been coded up in netbeans,so I don't understand how an external tool can be used here.
So what? Netbeans is an editor. What does it have to do with the ability to use "external tools"?
I question whether you even need Freemarker. Unless your email is complicated, you might just concatenate strings to compose the email. It's a minor part of the problem - just for the formatting part.
Chaitra Kear wrote:As you said, I don't think I need FreeMarker at all, because my email isn't going to be complicated
Then why did you feel you needed JSP? I assumed it was because you needed templating for the email body.
However MySQL by itself cannot send the email I believe.There were suggestions on the net to make the trigger run an external script(written in PHP ) which does this
If this is a cron job, why not just do it from the shell? If you don't need templating, you could likely just use the mail shell command. (Or is this running on Windows? I assume not.)
And there's this JavaMail API
That's what you would use if you were to do this from Java.