On Fri, Feb 12, 2010 at 08:57:06AM -1000, John Bresnahan wrote:
> I would like to disable autocommit on my underlying database connection.
> What method do I use to
> force a commit on the connection? I realize that a transaction object has a
> commit() method, but
> how do I do a similar thing with the connection i acquired via:
>
> sqlhub.processConnection = connectionForURI(config.dburl)
The object created by connectionForURI() is not a DB API connection but
an instance of SQLObject's class DBConnection; it's a high-level object
that remembers connection parameters; it opens and closes real DB
connections when they are needed, it maintains a pool of opened
connections (for multithreaded applications, e.g.). But it cannot be
committed because it's not a real connection (what low-level connection
from the pool are to be committed?)
Use transactions.
Oleg.
--
Oleg Broytman http://phd.pp.ru/ [email protected]
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
