Re: [SQLObject] Bad connection timeout behaviour...

[Frank B. <fb...@fo...>]

Hallo,
Chris Gahan hat gesagt: // Chris Gahan wrote:

> 
> What's the deal with the connection timeout behaviour?
> 
> I imported an SQLObject I created called Users, selected a couple items from
> it, then went away for a while. When I came back and selected another item
> from it, it threw an exception saying that the connection had timed out. It
> didn't try to reconnect, as you'd expect, but just died.
> 
> Then I did another query right afterwards, and it reconnected to the
> database and worked fine! This isn't very nice. It should really throw an
> exception if it CAN'T reconnect, not if it HAS to reconnect.

I faced the same error a lot some time ago. I don't think, it's the
fault of SQLObject, but more a bug somewhere in the mysql module or
even in mysql. The only workaround I found is a bit drastic: I now use
PostgreSQL, which solved all my problems.

ciao
-- 
 Frank Barknecht                               _ ______footils.org__