[egenix-users] Re: [egenix-sales] Zope DA which closes connection automatically

[info at egenix.com]

On 2004-08-09 at 14:43:44 [+0200], Florian Reiser <florian.reiser at ra-bc.de> 
wrote:
> Dear ladies and gentlemen,
> 
> we use the ZODBC DA to connect to VFP dbf-tables.
> When we have to do maintenance jobs on the database,
> then we recognize, that Zope doesn't release any
> database connection, no matter how long it wasn't used
> anymore.
> 
> This is very disturbing, when we try to clean up the database
> and the associated tables.
> 
> Is it possible to cause your Zope ODBC DA to release the connection
> after some timeout or even better after every request?

Dear Mr. Reiser,

we assume you mean the mxODBCZopeDA and as we have nothing to do with the 
ZODBCDA.

The mxODBDCZopeDA has several options that maybe of use to you. The option 
"connect on demand" will avoid the usual DA procedure of opening and 
keeping open the connection objects. If this does not work for you then you 
are still able to call .open() and close() methods directly on connection 
objects through ExternalMethods.

Version 1.1 of the will include customisable timeouts for both connections 
and queries assuming that the ODBC driver itself supports this.

Charlie
-- 
Charlie Clark
eGenix.com

Professional Python Services directly from the Source
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::