#20006 [Ana]: cannot use 2 database connections
ID: 20006
Updated by: maxim@php.net
Reported By: kezal@mail.ru
Status: Analyzed
Bug Type: OCI8 related
Operating System: Linux (RH)
PHP Version: 4.2.1
New Comment:
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
Previous Comments:
------------------------------------------------------------------------
[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@mail.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
Thread (7 messages)