eXtremeDB SQL Transaction Rellease

最新推荐文章于 2023-10-17 16:37:43 发布

liyu19870423

最新推荐文章于 2023-10-17 16:37:43 发布

阅读量453

点赞数

CC 4.0 BY-SA版权

分类专栏： eXtremeDB内存数据库文章标签：数据库 eXtremeDB 内存数据库 sql transactions

本文链接：https://blog.csdn.net/liyu19870423/article/details/44899661

eXtremeDB内存数据库专栏收录该内容

27 篇文章

订阅专栏

本文介绍eXtremeDB中使用McoSql进行事务管理的方法，包括开始、提交和回滚事务的过程，并提供了一个具体的代码示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

First of all, know that Transaction::release() releases the transaction object and related resources allocated by McoSql, but not by the eXtremeDB runtime. So the Transaction::release() method has to be called after any way to finish the transaction ( commit/release ). For example, see this snippet from our sample: “samples/native/sql/api/sql-03-transactions/mvcc/main.cpp”:

...

void task1( sample_task_t * descriptor )

  int rc;

  uint4 i;

  McoSqlSession session( &engine );

  SqlEngineAllocatorContext ctx(&session);

  Transaction* trans = session.database()->beginTransaction(Transaction::ReadWrite, 0, isolation_level);

  try {

      for (i = 0; i < (uint4)n_iterations; i++)

          StructB a;

          char tag[MAX_TAG_LENGTH+1];

          a.tag = tag;

          a.ui4 = i;

          sprintf(a.tag, "\t\tStream 1, rec %u\n", i);

          mem_write(a.tag);

          //rc = pEngine->executeStatement("insert into A %r", a);

          rc = session.executeStatement(trans, "insert into A %r", &a);

          sample_sleep(nap_duration1);

  } catch (McoSqlException &err) {

      mem_write("ERROR: ");

      mem_write(err.getMessage()->cstr());

      trans->rollback();