If you set the interactive_timeout to infinite then no clients will get disconnected until the server is restarted. I know the perl DBI allows for a client to implement ping ($dbh->ping) ... this will reset the timeout for that particular client, allow the client to check for connectivity, without having to make ever client connect forever!!. I'm sure the JDBC driver will allow for this.
Regards, Dan > -----Original Message----- > From: beckymcelroy [mailto:beckymcelroy]On Behalf Of Becky McElroy > Sent: Tuesday, 12 February 2002 9:31 a.m. > To: [EMAIL PROTECTED] > Subject: How to connect in non-interactive mode > > > Hello- > > How does one run a client in non-interactive mode? Or, is there a way > to set interactive_timeout at the MySQL server to infinite? We have a > software component connecting to MySQL (using Mark Matthews JDBC driver) > and there may be a long time (> 8 hours) of inactivity. > > Any suggestions much appreciated - > > Becky McElroy > > > > --------------------------------------------------------------------- > 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
