PHP Pear - [PEAR] DB_DataObject MySQL TRANSACTION ISOLATION LEVEL

Author

[PEAR] DB_DataObject MySQL TRANSACTION ISOLATION LEVEL

John Zhao

2004-06-28, 4:08 pm

I wish to implement an unit of work with "select update". How can I set
TRANSACTION ISOLATION LEVEL to "READ COMMITTED". here are my code, but got
database error as the following. Please help. Thanks!!

$project = new DataObjects_Project;
$conn = $project->getDatabaseConnection();

$res_read = $conn->query("READ COMMITTED");

print_r($res_read);

Alan Knowles

2004-06-29, 3:56 am

I think you missed out the result from print_r

you could try
$project->query('READ COMMITTED');

it should work the same.

Regards
Alan

John Zhao wrote:
> I wish to implement an unit of work with "select update". How can I set
> TRANSACTION ISOLATION LEVEL to "READ COMMITTED". here are my code, but got
> database error as the following. Please help. Thanks!!
>
> $project = new DataObjects_Project;
> $conn = $project->getDatabaseConnection();
>
> $res_read = $conn->query("READ COMMITTED");
>
> print_r($res_read);

--
Can you help out?
Need Consulting Services or Know of a Job?
http://www.akbkhome.com

Sponsored Links