File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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: 3775

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: 3775

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?
 
Similar Threads
How to store the page context and where would it be better.
servlet and multiple jsp windows
Please give some code or idea
handling multiple database requests and updates
getting textbox value for resultset