Posted by Bart the Bear on 03/28/07 22:04

On Tue, 27 Mar 2007 09:11:29 -0700, trpost wrote:

> I just started using the php adodb library for my Oracle transactions,
> but am running into a problem when there are 2 simultaneous requests
> going on at the same time.
>
> The nature of the php app that I created is it runs a large query that
> takes approximately 15 seconds to run and then prints the data out on a
> web page.
>
> If I open 2 separate browser windows and call the same report at about
> the same time, or while one report is processing, I get the following
> error:
>
> Warning: Unknown: _oci_close_session: OCISessionEnd: ORA-03127: no new
> operations allowed until the active operation ends in Unknown on line 0
>
> When I was doing this same report using php4 and the OCI functions I had
> no problems with this database and concurrent transactions, seems to be
> something with how I am using adodb..
>
> Here is my code snippet:
>
> include('./adodb/adodb.inc.php');
> $username = "user"; //oracle user
> $password = "password"; //oracle password $database = "testdatabase";
> //tnsnames database entry
>
> //Type of connection
> $db = NewADOConnection('oci8');
>
> //Sets the query results to come back as assoc arrays
> $db->SetFetchMode(ADODB_FETCH_ASSOC);
>
> function InvokeErrorHandler()
> {
> global $db; ## assume global
> echo $db->ErrorMsg();
> }
>
> //Make the connection
> $db->Connect($database, $username, $password); if
> (!$db->Connect($database, $username, $password)) InvokeErrorHandler();
>
> $query = "SELECT * FROM table";
>
> $rs = $db->Execute($query);
>
> This all seems common, as I have seen many examples using similar config
> and connect info, but I cannot get past the concurrent issue, I have
> tried using PConnect instead of connect, but I still get problems.

Is this a Windows installation of Apache? I have no such problem
with either Linux or Solaris.

[Back to original message]