New versions: Dev (3.16) | Latest (3.15)


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

The standard SQL way to raise exceptions is via the SIGNAL statement, which is supported natively in a few dialects, and can be emulated in some others.

Some example SIGNAL invocations.

begin(signalSQLState("45000").setMessageText("Custom message")).execute();


Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo