Re: Committing rolling back many objects at once?

[prev] [thread] [next] [Date index for 2005/01/21]

Sam Vilain said:
> Perrin Harkins wrote:
>> No, you can only rollback or commit everything you did on a certain
>> database connection.
>
> Some databases (even MySQL/InnoDB!) also support SQL SAVEPOINTS.
>
> So you can mark multiple points through your transactions and then later
> go back with ROLLBACK TO SAVEPOINT FOO;

Even so, it's important for users to understand that this is all tied to
the database connection, not to any specific set of objects.  Class::DBI
just calls commit on your database connection, and adds nothing on top of
that to tie transactions to objects.

- Perrin