本文整理汇总了C++中otl_connect::set_transaction_isolation_level方法的典型用法代码示例。如果您正苦于以下问题：C++ otl_connect::set_transaction_isolation_level方法的具体用法？C++ otl_connect::set_transaction_isolation_level怎么用？C++ otl_connect::set_transaction_isolation_level使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类otl_connect的用法示例。
在下文中一共展示了otl_connect::set_transaction_isolation_level方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C++代码示例。
示例1: main
int main()
{
otl_connect::otl_initialize(); // initialize ODBC environment
try{
db1.rlogon("UID=scott;PWD=tiger;DSN=freetds_mssql"); // connect to ODBC
db2.rlogon("UID=scott;PWD=tiger;DSN=freetds_mssql"); // connect to ODBC
db3.rlogon("UID=scott;PWD=tiger;DSN=freetds_mssql"); // connect to ODBC
db2.set_transaction_isolation_level(otl_tran_read_uncommitted);
db3.set_transaction_isolation_level(otl_tran_read_committed);
otl_cursor::direct_exec
(
db1,
"drop table test_tab",
otl_exception::disabled // disable OTL exceptions
); // drop table
otl_cursor::direct_exec
(
db1,
"create table test_tab(f1 int, f2 varchar(30))"
); // create table
db1.commit(); // committing the DDLs to the database
insert(); // insert records into table
cout<<"=======> Reading uncommitted data..."<<endl;
select_nolock(db2); // select records from table
db1.commit(); // committing the inserted rows to the database
cout<<"=======> Reading committed data..."<<endl;
select_committed(db3); // select records from table
}
catch(otl_exception& p){ // intercept OTL exceptions
cerr<<p.msg<<endl; // print out error message
cerr<<p.stm_text<<endl; // print out SQL that caused the error
cerr<<p.sqlstate<<endl; // print out SQLSTATE message
cerr<<p.var_info<<endl; // print out the variable that caused the error
}
db1.logoff(); // disconnect from ODBC
db2.logoff(); // disconnect from ODBC
db3.logoff(); // disconnect from ODBC
return 0;
}