I guess defining a job on database would be an easier option.
If you want to do it thru a client java application, in that case you will need to write a Thread which will keep running and at 12 midnight make a DB connection and update the value in the table.
I hope this helps.
Regards, Mehul K. Sanghvi.
Joined: Sep 24, 2004
hi Mehul Sanghvi ,
Thanks for the reply, but sorry i could not communicate my problem clearly it seems
ex:suppose i have 40 records with me.
on change on sysdate i have to display a new record on my jsp page.
after completion of 40 records again it should start with 1st record
and display each one on change of sys date. so any suggestions plz
Joined: Feb 04, 2002
Sorry for the misinterpretation of your question.
And just to clarify that I have got it right this time you want a functionality some what similar to displaying maybe a quote of the day on your jsp, right?
Well the way I would do it is, define a table in db(or a property file on web server) which will hold the id of the current description being displayed and the date when the id was set. And then while the jsp is displayed check for the set date to current date, if these are not same then query the db for description where id = currentId+1.