Evergreen DokuWiki

The Open-ILS Storage server supports database level transactions that are performed within one OpenSRF Session. This transaction control allows atomic updates of multiple objects to be applied simultaniously without the worry of users getting broken or incomplete data due to timing issues or errors unrelated to their own queries and transactions. In order to support truely atomic transactions the database that backs the Storage server must support tranactions, but if it does not these methods will become a no-op.

Because the Storage server needs to support different types of replication systems (Multi-master, Single-master multi-slave, XA-base distributed transactions, etc.), you should wrap all write calls, such as create, update and delete, in a transaction. This will allow the Driver to detect when it should be directing a query to the master database in a single-master replication scheme.

Starts a database transaction if supported by the current Storage Driver.

• API Level: 1
• Server Class: open-ils.storage
• Implementation Method: OpenILS::Application::Storage::begin_xaction
• Streaming Method: No
• Cachable Method: No

• Returns:
  • Success
    Returns 1 on success
  • Failure
    Throws an exception uppon failure

Commits the current transaction to the database.

• API Level: 1
• Server Class: open-ils.storage
• Implementation Method: OpenILS::Application::Storage::commit_xaction
• Streaming Method: No
• Cachable Method: No

• Returns:
  • Success
    Returns 1 on success
  • Failure
    Throws an exception uppon failure

Retrieves the current transaction ID. This is generally Driver dependant.

• API Level: 1
• Server Class: open-ils.storage
• Implementation Method: OpenILS::Application::Storage::current_xact
• Streaming Method: No
• Cachable Method: No

• Returns:
  • Success
    Returns the transaction ID for the currently executing transaction
  • Failure
    Returns an empty result on failure

Rolls back the current database transaction.

• API Level: 1
• Server Class: open-ils.storage
• Implementation Method: OpenILS::Application::Storage::rollback_xaction
• Streaming Method: No
• Cachable Method: No

• Returns:
  • Success
    Returns 1 on success
  • Failure
    Throws an exception uppon failure

• Add a XA/2PC/distributed transaction manager service
• Add interface Prepared Transactions
  This will allow cross-session transaction support and non-database participation in transactions.