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@xxxxxxx]
> Sent: Wednesday, April 27, 2005 4:21 PM
> To: php-db@xxxxxxxxxxxxx
> Subject: Re: 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
>
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
