|
|
Posted by trpost on 03/27/07 16:11
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.
Thanks
Navigation:
[Reply to this message]
|