its in the __del__ method of ConnectionFairy in pool.py, which can be
propigated out to whatever other connection-holding object there is (such
as this one i am still coming up with).   so "del connection" is how to
force the reference count down to zero.  but if jython isnt going to work
predictably with that either, i can add an explicit close() to do the same
thing.   one nice thing about "del" is that if the connection object is
still held somewhere, it stays around until everyone lets go.


Brad Clements wrote:
> On 5 Apr 2006 at 17:57, Michael Bayer wrote:
>
>> > Once I'm done with it, how do I release such connection back to
>> > pool so it can be used by other parts of the system?
>> >
>>
>> yes, its unique to you owning it.   to release it, you just let go of
>> it.  The pooling module works based on the Connection object falling
>> out of scope, which is what will ultimately occur.
>
> Just an interjection.. are you counting on garbage collection as the only
> way to
> release the connection?
>
> If so, please add an explicit release method. Someday when Jython is
> capable,
> I'd like to use sqlalchemy on Jython, and you can't count on garbage
> collection
> there.
>
> I believe its better to always at least offer explicit display methods
> than to rely on
> garbage collection for any cleanup.
>
> If I've mis-understood this issue .. never mind!  ;-)
>
>
> --
> Brad Clements,                [EMAIL PROTECTED]    (315)268-1000
> http://www.murkworks.com
> AOL-IM or SKYPE: BKClements
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> that extends applications into web and mobile media. Attend the live
> webcast
> and join the prime developer group breaking into this new coding
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
>



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to