Transactions

Introduction

Transactions group multiple database writes into a single atomic unit: either all changes commit, or all are rolled back.

JCC Express MVC supports transactions through:

• DB.transaction(async () => { ... })
• query builder transaction support (builder-level wrapper)

Basic transaction usage

If an exception is thrown in the callback, the transaction is rolled back.

Error handling pattern

Keep business validation and side effects (emails/webhooks) thoughtfully ordered around transaction boundaries.

Query builder transaction wrapper

The builder also exposes transaction(...) for advanced chaining scenarios:

Use DB.transaction(...) as the default for readability unless you specifically need builder-level control.

Transaction-safe practices

• Keep transaction blocks short.
• Avoid network calls inside the transaction callback.
• Prefer deterministic write order to reduce deadlock risk.
• Use row-level locks/ordering patterns if your workload is highly concurrent.

Caveats

• Avoid schema-altering statements inside app-level business transactions.
• Raw unprepared SQL with user input is unsafe; always bind parameters.

Summary

• Use DB.transaction(...) for atomic multi-step writes.
• Throwing inside the callback rolls back all changes.
• Keep transactions focused, short, and database-only.