Resource id #X

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I just want to make sure of my understanding on something.  I was pretty
sure I 
had this down but now I'm beginning to question myself and I'm hoping
someone
could confirm.

* User A accesses page X, which makes a connection to the database.
Echoing
out the result of the mssql_pconnect() function shows it's using
'Resource id #10'.
* User B accesses the same page, X, making another connection to the
database.
Echosing out the result of the pconnection function shows it's using
'Resource id
#10'
 
Now, even though they are showing the same resource id, it's not
actually the
same connection, correct?  Such that when page X begins a transaction
for
both User A and User B, when that page executes the query and either
commits
or rolls back the transaction, it won't be committing or rolling back
the transaction
for the wrong user, correct?  So something like this wouldn't happen
 
BEGIN TRAN (user a)
BEGIN TRAN (user b)
Query (user b)
Query (user a)
ROLLBACK (user b)
COMMIT (user a)
 
with User B rolling back User A's transaction and User A committing User
B's
transaction (or no transaction at all).
 
My understanding is that the above could never happen and although it
shows the 
same resource id for both users, it is, in fact, two connections.
However, some
things have been occuring over the last few days that has been shaking
my under-
standing and I just want to confirm the above and rule this out as a
possible cause
for the funkiness I've been seeing.
 
thnx,
Chris
 
 

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux