Re: [Zope-DB] dealing with dropped database connections

2006-01-22 Thread Maciej Wisniowski
> 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

Re: [Zope-DB] dealing with dropped database connections

2006-01-22 Thread Seth Gottlieb
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

Re: [Zope-DB] dealing with dropped database connections

2006-01-22 Thread martin f krafft
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

Re: [Zope-DB] dealing with dropped database connections

2006-01-18 Thread Charlie Clark
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 >

Re: [Zope-DB] dealing with dropped database connections

2006-01-18 Thread Seth Gottlieb
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

Re: [Zope-DB] dealing with dropped database connections

2006-01-18 Thread martin f krafft
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

Re: [Zope-DB] dealing with dropped database connections

2006-01-18 Thread Charlie Clark
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

[Zope-DB] dealing with dropped database connections

2006-01-17 Thread martin f krafft
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