You might want to look in the crontab to see if rotatelogs is rotating the logs for mysql. If it is, the mysql database is bounced. The easy thing to do is just to check the connection and make sure it is open before using it.
i.e. if (conn.isClosed()) { conn=db.getConnection() } On Wed, 2002-03-27 at 00:58, Foo Yong Choon wrote: > But my program works fine and all those java code i > used to connect to mysql is what i have been taught by > my lecturer it works fine..only things is that i never > leave my application up for more than a day and that > when i discover this problem. > Usually i restart tomcat and it works again but the > problem resurface the next day. > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Movies - coverage of the 74th Academy Awards® > http://movies.yahoo.com/ > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php