During my presentation at the PHP Conference in Frankfurt I put out a call for participation in creating a roadmap for Oracle connectivity in PHP.
When I get back to work (I'm on a short vacation in Europe with intermittent email access) I'll be following up on this. While I'm away, feel free to fill my inbox with suggestions and discussion of your application architecture requirements. Chris PS The Zend guys have kindly offered to look at the commonly reported Windows/PHP5.0.2/OCI8 crash. Or if anyone is compiling this combo maybe they can contribute???
--- Begin Message ---Hi John, Just saw your blog today on Andi's PHP5 / Oracle article. One of the two bugs you sited in your previous email was one that I opened (http://bugs.php.net/bug.php?id=30808) I'm not sure what the case is with the 4.3.x line, but my hunch this issue is 'bigger' than PHP5. More troubling is tony2001 response to my bug report (we don't want to turn on the noted fix, but will implement something workable with PDO). I'm anxious to hear his reply to my follow-up: it makes no sense to me that oracle users will have to settle for broken logon functions (with the fix sitting commented in the current code) or abandond the oci8 library all together for PDO when it hits the streets (which will be some time). Best, Michael -----Original Message----- From: John Lim [mailto:[EMAIL PROTECTED] Sent: Thursday, November 18, 2004 3:42 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: oci8 cannot connect after restarting DB Michael, After rereading your post again, i realise you mentioned it's happening with non-persistent connections also. That puzzles me. Perhaps we are talking about multiple bugs here. In general, I have not found PHP5 and oci8 to be very stable, and would not recommend moving anything production to use PHP5 just yet. Regardsd, John "John Lim" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi > > This is because you are using persistent connections, which are left > dangling and do not restart after the database restarts. Apparently > you can hack your tnsnames.ora or oci8 extension. > > See http://bugs.php.net/bug.php?id=15390 > > and http://bugs.php.net/bug.php?id=30808 > > Regards, John > > "Michael Caplan" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> Every evening, for whatever reason, our Oracle db (9.2.0) is >> restated. After it is restarted, I am unable to build a connection >> with Oracle from PHP untill Apache is restarted. >> >> Whenever I do an ociplogon() or ocilogon() following an Oracle DB >> restart, >> it fails but I am unable to get a description of the error. Restarting >> Apache "fixes" the problem. >> >> Has anyone else experianced the same issue? It appears to me that >> this >> is a >> php oci8 bug. (shouldn't a new connection be built if a persistant >> connection fails, and if not using persistant connections, shouldn't this >> be >> a non issue?) >> >> Thanks, >> >> Michael >> >> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php