Re: [Perl-workflow-devel] AutoCommit in workflow
Brought to you by:
jonasbn
From: Jonas B. N. <jo...@gm...> - 2008-04-06 07:49:30
|
Hi Jim, I prefer handling transactions manually too, as I see it would should of course support AutoCommit and non-automatic commits. As for the actual implementation, it would be nice to eliminate possible warnings. jonasbn On 01/04/2008, at 19.41, Jim Brandt wrote: > 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 > > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace > _______________________________________________ > Perl-workflow-devel mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perl-workflow-devel |