On Wed, Oct 20, 2010 at 10:47:41AM +0200, Gert Burger wrote: > SQLObject doesn't seem to reconnect to a postgres DB when its > connection(s) are lost. Is SO capable of reconnecting? > > I saw a few post related to SO and Mysql but nothing related to PG. > > A grep of the source also shows that only mysqlconnection.py has > reconnect logic in it.
MySQL can automagically reconnect by calling connection.ping(True) - after that if client library notes a connection is lost it tries to reconnect. Users must understand though that automatic reconnect has its set of problems; see http://dev.mysql.com/doc/refman/5.0/en/auto-reconnect.html for details. PostgreSQL's client library doesn't do a reconnect exactly to avoid these problems. On the other hand having timed out connections in SQLObject's pool is a problem, I understand. There have to be a way to remove them from the pool to force SQLObject to open new connections. Oleg. -- Oleg Broytman http://phd.pp.ru/ p...@phd.pp.ru Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------------ Download new Adobe(R) Flash(R) Builder(TM) 4 The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly Flex(R) Builder(TM)) enable the development of rich applications that run across multiple browsers and platforms. Download your free trials today! http://p.sf.net/sfu/adobe-dev2dev _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
