Database Adapter releasing database connection after request
Hello zopistas, could anybody tell me, how I could convince ZODBCDA to close the database connection after each request? Or is there another ODBC adapter around, which can handle this. Maybe I could take parts of ZODBCDA and extend it? I need this feature because I want to be able to clean up the database and the associated tables without having to restart zope. The problem is: As long as zope holds a connection to my database, I can't get exclusive access to it. Simple kicking zope off the database isn't possible either. So I do have to do it the nice way. With kind regards Florian Reiser -- NEU: WLAN-Router f�r 0,- EUR* - auch f�r DSL-Wechsler! GMX DSL = superg�nstig & kabellos http://www.gmx.net/de/go/dsl
Hi Florian, Florian Reiser wrote:
could anybody tell me, how I could convince ZODBCDA to close the database connection after each request? Or is there another ODBC adapter around, which can handle this. Maybe I could take parts of ZODBCDA and extend it?
I need this feature because I want to be able to clean up the database and the associated tables without having to restart zope. The problem is: As long as zope holds a connection to my database, I can't get exclusive access to it. Simple kicking zope off the database isn't possible either. So I do have to do it the nice way.
The eGenix ODBC adapter has this capability: - http://www.egenix.com/ An evaluation version is available, too. I think existing issues with ZODBCDA are such that time time spent addressing this would not be well invested - I'm not even sure that the source was ever available. -- Regards, PhilK Email: phil@xfr.co.uk / Voicemail & Facsimile: 07092 070518 "The lyf so short, the craft so long to learne" - Chaucer
Hi Phil, could you tell me, which switches I have to set? I don't find any clues in the documentation at egenix.com. Regards Florian
Hi Florian,
Florian Reiser wrote:
could anybody tell me, how I could convince ZODBCDA to close the database connection after each request? Or is there another ODBC adapter around, which can handle this. Maybe I could take parts of ZODBCDA and extend it?
I need this feature because I want to be able to clean up the database and the associated tables without having to restart zope. The problem is: As long as zope holds a connection to my database, I can't get exclusive access to it. Simple kicking zope off the database isn't possible either. So I do have to do it the nice way.
The eGenix ODBC adapter has this capability: -
An evaluation version is available, too.
I think existing issues with ZODBCDA are such that time time spent addressing this would not be well invested - I'm not even sure that the source was ever available.
--
Regards,
PhilK
Email: phil@xfr.co.uk / Voicemail & Facsimile: 07092 070518
"The lyf so short, the craft so long to learne" - Chaucer
-- NEU: WLAN-Router f�r 0,- EUR* - auch f�r DSL-Wechsler! GMX DSL = superg�nstig & kabellos http://www.gmx.net/de/go/dsl
Hi Florian, Florian Reiser wrote:
could you tell me, which switches I have to set? I don't find any clues in the documentation at egenix.com.
When I've needed to do this, I've done it manually in the ZMI - there's a button to open and close the connection (3.3.9 in the DA docs). If you need to do it in code, I believe you will need to look at the mxODBC (as opposed to DA) docs. You'd get a better answer from the zope-db list, where some of the egenix guys hang out... -- Regards, PhilK Email: phil@xfr.co.uk / Voicemail & Facsimile: 07092 070518 "The lyf so short, the craft so long to learne" - Chaucer
participants (2)
-
Florian Reiser -
Philip Kilner