ID: 16704
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Feedback
+Status: Closed
Bug Type: OCI8 related
Operating System: Windows 2000
PHP Version: 4.1.2
New Comment:
use OCINlogon to force session isolation.
Previous Comments:
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
[2002-04-20 17:35:06] [EMAIL PROTECTED]
Can't comment on "if it's gone".
Do you mean that in all connection you establish you use the same
username/passwort/host (or sid) in your context?
------------------------------------------------------------------------
[2002-04-20 16:57:15] [EMAIL PROTECTED]
Hi, thanx for your fast reply!
The true version is 4.0.6. I selected 4.1.2 as there was no better
choice.
I have an aitional Note: Exactly the same problem existed for Informix
AND Mysql:
http://bugs.php.net/bug.php?id=15628
The mysql one cane be found also here.
I browsed through all OCI8 related bugs but I couldn't find this bug,
so I considered it is still existing in 4.1.2.
Antoher problem: I also tried to read the changelogs but why the hell
are there no changelogs in new releases??
updating of 4.0.2rcx is really risky as it is aproduction environment.
Do you think this problem is really gone?
------------------------------------------------------------------------
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
