Skip to main content

Transaction

Parents: db:connection

Description: DB:TRANSACTION specifies a transaction block for database and binary data store operations, ensuring that such processes leave the database and the binary data store in a consistent state even if an error occures within the transaction.

Transactions provide an all-or-nothing proposition, stating that each work-unit performed within a transaction must either complete in its entirety or have no effect whatsoever.

Examples

Database

<db:set entity="contacts" id="123" var_data="obj"/>

<try>
  <db:transaction>
    <db:set entity="contacts" id="123">
      <db:data field="lastname">New</db:data>
    </db:set>
    
    <error/>
  </db:transaction>
  
  <catch/>
</try>

<db:get var="obj" entity="contacts" id="123">
  <db:field>lastname</db:field>
</db:get>

<output>$obj.lastname</output>

<!-- Old -->