Hi, In one of my Zope3 projects, I use lovely.remotetask to run specific tasks in background. These tasks do lengthy database operations via zope.sqlalchemy. Currently, lovely.remotetask seems to do a Zope3 commit() at the end of the task, which also does the SQLAlchemy commit.
However, some tasks consist of a loop over self-contained operations, therefore it would be handy to commit after each such operation. This way, if one of the operations fail (e.g. due to some database error, such as locking, refrential integrity violation etc.), not the whole task is rolled back but only one operation. Moreover, the probability of database locks is reduced. But, how would I do that? First of all, I'd have to catch all database error, so that lovely.remotetask does not do a rollback on its own (which errors would that be?). Then I'd have to somehow commit - should I simply do a Zope3 commit? Or should I somehow do a database commit via zope.sqlalchemy? Best Regards, Hermann -- [EMAIL PROTECTED] GPG key ID: 299893C7 (on keyservers) FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7 _______________________________________________ Zope-Dev maillist - Zope-Dev@zope.org http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )