ID: 30808
Updated by: [EMAIL PROTECTED]
Reported By: michael dot caplan at lechateau dot ca
Status: Suspended
Bug Type: OCI8 related
Operating System: RHE 3
PHP Version: 5.0.2
Assigned To: tony2001
New Comment:
>And I don't see why a solution would necessarily depend on
pre-pinging.
I'd be glad to hear your proposal, Patrick.
Previous Comments:
------------------------------------------------------------------------
[2004-11-18 17:25:35] patrick dot lambert at noggin dot com
It would be great if this flaw in the OCI8
implementation could be resolved. It has been bugged
numerous times over the years. And I don't see why a
solution would necessarily depend on pre-pinging.
------------------------------------------------------------------------
[2004-11-18 16:59:38] michael dot caplan at lechateau dot ca
Ah, yes -- I suppose pinging every time would be a huge overhead. But,
how do other db supported by PHP (mysql for example) handle this issue?
I can most definately restart mysqld without needed to restart apache to
kill all my mysql persistant connections. The mysql library seams to
handle this without issue (or perhaps this is something that is
negotiated on the mysqld side)?
Also, perhaps I am miss understanding you, but you suggest that this
issue will be fixed in PDO OCI. If so, why cannot it be fixed in the
current OCI8 library?
Thanks,
Michael
------------------------------------------------------------------------
[2004-11-18 15:21:25] [EMAIL PROTECTED]
New ini option is needed because pinging every connection would lead to
huge overhead.
Your situation in fact is an exception, rather then a rule - most
people do not restart DB every day, so they would definitely not agree
with this slowdown.
------------------------------------------------------------------------
[2004-11-18 15:09:14] michael dot caplan at lechateau dot ca
Uncommenting the oci_ping() call does the trick. Both persitant and
non persistant connection then work after an Oracle restart.
But your reply confuses me. Why a new ini option (you mean at compile
time?)? Shouldn't this be the default behaviour? And why should I
wait till PDO for a stable way to connect to Oracle? Shouldn't this
issue be resolved in the current PHP OCI8 function library?
Thanks,
Michael
------------------------------------------------------------------------
[2004-11-17 07:35:17] [EMAIL PROTECTED]
Currently you have to uncomment oci_ping() call in _oci_open_server()
function (see ext/oci8/oci8.c, line 3048).
It was planned to add an ini option for that, but it seems that nobody
likes new ini options and I quess we'll take care about it in brand new
PDO OCI driver.
Personally I do not have any objections to adding new ini option, so
I'm marking this resport as suspended for the time present.
------------------------------------------------------------------------
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/30808
--
Edit this bug report at http://bugs.php.net/?id=30808&edit=1
