Re: dealing with dropped database connections
martin f krafft <[email protected]>
| Newsgroups | gmane.comp.web.zope.database |
|---|---|
| Message-ID | <[email protected]> |
also sprach Seth Gottlieb <[email protected]> [2006.01.18.1523 +0100]: > You might also consider using SQLRelay. I wrote some blog posts talking > about connecting to a relational database. There might be some useful > information there: > > http://contenthere.blogspot.com/2005/12/zoracle-part-i-problem.html > http://contenthere.blogspot.com/2005/12/zoracle-part-ii-solution.html > http://contenthere.blogspot.com/2005/12/zoracle-part-iii-connecting-zope-to.html These are very interesting. However, with SQLRelay, I am still bound to use SQLRelayDA for Zope, and as Charlie postulated that stale database connections are in part due to Zope's DA framework, I wonder how using SQLRelay would address the problem; if the connection to the SQLRelay server is lost, Zope would similarly hang itself up, wouldn't it? Or do you recommend running SQLRelay on the Zope server? How does SQLRelay then manage a connection that is stale? Thanks, -- martin; (greetings from the heart of the sun.) \____ echo mailto: !#^."<*>"|tr "<*> mailto:" net@madduck invalid/expired pgp (sub)keys? use subkeys.pgp.net as keyserver! spamtraps: [email protected] "women who want to be equal to men lack ambition." -- timothy leary _______________________________________________ Zope-DB mailing list [email protected] http://mail.zope.org/mailman/listinfo/zope-db
signature.asc
(application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQFD049UIgvIgzMMSnURAl04AJ4oGgIUh09djKMNjZyHqEjCJIIHVwCgwstA HSFENC3OqZTAd5IGbC7ZzVc= =QZNE -----END PGP SIGNATURE-----