[Perl-workflow-devel] AutoCommit in workflow

[Jim B. <cb...@bu...>]

Hello all,

We generally avoid using AutoCommit preferring to commit manually when 
it makes sense for transactional integrity. That is, you do everything 
you need to do for a single transaction, then commit. If something goes 
wrong, you can rollback the entire transaction cleanly.

Workflow defaults to AutoCommit and I was wondering if there would be 
any interest in allowing this to be a passed in parameter. We could 
still allow AutoCommit to be set, but we could also put in manual 
commits at appropriate points in a transaction. This would result in 
some warnings from DBI whan you manually ran the commits (unless we 
shielded the commits with a test for AutoCommit).

Any thoughts one way or the other?

Thanks,
Jim

-- 
Jim Brandt
Administrative Computing Services
University at Buffalo