Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
Matching schemas
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The following example shows how to define a MatcherStrategy for generated org.jooq.Schema types and related objects:
<configuration>
<!-- These properties can be added directly to the generator element: -->
<generator>
<strategy>
<matchers>
<!-- Specify 0..n schema matchers to provide a strategy for naming objects created from schemas. -->
<schemas>
<schema>
<!-- Match unqualified or qualified schema names. If left empty, this matcher applies to all schemas. -->
<expression>MY_SCHEMA</expression>
<!-- These elements influence the naming of a generated org.jooq.Schema object. -->
<schemaClass> a MatcherRule specification </schemaClass>
<schemaIdentifier> a MatcherRule specification </schemaIdentifier>
<schemaExtends>com.example.MyOptionalSchemaBaseType</schemaExtends>
<schemaImplements>com.example.MyOptionalCustomInterface</schemaImplements>
</schema>
</schemas>
</matchers>
</strategy>
</generator>
</configuration>
See the configuration XSD, standalone code generation, and maven code generation for more details.
new org.jooq.meta.jaxb.Configuration()
// These properties can be added directly to the generator element:
.withGenerator(new Generator()
.withStrategy(new Strategy()
.withMatchers(new Matchers()
// Specify 0..n schema matchers to provide a strategy for naming objects created from schemas.
.withSchemas(
new MatchersSchemaType()
// Match unqualified or qualified schema names. If left empty, this matcher applies to all schemas.
.withExpression("MY_SCHEMA")
// These elements influence the naming of a generated org.jooq.Schema object.
.withSchemaClass(MatcherRule. a MatcherRule specification )
.withSchemaIdentifier(MatcherRule. a MatcherRule specification )
.withSchemaExtends("com.example.MyOptionalSchemaBaseType")
.withSchemaImplements("com.example.MyOptionalCustomInterface")
)
)
)
)
See the configuration XSD and programmatic code generation for more details.
import org.jooq.meta.jaxb.*
configuration {
// These properties can be added directly to the generator element:
generator {
strategy {
matchers {
// Specify 0..n schema matchers to provide a strategy for naming objects created from schemas.
schemas {
schema {
// Match unqualified or qualified schema names. If left empty, this matcher applies to all schemas.
expression = "MY_SCHEMA"
// These elements influence the naming of a generated org.jooq.Schema object.
schemaClass = MatcherRule. a MatcherRule specification
schemaIdentifier = MatcherRule. a MatcherRule specification
schemaExtends = "com.example.MyOptionalSchemaBaseType"
schemaImplements = "com.example.MyOptionalCustomInterface"
}
}
}
}
}
}
See the configuration XSD and gradle code generation for more details.
configuration {
// These properties can be added directly to the generator element:
generator {
strategy {
matchers {
// Specify 0..n schema matchers to provide a strategy for naming objects created from schemas.
schemas {
schema {
// Match unqualified or qualified schema names. If left empty, this matcher applies to all schemas.
expression = "MY_SCHEMA"
// These elements influence the naming of a generated org.jooq.Schema object.
schemaClass = " a MatcherRule specification "
schemaIdentifier = " a MatcherRule specification "
schemaExtends = "com.example.MyOptionalSchemaBaseType"
schemaImplements = "com.example.MyOptionalCustomInterface"
}
}
}
}
}
}
See the configuration XSD and gradle code generation for more details.
generationTool {
// These properties can be added directly to the generator element:
generator {
strategy {
matchers {
// Specify 0..n schema matchers to provide a strategy for naming objects created from schemas.
schemas {
schema {
// Match unqualified or qualified schema names. If left empty, this matcher applies to all schemas.
expression = "MY_SCHEMA"
// These elements influence the naming of a generated org.jooq.Schema object.
schemaClass = " a MatcherRule specification "
schemaIdentifier = " a MatcherRule specification "
schemaExtends = "com.example.MyOptionalSchemaBaseType"
schemaImplements = "com.example.MyOptionalCustomInterface"
}
}
}
}
}
}
See the configuration XSD and gradle code generation for more details.
As always, when regular expressions are used, they are regular expressions with default flags.
When using anyschemaExtends, etc. setting, you must make sure to correctly implement the internal jOOQ APIs, which are not documented here for they are internal. In particular, if you're extendingorg.jooq.impl.TableImpl, for example, your custom base class may break between minor versions of jOOQ, as new constructors are added.
See MatcherRule for more information about MatcherRule specifications.
Feedback
Do you have any feedback about this page? We'd love to hear it!