RE: [PHP-DB] Transaction over persistent connection problem
| From: | Oskar | Date: | Wed, 27 Apr 2005 14:49:10 +0000 |
| Subject: | RE: [PHP-DB] Transaction over persistent connection problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39296@lists.php.net to get a copy of this message | ||
Ok. So the idea of splitting one transaction into two steps of a script is
wrong?
I wanted to use it in a script that is importing big amount of datas (about
200k rows).
First step:
mysql_pconnect()
start transaction
insert rows and test errors
no errors => commit, mysql_close()
some errors => echo("Some errors occured. Do you want to keep non-error
entries in database? Yes/No");
Second step:
mysql_pconnect()
Yes => commit
No => rollback
mysql_close()
> -----Original Message-----
> From: Manuel Lemos [mailto:mlemos@acm.org]
> Sent: Wednesday, April 27, 2005 4:21 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] Transaction over persistent connection problem
>
>
> The solution of Metabase (portable database abstraction package) is to
> implicitly register a shutdown function that clean any pending
> transactions:
>
> http://www.phpclasses.org/metabase
>
>
> --
>
> 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
>
>
>