martin f krafft wrote:
a client of mine complains about dropped database connections
(SybaseDA), which wreak havoc. For instance, if the network goes
down for a while, the DA is left in an irrecoverable state.
Short of a regular wget to the manage interface to restart the DA,
what can be done? Is this something about SybaseDA (which is no
longer maintained), or a common problem?
What would you advise, short of hunting down the problem and fixing
This problem is common to all ZopeDA's connected to network data
sources. You might want to try using our mxODBCZopeDA with the option
"Connect on demand" which often helps in these situations. However, a
lot depends on how your data source and driver are configured as the
"stale" connection is often serialised even though it has been lost.
Zope-DB mailing list