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 solut
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 indefinat
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 t
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 c
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
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 method. Thanks in advance!
_