just run a cron job and have mysql pipe the output to a file.
check out 'man crontab'
-ryan
----- Original Message -----
From: "Venkat" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 12, 2001 5:20 PM
Subject: Automatic database connection
> Hi all
>
> Inorder to reduce load on database, I want to connect once to the database
> everyday (at 12 o' clock midnight or on change of date) and retrieve some
> information from database (say a quote of the day) and put that in
> servletcontext and display it to everyone on one particular page
>
> I am able to do this in that page and it happens only when somebody
requests
> that page, database connection is made and string data is put in
application
> (servlet) object
>
> How can I automate this, is there any way that I write same code in
web.xml
> or in any other place
>
> Please advise
>
> Thanks
>
> Venkat
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
