This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Database lookup at a particular time? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Database lookup at a particular time?
 
Similar Threads
Problems with file upload
generating report or chart by analysing record from database
Database lookup at a particular time?
generating report or chart by analysing record from database
Problems in accessing Ranch forums... any issue?