Re: [Zope-DB] Managing Connections with SQL Methods

2005-10-27 Thread Chris Withers
Why don't you just use ZSQL Methods?! Chris Seth Gottlieb wrote: The problem seemed to be that Zope.app() was returning a new root object instance every time a new DAO (data access object) was initialized. After 3, boom. The work around is to pass the context of the calling object with synta

Re: [Zope-DB] Closing idle DCoracle2 Connections?

2005-10-27 Thread Chris Withers
Germer, Carsten wrote: Ok, that's a bit much for my question I guess... I gather from all your mails that I can not "close" a database connection periodically or on event from Zope (Script or whatever)? Any hands-down clues what I can do to prevent db-conns from ideling around? Fewer database i