Within my application (FB SQL) I use kinterbasdb.services to do backup
and restore operations.
No problem with the backup, but the restore is not working as SA seems
to hang on to a connection.
I do basically this to connect:
self.engine = db.sa.create_engine(dburl, encoding='utf8',
echo=False)
self.Session = db.sao.sessionmaker()
self.Session.configure(bind=self.engine)
self.ds = self.Session()
Then this to close:
self.ds.close()
self.Session.close_all()
del self.ds
del self.Session
del self.engine
Do backup and/or restore and then reconnect to the database.
However at this point if I pause the execution in the debugger (Boa) and
check with e.g. IBExpert I see that the db connection from SA is still open.
I guess it has to do with the connection pool, is there anyway to tell
the pool to close all connections or what other options do I have?
Werner
P.S.
This is with SA 0.5.beta1.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
