Quote:
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.
with either Linux or Solaris.