Bug #13986: Cannot rollback transaction when die in class
| From: | leo_ngsungchun at sinaman dot com | Date: | Thu, 08 Nov 2001 06:42:42 +0000 |
| Subject: | Bug #13986: Cannot rollback transaction when die in class | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-69783@lists.php.net to get a copy of this message | ||
From: leo_ngsungchun@sinaman.com
Operating system: Win2k / Linux + Oracle8i+Apache
PHP version: 4.0.4pl1
PHP Bug Type: Class/Object related
Bug description: Cannot rollback transaction when die in class
I am using a database class to manipulate data.
I found that when the problem is terminated in
the class, the transaction will be committed,
even I've set the mode to OCI_DEFAULT.
The same case occured in both Win2k and Linux with
Oracle and Apache.
////////////////////////////////////////////////
// Schema
////////////////////////////////////////////////
/*
create table test (
id varchar2(5) not null,
name varchar2(10),
primary key (id)
);
////////////////////////////////////////////////
// Source Code
///////////////////////////////////////////////
class Database {
var $conn, $stmt, $row_data;
function Database()
{
$DB_SERVER = "";
$DATABASE = "";
$DB_USER = "test";
$DB_PASSWORD = "test";
putenv($DATABASE);
$this->conn = OCILogon($DB_USER, $DB_PASSWORD, $DB_SERVER);
if ($this->conn == false) {
die("Cannot connect to server");
}
}
function Query($sql)
{
$this->stmt = OCIParse($this->conn, $sql);
if ($this->stmt == false) {
die("Statement Error");
}
if (OCIExecute($this->stmt, OCI_DEFAULT) == false) {
die("Cannot Execute Statment");
}
}
function Commit()
{
OCICommit($this->conn);
}
function terminate()
{
die(" Not OK :( ");
}
}
$db = new Database();
$sql = "insert into test (id, name) values ('1', '1')";
$db->Query($sql);
$db->terminate(); // This will commit the transaction,
// even the program is terminated.
die(" OK :) "); // If the program is terminated here,
// the transaction is rollbacked.
$db->Commit();
--
Edit bug report at: http://bugs.php.net/?id=13986&edit=1