Re: Transactions <-> Connections and Userrights

Not sure on the user groups question, but you can't hold a transaction over
multiple PHP sessions in any standard way. People think that persistent
connections will do this, but they don't. The two solutions to this are to
store all the SQL commands in an array and then run them within a
transaction on the last page, or to write some sort of "servlet" (either in
JAVA or a C/C++ daemon) that stays open for the full run of the scripts,
and issues all the DB commands itself. The first one is a LOT simpler to
code, but if you've got SELECTs that require data changed from previous
writes (INSERTs, UPDATEs, DELETEs) you are out of luck.

At 05:19 AM 9/11/01, Ravi Ahluwalia wrote:
>hi over there,
>
>how am i able to let a transaction exist among several connections, or
>is just one possible ? cause my phpskript cuts connection from db
>bevor reloading itself ofcourse :-)
>
>-how can i get information about the group which a user belongs to and
>its rights ?
>
>Thanx a lot
>Ravi
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster