[Zope-DB] Re: ZOracleDA again...
Chris Withers
chrisw at nipltd.com
Mon Dec 8 17:42:18 EST 2003
Hi Doug,
Doug Winter wrote:
>>It would be great if you could give this branch a go:
>>http://cvs.zope.org/Products/DCOracle2/?only_with_tag=chrisw_fixconnectionleak_branch
>
> Obviously the instant I post separately about this particular problem, I
> see this :)
>
> I've just deployed this in test and then production (I really need this
> fix!) and made the various code changes required (using db.query() instead
> of db.cursor.execute(), which I presume is in fact canonical), and I can
> report that it is working.
How come you had lines containing db.cursor.execute() in your code?
> Watching the oracle connections on the oracle server side, it appears
> to be happily releasing connections, keeping a single connection open per
> zope server. I've put some load on it too, and it seems to be reusing
> connections correctly.
That's great :-) Have you noticed any changes in speed of response, etc?
> I'll keep my eye on it for the rest of the week and followup later and let
> you know how it's going. Thanks muchly for your effort!
Thanks :-) Thanks again to Bristol University for getting the funding to make
the changes...
cheers,
Chris
More information about the Zope-DB
mailing list