Mike, did Nick ever follow up with an example of this?  If not perhaps I could send you something.  I'm seeing the same behaviour.  After creating multiple objects and calling session.flush(), debug output show a COMMIT after each INSERT.  I'm using threadlocal w/o any explicit transaction mgmt.

On 6/20/06, Michael Bayer <[EMAIL PROTECTED]> wrote:
definitely need an example of that, ive never seen anything do that before.   it sounds like the connection is autocommitting because there is no transaction in progress (which would appear impossible since the flush() begins and commits its own transaction).  in particular i need to know if youre on the threadlocal config or not, if youre using your own SessionTransactions, etc.



On Jun 20, 2006, at 2:57 PM, Nick Joyce wrote:

Hi

I have written an import script which creates all objects in memory and
then commits everything in one transaction (100000+ objects).

With engine echo=True, I notice that that UnitOfWork is committing after
every insert, which I assume is not the required behaviour.

Using MySQL @ rev 1644.

Can supply test scripts if necessary.

Cheers,

Nick



_______________________________________________
Sqlalchemy-users mailing list




_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users



Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to