Re: "Canonical" transaction behaviour at connection termination
| From: | Manuel Lemos | Date: | Sun, 01 Apr 2001 00:22:59 +0000 |
| Subject: | Re: "Canonical" transaction behaviour at connection termination | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-142@lists.php.net to get a copy of this message | ||
Hello clayton,
On 30-Mar-01 18:06:11, you wrote:
>Question :
> is there a standard (or rule of thumb) responses to handling transactions
>to connection termination, or should we always ask. IOW do we automatically
>commit, rollback, or depend on a user-specified default (seems like the
>latter)
Uncommited transactions should be rolled back upon the script, even if the
script does not close the connection explictly. If the script does not do
that, you may end locking the database undefinetely when you use persistent
connections.
If you use Metabase it will handle that for you automatically.
Regards,
Manuel Lemos
Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@acm.org
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--