ID: 16704
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Closed
+Status: Feedback
Bug Type: OCI8 related
Operating System: Windows 2000
PHP Version: 4.1.2
New Comment:
please send me a shot _selfcontained_ php script that
shows and explains your problem!
Previous Comments:
------------------------------------------------------------------------
[2002-04-22 14:06:13] [EMAIL PROTECTED]
I also tried OCINLogon, but there was no difference.
Addition: As the documentation implies: it should be no problem for any
OCI*logon function to make more than one connections!
------------------------------------------------------------------------
[2002-04-22 13:55:31] [EMAIL PROTECTED]
use OCINlogon to force session isolation.
------------------------------------------------------------------------
[2002-04-22 13:53:13] [EMAIL PROTECTED]
Bah! Bug in bug report:
5.) echo out connection one $con1 -> you get Resource id # 2
_______^
------------------------------------------------------------------------
[2002-04-22 11:55:47] [EMAIL PROTECTED]
Update:
One piece of information was wrong: I use always the same instance/SID
name. But now I've even tried to create a alias for my instance that
both conns get a different instance without success.
After digging deeper into the problem I've figured out a really easy
way to see the bug:
1.) Create connection one $con1
2.) echo it out echo $con1 -> you get Resource id # 1
3.) Create connection two $con2
4.) echo it out echo $con2 -> you get Resource id # 2
5.) echo out connection one $con1 -> you get Resource id # 1
You see even the connection handles reflect the reality.
cu
------------------------------------------------------------------------
[2002-04-21 07:37:11] [EMAIL PROTECTED]
Hi,
Well thats an important point with the connections, I forgot it -
sorry.
I'm using for each connection a different username, password and
instance/sid.
The aim is to have during each script-run two connections. I call a
function which generates a $oci_connection and $oci_connection_adm at
the beginning of each script. Both connections are used several times
and at the end of the script a logoff on both is commited.
If I do not the workaround that I've described, PHP isn't capable of
distinguish between both conns - tha last one 'wins'.
If we had a changelog, we could review if there were any cchanges
regarding the oci stuff between 4.0.6 and 4.1.2!
cu
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/16704
--
Edit this bug report at http://bugs.php.net/?id=16704&edit=1