Hi everyone,
I have connected WebDAV and SVN auth with a wsgi script. I needed to use a
standalone DAL. When you do a dav petition with the navigator it makes a
lot of petitions. Well, the thing is that always there is a connection
opened (i can see them with PhpMyAdmin)
if self.db:
self.db._adapter.close()
seeing this issue:
http://code.google.com/p/web2py/issues/detail?id=731<http://code.google.com/p/web2py/issues/detail?id=731#c4>
I have tried a lot of the lines that i found there
something like:
if self.db:
from gluon.dal import BaseAdapter
BaseAdapter.close_all_instances(None)
BaseAdapter.close_all_instances('commit')
BaseAdapter.close_all_instances('rollback')
something like:
if self.db:
from gluon.dal import thread as dal_thread
dal_thread.instances.remove(self.db._adapter)
self.db._adapter.close()
and even something desesperated like:
if self.db:
from gluon.dal import thread as dal_thread
dal_thread.instances.remove(self.db._adapter)
self.db._adapter.close()
self.db._adapter.close_all_instances(None)
self.db._adapter.close_all_instances('commit')
self.db._adapter.close_all_instances('rollback')
from gluon.dal import ConnectionPool
ConnectionPool.close_all_instances(None)
ConnectionPool.close_all_instances('commit')
ConnectionPool.close_all_instances('rollback')
from gluon.dal import BaseAdapter
BaseAdapter.close_all_instances(None)
BaseAdapter.close_all_instances('commit')
BaseAdapter.close_all_instances('rollback')
But always, in the best, it leaves at least one connection opened, and i
don't know how to deal with it.
I have using web2py 1.99.7 in both development and production environments.
Any ideas? in this moment we are building a python mysql script, but we
want to use DAL to make it runnable on any of the web2py/DAL supported db
Thanks in advance
--
