<< Click to Display Table of Contents >>
SetAutoCommit
현재 커넥션의 자동 커밋 여부를 설정합니다.
Prototype
void SetAutoCommit(bool AutoCommit)
Parameters
AutoCommit |
자동 커밋 여부 |
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");
}