Meanwhile, can you check the new db.close() in trunk?
On Friday, 6 July 2012 15:40:57 UTC-5, demetrio wrote:
>
> Mail with the code sended :)
>
> 2012/7/6 Massimo Di Pierro <massimo.dipie...@gmail.com>:
> > 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. 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.
>
