Description:
------------
Hi;

We are running on :

apache: 1.3.34
php   : 4.4.2
Oracle: 10.2.0


Our Web based application seems to have a problem intermittently where by php looses connection to Oracle. We get the following error:

login ::   ::  Mar, 12th 10:28:54 ::: Warning: ociexecute(): OCIStmtExecute: ORA
login ::   ::  Mar, 12th 10:28:54 ::: -03135: connection lost contact

in file /
login ::   ::  Mar, 12th 10:28:54 ::: CatalystWMS/wmsbase/web/dbaccess/adodb-oci
login ::   ::  Mar, 12th 10:28:54 ::: 8.inc.php on line 876
--------------------------------------------------------------------------------
login ::   ::  Mar, 12th 10:28:54 ::: Notice: Only variable references should be
login ::   ::  Mar, 12th 10:28:54 :::  returned by reference
in file /CatalystWM
login ::   ::  Mar, 12th 10:28:54 ::: S/wmsbase/web/dbaccess/adodb.inc.php on li
login ::   ::  Mar, 12th 10:28:54 ::: ne 867
--------------------------------------------------------------------------------
login ::   ::  Mar, 12th 10:28:54 ::: Warning: ociexecute(): OCIStmtExecute: ORA
login ::   ::  Mar, 12th 10:28:54 ::: -03114: not connected to ORACLE

in file /
login ::   ::  Mar, 12th 10:28:54 ::: CatalystWMS/wmsbase/web/dbaccess/adodb-oci
login ::   ::  Mar, 12th 10:28:54 ::: 8.inc.php on line 876
--------------------------------------------------------------------------------
login ::   ::  Mar, 12th 10:28:54 ::: Notice: Only variable references should be
login ::   ::  Mar, 12th 10:28:54 :::  returned by reference
in file /CatalystWM
login ::   ::  Mar, 12th 10:28:54 ::: S/wmsbase/web/dbaccess/adodb.inc.php on li
login ::   ::  Mar, 12th 10:28:54 ::: ne 867
--------------------------------------------------------------------------------

The only solution is to restart Apache. Why Apache restart solves the connection problem for a long period?

Also, I've prepared a php script that queries the Oracle Database. This seems to work eventhough the problem exist and before we restart Apache.

The script is:

<?php

$conn = OCILogon("username","password", "tnsname");

$stmt = OCIParse($conn,"select emp_id from employee order by emp_id");

#OCIBindByName($stmt, ':emp', $emp);

$ok = OCIExecute($stmt);

while (OCIFetchInto($stmt,$arr)) {
#        print_r($arr);
        echo "EMP_ID = $arr[0]";
        echo "<hr>";
}

?>

Why the query using the above script works and when the application uses the adodb-oci library we get the "connection lost contact" problem. Is there a bug in the persistent connection or what?


Any advise will be appreciated.

Thanks
Hicham