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 Database lookup at a particular time? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Database lookup at a particular time? " Watch "Database lookup at a particular time? " New topic
Author

Database lookup at a particular time?

Amit Tiwary
Greenhorn

Joined: Feb 13, 2003
Posts: 22
I am building an application which will pull out a report from the database at a fixed time in a day.Say at 8PM ,it will query the database and show the report or mail the report to the Admin.I am using JSP/SERVLETS/BEANS and MSACCESS?
Plz do this .
Juanjo Bazan
Ranch Hand

Joined: Feb 04, 2002
Posts: 231
It seems that you need a process running in the background...not JSP/Servlets.
So probably you should use a Thread to do the job and make the report accessible for the servlets.
Or maybe you can create the proper java classes and trigger the execution of them once a day with a OS daemon process, but then you are not OS independent...
Amit Tiwary
Greenhorn

Joined: Feb 13, 2003
Posts: 22
Dear Juanjo Bazan;
Is there no other method?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database lookup at a particular time?
 
Similar Threads
generating report or chart by analysing record from database
Problems in accessing Ranch forums... any issue?
Database lookup at a particular time?
generating report or chart by analysing record from database
Problems with file upload