2K.Jooq Properties
2K.Jooq Properties
Properties about jooq.
2K.1.wings-jooq-conf-79.properties
The default switch for Jooq is,
wings.faceless.jooq.conf.auto-qualify
Boolean=true, whether to enable jooq auto qualify.
wings.faceless.jooq.conf.batch-mysql
Boolean=true, whether to use efficient mysql syntax when performing bulk inserts via Dao.
wings.faceless.jooq.conf.converter
Boolean=false, whether to inject global converters, recommended in Table.
wings.faceless.jooq.conf.journal-delete
Boolean=false, when deleting with commit_id, whether to update first and then delete.
wings.faceless.jooq.conf.listen-table-cud
Boolean=true, whether to listen to table's create/update/delete.
wings.faceless.jooq.conf.render-group-concat
Boolean=false, whether the jOOQ GROUP_CONCAT function should be overflow-protected by setting the @@group_concat_max_len session variable in MySQL style database
MySQL truncates <GROUP_CONCAT results after a certain length, which may be way too small for jOOQ's usage, especially when using the MULTISET emulation. By default, jOOQ sets a session variable to the highest possible value prior to executing a query containing GROUP_CONCAT. This flag can be used to opt out of this.
- https://github.com/jOOQ/jOOQ/issues/12092
- https://blog.jooq.org/mysqls-allowmultiqueries-flag-with-jdbc-and-jooq/
- https://www.jooq.org/doc/3.17/manual/sql-building/dsl-context/custom-settings/settings-group-concat/
wings.faceless.jooq.conf.render-catalog
Boolean=false, whether any catalog name should be rendered at all. Use this for single-catalog environments, or when all objects are made available using synonyms
wings.faceless.jooq.conf.render-schema
Boolean=false, whether any schema name should be rendered at all. Setting this to false also implicitly sets "renderCatalog" to false. Use this for single-schema environments, or when all objects are made available using synonyms
wings.faceless.jooq.conf.render-table
RenderTable=ALWAYS, should keep default. there are some issues jOOQ/jOOQ#8893.
2K.2.wings-jooq-cud-79.properties
CUD listener settings for jooq.
wings.faceless.jooq.cud.create
Boolean=true, Whether to listen to create
wings.faceless.jooq.cud.update
Boolean=true, Whether to listen to update
wings.faceless.jooq.cud.delete
Boolean=true, Whether to listen to delete
wings.faceless.jooq.cud.table
Map<String, Set<String>>, Listening tables and their fields.
CUD listens to tables and fields, both tables and fields are case-sensitive, default,
win_order=id,order_num
wings.faceless.jooq.cud.diff
Map<String, Set<String>>, default fields to be ignored by JournalDiff.
Tables are case-sensitive, fields are case-insensitive, default means all tables, otherwise specific tables.
default=create_dt,modify_dt,delete_dt,commit_id
