Overview of Firebird PHP5 Transactions

A transaction is a unit of work on the Firebird server that is either commited as a whole or rolled back as a whole. The transaction functions deal with starting and finalising transactions on the Firebird server.

Syntax

<transaction_function> ::=
     <commit>
   | <commit_ret>
   | <rollback>
   | <rollback_ret>
   | <trans>

Description

The functions to deal with transactions are:

• commit
  The commit function commits a transaction, drop all open cursors on that transaction and invalidates the transaction handle.

• commit_ret
  The commit_ret[aining] function commits a transaction, but keeps cursors open and keeps the transaction handle valid.

• rollback
  The rollback function rolls back a transaction, drop all open cursors on that transaction and invalidates the transaction handle.

• rollback_ret
  The rollback_ret[aining] function rolls back a transaction, but keeps cursors open and keeps the transaction handle valid.

• trans
  The trans[action] function explicitly starts a new transaction, with user definable properties. Explicit transactions can span multiple databases.

Default transactions

If a transaction is not explicitly started, then a "default" transaction will be used to execute SQL statements.. If no default transaction exists, a new default transaction is started. A default transaction ends on commit or rollback. The default transaction parameters are: IBASE_CONCURRENCY, IBASE_WRITE and, IBASE_WAIT.

Extend this topic - Post a comment