<< Click to Display Table of Contents >>
Rollback
롤백합니다.
Prototype
void Rollback()
Example
function DataBaseConnectionSample() {
var con = OZCreator.GetBuiltInObject(OZBuiltInObject.DBCONNECTION);
con.SetVendor("mssql");
con.AddItemValue("serverAddress","127.0.0.1");
con.AddItemValue("portNo","1433");
con.AddItemValue("dbName", "oz");
con.AddItemValue("user", "sa");
con.AddItemValue("password", "forcs");
var isOK = con.Connect(false);
_DEBUG("isOK="+isOK);
con.SetAutoCommit(false);
var stmt;
try {
stmt = con.CreateStatement();
var query = "insert into table1 (field1) values("value1")";
stmt.ExecuteUpdate(query);
con.Commit();
} catch(e) {
con.Rollback();
_ERROR("error="+e);
} finally {
stmt.Close();
con.Close();
}
_DEBUG("OK");
}