On Thu, Mar 15, 2007 at 05:13:30PM +0100, sophana wrote:
> At the end, I have an sql error saying that there is no more connection
> possible. There are indeed 100 processes sleeping.
> What is creating all these connections?
Seems .doInTransaction() must call conn.commit(True). Can you test if
this works and helps?
> Now some more questions. What is the difference between
> - using a transaction object
> - simply using connection.query('begin;') and connection.query('commit;')
Transaction object properly reinitializes the underlying connection
(turning autocommit mode off and on), it has a different iterator for
InheritableSQLObject, it synchronizes cashes upon .commit().
> What about the cache? Do I have to add in sqlmeta: cacheValues=False?
I think you don't.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
