|The jOOQ User Manual. Multiple Pages : SQL building : The DSLContext API : Custom Settings : Object qualification||previous : next|
Available in ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
By default, jOOQ fully qualifies all objects with their catalog and schema names, if such qualification is made available by the code generator. For instance, the following SQL statement containing full qualification may be produced by jOOQ code with seemingly no qualification:
-- Full qualification on columns and tables SELECT catalog.schema.table.column FROM catalog.schema.table
DSL.using(configuration) .select(TABLE.COLUMN) // Column only qualified with table .from(TABLE) // No qualification on table
While the jOOQ code is also implicitly fully qualified (see implied imports), it may not be desireable to use fully qualified object names in SQL. The
renderSchema settings are used for this.
new Settings() .withRenderCatalog(false) // Defaults to true .withRenderSchema(false) // Defaults to true
More sophisticated multitenancy approaches are available through the render mapping feature.