#40681 [Opn->Fbk]: Unable to close persistent connection

ID: 40681 Updated by: tony2001@php.net Reported By: frmi at freemail dot hu -Status: Open +Status: Feedback Bug Type: *Database Functions Operating System: linux PHP Version: 5.2.1 New Comment: >In some cases I want to close the connection and reconnect. Could you please elaborate? What kind of cases? >what to do, when it must be closed? One of the reason why persistent connections are called "persistent" is that you cannot close them. So if you really need to close the connection and reopen it (I can't imagine why) - don't use persistent connections or restart Apache. Previous Comments: ------------------------------------------------------------------------ [2007-03-01 16:41:00] frmi at freemail dot hu Description: ------------ I must use persistent oci8 connection to oracle, because of high load. In some cases I want to close the connection and reconnect. Is it possible somehow? The oci_close seems not to close the connection. I understand that the persistent connection was implemented to stay for reuse, but what to do, when it must be closed? Reproduce code: --------------- $conn=OCI_connect($user,$pwd,$db); ... oci_close($conn); $conn=OCI_connect($user,$pwd,$db); still uses the old oracle session Expected result: ---------------- Should disconnect from oracle db, and create a new connection. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40681&edit=1