The solution
Dont know if this is a correct way of doing it).
Iam calling a servlet when i load a jsp page.The servlet calls a thread which executes every minute.The init method of the servlet opens a database connection and gets the number of rows in the table and stores it in a variable.
In the dopost method i call the above mentioned thread.The thread again polls the same table,gets the number of rows and stores in another variable.I keep comparing the two variables.If there is row update i do
out.println("<meta http-equiv='refresh' content='1'/>");
out.println("<html>");
out.println("<body bgcolor='#CCFFFF'>");
if(var1>var2)
out.println("<font color='#CC0033'>");
out.println("You have an Alert");
out.println("</font>");
else
out.println("<font color='#66CC33'>");
out.println("No Alert");
out.println("</font>");
Iam using mysql4.1.18.I guess it does not support triggers.
Any suggestions about my design idea?? Is it ok to call a user defined thread??
Thanks
Ragav