You should be handling the timeout connection in your code. You will be looking for a SQLState of `08S01`. Once you have captured this your can attempt to reconnect to the database.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/5/04, 4:21:36 PM, dan orlic <[EMAIL PROTECTED]> wrote regarding maintaining connects to mysql: > well this is what the deal is... I have a client/server application and > the server connects to mysql > via torque, an open source software project, they are jdbc connections. > Here is the problem: If the applications is left up, let's say, > over night, and the client tries to access the database, via the server, > the connects that torque aquired have timeout and > are no longer valid. so i thought that the wait_timeout variable might > be the way to go... > do you know of something else I can set/configure in mysql so that the > connection I initially create remain viable? > thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
