At 18:44 -0800 3/26/02, Foo Yong Choon wrote:
My application cannot connect to the database and
perform SQL qurey after usuualy after a day.
I heard that mysql automatically close connection
after 8 hrs of inactivity.
Hope u can email me how to prevent the auto closing or
any alternative
Why can't you just detect the connection failure and reconnect?
-Original Message-
From: Foo Yong Choon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 7:45 PM
To: [EMAIL PROTECTED]
Subject: MySQL Connecyion error
My application cannot connect to the database and
On Tue, 26 Mar 2002 18:44:54 -0800 (PST)
Foo Yong Choon [EMAIL PROTECTED] wrote:
My application cannot connect to the database and
perform SQL qurey after usuualy after a day.
I heard that mysql automatically close connection
after 8 hrs of inactivity.
Hope u can email me how to
i tried to catch the exception and recoonect to MySQL
server and it
dose not work, i also tried open and closing the
connection only when i need it and that does not work
too so i had to resort to not this alternative. anyway
thanks fr your solution.. and how to make disable auto
closing
At 20:23 -0800 3/26/02, Foo Yong Choon wrote:
i tried to catch the exception and recoonect to MySQL
server and it
dose not work, i also tried open and closing the
connection only when i need it and that does not work
too so i had to resort to not this alternative. anyway
thanks fr your solution..