v1.10

Document

How to Start SequoiaDB

Basic Operation

Data Model

Database Management

Aggregation

Index

Replication

Cluster

Connector

Reference

Development

Release Note

FAQ

  • Content
  • Comments
  • History

Transaction

Transaction is consisted of a series of actions by logical unit of work. In the same session(or connection), only allow exist one transaction in the same time. For another word, when the users create a transaction in a session, before the end of the transaction, the users can't create new transaction.

Transation performed as a complete unit of work. The operations in transaction execute either all succeed or all fail. In SequoiaDB, operations of transaction can only be insert, modify and delete data, others will not be included in transaction. It is saied that non-transactional operations will not perform rollback when execute transaction rollback action. If a collection or collectionspace have data relate to transaction operation, then the collection or collectionspace is not allowed to drop.

In default, transaction function is close, if users want to open it, need to configure param in the configuration file of nodes: transaction = TRUE; when create node, add json type of param: {"transaction":"YES"} or {"transaction":true}.

db.transBegin()

Open the transaction, SequoiaDB database transation is a series of operations as a single logical unit of work performed. Transaction processing to ensure that all operations within the unit unless all transactional successfully completed, it would not permanently updated data-oriented resources.

Example
  • Open the transaction commands:

    db.transBegin() 

db.transCommit()

Transaction commits. After the open transaction, the operation if a single logical unit of work performed without exception, execute transaction commit command, the data of the database will be update.

Example
  • Transaction commit command:

    db.transCommit() 

db.transRollback()

Transaction rollback, After the open transaction, the operation if a single logical unit of work performed by abnormal, perform transaction rollback command, then the database back to its original state.

Example
  • Transaction rollback command:

    db.transRollback() 
please login to comment.
Latest Comment
  • 2015-02-14

About Us

SequoiaDB is a financial-level distributed database vendor and is the first Chinese database listed in Gartner’s Magic Quadrant OPDBMS report. SequoiaDB has recently released version 3.0.
SequoiaDB is now penetrating the vertical sector Financial Industry quickly and had more than 50 banking clients and hundreds of enterprise customers in industries including government, telecommunication, Internet and IoT.

Beijing:
Tower R, No.8 North Star East Road, Chaoyang District, Beijing,China
Guangzhou:
Tower A, No.22 Qinglan Street, Panyu District, Guangzhou,China
Shenzhen:
Tsing Hua Tech Park, Nanshan District, Shenzhen,China
Tel:400-8038-339
E-mail:contact@sequoiadb.com