Bug #16704 Updated: Screwed up handles while connection multiple DBs

ID: 16704 Updated by: thmas.hoppe@daimlerchrysler-bank.com Reported By: thomas.hoppe@daimlerchrysler-bank.com Status: Closed Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: 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! Previous Comments: ------------------------------------------------------------------------ [2002-04-22 13:55:31] thies@php.net use OCINlogon to force session isolation. ------------------------------------------------------------------------ [2002-04-22 13:53:13] thomas.hoppe@daimlerchrysler-bank.com Bah! Bug in bug report: 5.) echo out connection one $con1 -> you get Resource id # 2 _______^ ------------------------------------------------------------------------ [2002-04-22 11:55:47] thomas.hoppe@daimlerchrysler-bank.com 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] thomas.hoppe@daimlerchrysler-bank.com 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] mfischer@php.net 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? ------------------------------------------------------------------------ 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