Looks like I prematurely close the issue. There is now a db.close() in
trunk. Please check it out.
massimo
On Thursday, 5 July 2012 13:05:47 UTC-5, nick name wrote:
>
> On Thursday, June 28, 2012 10:47:15 AM UTC-4, Massimo Di Pierro wrote:
>>
>> why not simply?
>>
>> db.commit()
>> db.close()
>>
>> if db in an on object attribute like self.db you can do
>>
>> if self.db:
>> self.db.commit()
>> self.db.close()
>> self.db = 0
>>
>> you can also do:
>>
>> BaseAdapter.close_all_instances('commit')
>>
>
> This is not enough, as was documented on issue
> http://code.google.com/p/web2py/issues/detail?id=731<http://code.google.com/p/web2py/issues/detail?id=731#c4>.
>
> The code that works for me for sqlite is as follows:
>
> def closebase(base):
> if not base: return
> # see: http://code.google.com/p/web2py/issues/detail?id=731
> # see: https://groups.google.com/d/topic/web2py/hmsupVHdDHo/discussion
> # was: base._adapter.close()
> from gluon.dal import thread
> thread.instances.remove(base._adapter)
> base._adapter.close()
>
> and then I call closebase(db); db = None which is enough for me with
> sqlite -- but apparently, the original poster has tried that, and that is
> not sufficient for mysql.
>
