#20006 [Ver->Csd]: cannot use 2 database connections

ID: 20006 Updated by: phanto@php.net Reported By: kezal at mail dot ru -Status: Verified +Status: Closed Bug Type: OCI8 related Operating System: Linux (RH) PHP Version: 4.3.3RC4-dev New Comment: Thank you for your bug report. This issue has already been fixed in the latest released version of PHP, which you can download at http://www.php.net/downloads.php seems to be fixed Previous Comments: ------------------------------------------------------------------------ [2003-12-08 04:52:12] tony2001 at phpclub dot net I can't reproduce this bug neither with HEAD, nor with PHP_4_3 branch. does it still exist? ------------------------------------------------------------------------ [2003-11-12 01:39:45] ash at deakin dot edu dot au Just a question.. are the dates correct for this bug? The version this bug applies to is 4.3.3RC4 which is reasonably current (well, last few months). I did come across the problem, and was glad to know the cause of the problem. Thanks! ------------------------------------------------------------------------ [2002-10-21 08:48:34] maxim@php.net Also, once you're there, Thies, what could we about maintaining the connections over the database reloads as reported in several posts earlier. I am, refering for the cases when, after restarting Oracle you'd need to necessarely restart apache. I tried to research on it and it seems to me that this is doable by controlling the connection via Zend handlers (or something like that) but I am still learning about Zend Engine, so couldn't fix that part yet. Maxim Maletsky ------------------------------------------------------------------------ [2002-10-21 05:29:05] thies@php.net i could verfy that indeed there is a problem. please add a 2nd tnsname for the same database and do $a = ocilogon(.., .., tns1); $b = ocilogon(.., .., tns2); to get two independent database connections. i really hope that i find some time to fix this soon!! ------------------------------------------------------------------------ [2002-10-21 04:08:02] kezal at mail dot ru If you have created 2nd connection, you cannot use 1st connection. I think 2nd connection doesn't create its own Oracle cursor till first oraparse/exec executed === cut === //1. Connect and exec OK. $conn_id1 = ociLogon("test","test123"); $stmt1 = ociparse($conn_id1,"select count(*) from tbl_lang_"); ociexecute($stmt1); //2. Connect OK. $conn_id2 = ociLogon("book1","book123"); //3. Exec fails! $stmt1 = ociparse($conn_id1,"select count(*) from tbl_lang_"); ociexecute($stmt1); === cut === ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20006&edit=1