[Zope] Autoconnect with ZMySQLDA 2.0.9

[Dennis Allison]

I have been seeing occasional "release unlocked lock" errors from a 
storage error in a two-phase commit which really comes from a "Lost 
connection to MySQL server during query".  Apparently this arises from 
a failure of self.db.ping() to find a connected database as the 
transaction is opened.

It is possible that the connection has really timed out.

Looking at the code it appears that ZMySQLDA does not attempt to 
recreate the connection.  Is that correct? 

What's the recommend approach to re-establish the connection?

-d

--