Available in versions: Dev (3.22)
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
Meta SQL on error
Supported by ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The JDBC java.sql.DatabaseMetaData backed org.jooq.Meta implementation runs a few auxiliary queries to fetch objects and meta information that JDBC cannot provide reliably. These include:
- Constraint meta data (e.g. constraint enforcement, deferrability)
- Check constraint meta data
- Comments
- Computed column meta data
- Identity meta data (e.g. additional sequence flags,
DEFAULTorALWAYSsemantics, etc.) - Object source code
- Sequence meta data
- Trigger meta data
- UDT attribute meta data
Some of these queries may fail due to missing grants, RDBMS version incompatibilities, etc. Using this setting, it is possible to handle failures related to these queries, including failure, logging, ignoring.
Example configuration
Settings settings = new Settings()
.withMetaSqlOnError(OnError.SILENT); // Defaults to OnError.FAIL
Feedback
Do you have any feedback about this page? We'd love to hear it!