I am using JDBC to update a database daily. The servlet acts on date triggers. The problem-- unless I reinstall the servlet each morning -- the database will not update. Looks like some sort of initialization problem. I am not sure if with my server or tomcat.
I check the current date with data already stored. If the date has changed I retrieve the new data file.. Unless I reinstall the servlet- after the date change-- the process will not trigger when called from a web page. I am deleting the contents of a table and adding new data for the current date.
I have used this process elsewhere and it works fine and if it was not working it would not work when I upload a new copy of the servlet. It does work.
I check the current date with data already stored. If the date has changed I retrieve the new data file.. Unless I reinstall the servlet- after the date change
That means this could run only once for a day if it works fine? If the date changes you have to manually call the servlet? And what you meant by *reinstall the servlet-*, Can you tell us how you do this?
the process will not trigger when called from a web page.
I assume you have this code to do the work inside one of the doXXX methods in the servlet?
Joined: May 12, 2006
Yes, however you made me think of another issue. I am using doGet which I have used in the past-- with no problem. I think I will try the doPost but really see no reason why that would work.
The thing is-- it works when I re-install the class file on the server. It works fine in my local test environment-- doget... but since I have tried everything else, I will give the dopost a try...