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

-- 



Reply via email to