Re: reconnecting to MySQL

2003-01-21 Thread Rahmin Pavlovic
> Are you inserting large blobs by any chance? I'm not, but I do think the problem is somewhere in the CF administrator since the mySQL server is on the same machine. Maybe the CF server is on a remote machine, but either way I'm looking into this. Thanks for the tips. ~~~

RE: reconnecting to MySQL

2003-01-21 Thread Roberson, Jeff, Mr (Contractor) ACI
Are you inserting large blobs by any chance? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 11:44 AM To: CF-Talk Subject: Re: reconnecting to MySQL On Tuesday 21 Jan 2003 16:18 pm, Rahmin Pavlovic wrote: > Hrmph. There isn'

Re: reconnecting to MySQL

2003-01-21 Thread Thomas Chiverton
On Tuesday 21 Jan 2003 16:18 pm, Rahmin Pavlovic wrote: > Hrmph. There isn't a more elegant way to regain lost connections to MySQL? Well, you could find out why MySQL is dropping the link ? Are you using maintain connections ? Is the timout on that longer than the timeout in MySQL, or something

Re: reconnecting to MySQL

2003-01-21 Thread Stephen Moretti
I don't have any problems with lost connections and mySQL. Do you have the datasource set to maintain connections under the CF Administrator? Even if you don't, you shouldn't be losing the connection during the query. I'd suggest that you have a network issue, if your db is on a seperate serv

Re: reconnecting to MySQL

2003-01-21 Thread Rahmin Pavlovic
> > [TCX][MyODBC]Lost connection to MySQL server during query > > > > Can someone suggest a painless way to reconnect to MySQL in this case? > > Wrap the call in a try/catch block that retrys till it works. Ugh, so I'd have to do that for all my queries? Lame. I was hoping for something more alo

Re: reconnecting to MySQL

2003-01-21 Thread Thomas Chiverton
On Tuesday 21 Jan 2003 14:05 pm, Rahmin Pavlovic wrote: > [TCX][MyODBC]Lost connection to MySQL server during query > > Can someone suggest a painless way to reconnect to MySQL in this case? Wrap the call in a try/catch block that retrys till it works. -- Tom C Space Core Directive 68250: [CENS

reconnecting to MySQL

2003-01-21 Thread Rahmin Pavlovic
I recently migrated my CF sites from NT/Access to a Linux/MySQL box running Chilisoft. Everything runs alot faster, but I get this error when the user is idle for too long: [TCX][MyODBC]Lost connection to MySQL server during query Can someone suggest a painless way to reconnect to MySQL in this