RE: [PHP-DB] Transaction over persistent connection problem
| From: | Oskar | Date: | Wed, 27 Apr 2005 21:40:04 +0000 |
| Subject: | RE: [PHP-DB] Transaction over persistent connection problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39300@lists.php.net to get a copy of this message | ||
Thanks for your help, Manuel. Your advice saved me hours of searching the
web.
Regards, OKi98
> -----Original Message-----
> From: Manuel Lemos [mailto:mlemos@acm.org]
> Sent: Wednesday, April 27, 2005 7:20 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] Transaction over persistent connection problem
>
>
> Yes, it is not possible to achive that. What happens is that first
> access to script is handled by one Web server process or thread and you
> cannot assure that the second access will be handled by the same Web
> process or server to finish the same transaction that was started.
>
> Furthermore, you should never leave a transaction open that you cannot
> guarantee that it will finished in a very short notice, otherwise it may
> block the access to the whole database forever.
>
>
> --
>
> Regards,
> Manuel Lemos
>
> PHP Classes - Free ready to use OOP components written in PHP
> http://www.phpclasses.org/
>
> PHP Reviews - Reviews of PHP books and other products
> http://www.phpclasses.org/reviews/
>
> Metastorage - Data object relational mapping layer generator
> http://www.meta-language.net/metastorage.html
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>