mysql...transaction question

[bruce]

hi..

i'm trying to understand if there's a difference/better reason for doing
transactions using either of the following psuedo approaches...

approach 1 does the commit inside the eval block, whereas approach 2 has the
commit outside the eval block... i've seen sample code with transactions
handled both ways...

approach 1:
eval
{
   $dbh->do("do something");

   # got this far means no errors
   # commit
   $dbh->commit();
};

# check errors/rollback
if ($@)
{
   $dbh->rollback();
}


approach 2:
eval
{
   $dbh->do("do something");
};

# check errors/rollback
if ($@)
{
   $dbh->rollback();
}
else
{
   # commit
   $dbh->commit();
}


any comments/criticisms/thoughts/etc...

thanks...

-bruce



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]