jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes Possible reasons? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Possible reasons?" Watch "Possible reasons?" New topic
Author

Possible reasons?

Regina Thomas
Greenhorn

Joined: May 12, 2006
Posts: 16
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.

Have you ever heard of anything like this?

Q...


WiredPages | Remix
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3826

Regina Thomas wrote:... The servlet acts on date triggers. The problem-- unless I reinstall the servlet each morning -- the database will not update.

How you configured the servlet to *act* on this? What you meant by *reinstall servlet*, how do you do this?
... I am not sure if with my server or tomcat.

What other server you use?

SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
Regina Thomas
Greenhorn

Joined: May 12, 2006
Posts: 16
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.

on a unix os using apache and tomcat.

Q...
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3826

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?
Regina Thomas
Greenhorn

Joined: May 12, 2006
Posts: 16
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...

Q...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Possible reasons?