inTopLevelSuspendTransaction
Creates a suspendable transaction at the top level with the specified transactionIsolation and readOnly settings, then calls the statement block with this transaction as its receiver and returns the result.
Note All changes in this transaction will be committed at the end of the statement block, even if it is nested and even if DatabaseConfig.useNestedTransactions is set to false.
Note If the database value db is not set, the value used will be either the last Database instance created or the value associated with the parent transaction (if this function is invoked in an existing transaction).
Note This function catches all throwables (including errors) to ensure proper transaction rollback and resource cleanup, even in exceptional circumstances.
Return
The final result of the statement block.
Parameters
Database to use for the transaction. Defaults to null.
Transaction isolation level. Defaults to db.transactionManager.defaultIsolationLevel.
Whether the transaction should be read-only. Defaults to db.transactionManager.defaultReadOnly.
Outer transaction if this is a nested transaction. Defaults to null.
Throws
If no database is available
If a database error occurs and retry attempts are exhausted
If any other error occurs during execution