Transactional statements

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

In addition to using the transaction management API, which wraps JDBC or R2DBC transaction calls, it is possible to run explicit transactional statements directly as jOOQ org.jooq.Query:

• Either by executing the org.jooq.Query
• Or by embedding it in a procedural statement, such as e.g. a procedural block

All the standard SQL transactional statements are supported:

Table of contents

3.7.1.

START TRANSACTION statement (new)

3.7.2.

COMMIT statement (new)

3.7.3.

ROLLBACK statement (new)

3.7.4.

SAVEPOINT statement (new)

3.7.5.

RELEASE SAVEPOINT statement (new)