I do not recall. Can you resend it please. My personal inbox is a bit messy.
On Friday, 6 July 2012 05:51:04 UTC-5, demetrio wrote:
>
> I will try this weekend.
>
> Massimo did you received the code of the apllication?
>
> Thanks everyone
>
>
>
> El 06/07/2012, a las 04:32, Massimo Di Pierro <massimo.dipie...@gmail.com>
> escribió:
>
> 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.
>>
>
