[Zope-DB] dealing with dropped database connections
martin f krafft
madduck at madduck.net
Wed Jan 18 09:17:24 EST 2006
also sprach Charlie Clark <charlie at egenix.com> [2006.01.18.1451 +0100]:
> 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.
Interesting pointer, thanks a lot!
I wonder how this product determines that a stalled connection
cannot fulfill a demand.
> 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.
I am not sure what you mean with that. Most transactions are
serialised by default these days. I don't understand what that has
to do with stalled connections.
But you did write serialised *connections*. What are those?
martin; (greetings from the heart of the sun.)
\____ echo mailto: !#^."<*>"|tr "<*> mailto:" net at madduck
invalid/expired pgp (sub)keys? use subkeys.pgp.net as keyserver!
spamtraps: madduck.bogus at madduck.net
*** important disclaimer:
by sending an email to any address, that will eventually cause it to
end up in my inbox without much interaction, you are agreeing that:
- i am by definition, "the intended recipient"
- all information in the email is mine to do with as i see fit and
make such financial profit, political mileage, or good joke as it
lends itself to. in particular, i may quote it on usenet.
- i may take the contents as representing the views of your company.
- this overrides any disclaimer or statement of confidentiality that
may be included on your message.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 189 bytes
Desc: Digital signature (GPG/PGP)
Url : http://mail.zope.org/pipermail/zope-db/attachments/20060118/a7412a49/attachment.bin
More information about the Zope-DB