> 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 serv
I would try having the SQLRelay listener on the Zope server and see what that
does.
--Seth
martin f krafft ([EMAIL PROTECTED]) wrote:
>
> also sprach Seth Gottlieb <[EMAIL PROTECTED]> [2006.01.18.1523 +0100]:
> > You might also consider using SQLRelay. I wrote some blog posts talking
> > about c
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
On 2006-01-18 at 15:17:24 [+0100], martin f krafft <[EMAIL PROTECTED]>
wrote:
> also sprach Charlie Clark <[EMAIL PROTECTED]> [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
>
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
also sprach Charlie Clark <[EMAIL PROTECTED]> [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, tha
martin f krafft wrote:
Hi,
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 do
Hi,
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 abo