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

ID: 16704 Updated by: mfischer@php.net Reported By: thomas.hoppe@daimlerchrysler-bank.com Status: Feedback Bug Type: OCI8 related Operating System: Windows 2000 PHP Version: 4.1.2 New Comment: 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? Previous Comments: ------------------------------------------------------------------------ [2002-04-20 16:57:15] thomas.hoppe@daimlerchrysler-bank.com 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? ------------------------------------------------------------------------ [2002-04-19 21:08:12] mfischer@php.net Which version is it now? In the Report field you write 4.1.2, but in the body you write 4.0.6 In the latter case, please test a newer version first (even 4.2.0rc4 from php.net/~derick if possible). ------------------------------------------------------------------------ [2002-04-19 15:10:19] thomas.hoppe@daimlerchrysler-bank.com I would like to report a problem and ask for help with php 4.0.6 and Oracle 8 Support. When you try to use more than one connection, the last connection created is the one that receives every statement. I found a workaround but I'm not quite sure if it really works everytime (not enough testing yet): You could do the following for each connections and somehow they are available after that: for ($i=1; $i <= 2; $i++) { $oci_connection_new = OCILogon ($oracle_user, $oracle_pass, $oracle_inst); } I reviewed $oci_connection_new and figured out thata it changes the recource id after the loop Thomas ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16704&edit=1