Hello Everybody,
We have a strange problem: we would like to port a PHP application,
originally developed using Oracle 8.1.X as DB (with all the oci_ functions),
to MySQL.
Unfortunately our application uses views (maybe they'll be available in version 4.1)
but also require the capability to explicitly commit any action in order to make
it permanent (or to rollback it).
1. Is it possibile, setting to FALSE the autocommit mode of MySQL, to achieve this
characteristic in PHP also?
2. Somebody suggest us the use of "Berkeley DB" but, as far as I know, Berkeley
DB is a non-SQL binary DB, not a MySQL connection API. Am I wrong? What does
this suggestion mean?
Any suggestion or link is welcome.
Many thanks in advance.
Regards,
Giulio Destri
We have a strange problem: we would like to port a PHP application,
originally developed using Oracle 8.1.X as DB (with all the oci_ functions),
to MySQL.
Unfortunately our application uses views (maybe they'll be available in version 4.1)
but also require the capability to explicitly commit any action in order to make
it permanent (or to rollback it).
1. Is it possibile, setting to FALSE the autocommit mode of MySQL, to achieve this
characteristic in PHP also?
2. Somebody suggest us the use of "Berkeley DB" but, as far as I know, Berkeley
DB is a non-SQL binary DB, not a MySQL connection API. Am I wrong? What does
this suggestion mean?
Any suggestion or link is welcome.
Many thanks in advance.
Regards,
Giulio Destri