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