Re: MySQL Connecyion error

2002-03-26 Thread Paul DuBois
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

Re: MySQL Connecyion error

2002-03-26 Thread Foo Yong Choon
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

Re: MySQL Connecyion error

2002-03-26 Thread Dicky Wahyu Purnomo
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

RE: MySQL Connecyion error

2002-03-26 Thread Joe Hoffman
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

Re: MySQL Connecyion error

2002-03-26 Thread Paul DuBois
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

MySQL Connecyion error

2002-03-26 Thread Foo Yong Choon
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! _