#195 SQLObject does not reconnect

[elpargo]

this is from the 0.7bug fix branch

a lot of background has been created on this in
Turbogears bug tracker.

mainly in
http://trac.turbogears.org/turbogears/ticket/872
http://trac.turbogears.org/turbogears/ticket/781

Basically the connection after being idle is drop and
SO engine is not aware of this.

Many patches have been proposed but none accepted.

[sophana]

Logged In: YES
user_id=931678
Originator: NO

I think the best solution is the one included in this mysqldb patch. The reconnection is handled directly in the mysql C api with an option.
The problem Is that this option is only available from mysql 5.0.x

http://sourceforge.net/tracker/index.php?func=detail&aid=1483074&group_id=22307&atid=374934

Other problem this patch is for mysqldb 1.2.1p2 which has problems with unicode.

Have to see if the patch is already applied or applicable to 1.2.2

[Oleg Broytman]

Logged In: YES
user_id=4799
Originator: NO

Partially fixed: in the revisions 2396-2399 there were patches that allows autoreconnect for MySQLdb 1.2.2+.