Generated triggers
Applies to ❌ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
Every trigger in your database will generate an org.jooq.Trigger reference in a single Triggers class that looks like this:
public class Triggers {
/**
* The trigger <code>PUBLIC.LAST_UPDATED</code>.
*/
public static final Trigger LAST_UPDATED = Internal.createTrigger(
Public.PUBLIC,
Author.AUTHOR,
Arrays.asList(),
DSL.name("last_updated"),
DSL.comment(""),
TriggerTime.BEFORE,
EnumSet.of(TriggerEvent.UPDATE),
TriggerExecution.FOR_EACH_ROW,
null,
1,
DSL.statement("EXECUTE FUNCTION last_updated()")
);
}
These trigger specifications are referenced from all tables that use the respective trigger. Trigger meta data can be used for features like INSERT .. RETURNING, where some RDBMS require extra steps to fetch trigger generated values. If jOOQ knows there isn't a trigger on a table, then these steps can often be omitted.
Feedback
Do you have any feedback about this page? We'd love to hear it!