public Class Settings

Implements org.jooq.util.jaxb.tools.XMLAppendable.appendTo.

Whether string literals should be escaped with backslash.

The default implementation of the ParsingConnection cache's LRU cache size.

Whether to activate the DiagnosticsConnection, explicit by DEFAULT, implicit if ON, or turned OFF entirely.

[#6771] Specifies whether DELETE statements are allowed to be executed lacking a WHERE clause.

The order of invocation for [action]start() methods registered org.jooq.ExecuteListeners.

Whether to fetch data into intermediate org.jooq.Result instances.

The default JDBC fetchSize property that should be applied to all jOOQ queries, for which no specific fetchSize value was specified.

[#7095] The base to use to calculate the powers of when applying in list padding.

The Locale to be used with any interpreter locale dependent logic, defaulting to getLocale().

The default JDBC maxRows property that should be applied to all jOOQ queries, for which no specific maxRows value was specified.

The order of invocation for [action]start() methods registered org.jooq.MigrationListeners.

The character(s) to be used as a separator in paths encoded in a Name

A few hierarchical mapping features work with paths encoded in names (specifically field aliases), such as the reflective mapping of nested values when aliasing fields as:

SELECT 
  a.first_name AS "book.author.firstName"
  a.last_name AS "book.author.lastName"
FROM ...

Specify how bind variables are to be rendered.

The date format to use when parsing functions whose behaviour depends on some session date format, such as NLS_DATE_FORMAT in Oracle

[#8325] The ignore comment start token

The Locale to be used with any parser locale dependent logic, defaulting to getLocale().

The prefix to use for named parameters in parsed SQL.

The timestamp format to use when parsing functions whose behaviour depends on some session date format, such as NLS_TIMESTAMP_FORMAT in Oracle

[#5917] Whether the parser should accept unsupported (but known) syntax.

The default JDBC poolable property that should be applied to all jOOQ queries, for which no specific poolable flag was specified.

[#9864] The behaviour when trying to insert into readonly columns using org.jooq.Insert statements, or the insert clause of a org.jooq.Merge statement.

[#9864] The behaviour when trying to update a readonly column using org.jooq.UpdatableRecord#update().

The order of invocation for [action]end() methods registered org.jooq.RecordListeners.

Whether the org.jooq.Nullability#DEFAULT nullablity should be rendered in generated DDL, and how it should be rendered.

The join type to be generated by implicit joins.

Whether the case of org.jooq.Keyword references should be modified in any way.

The Locale to be used with any render locale dependent logic (as e.g. transforming names to lower / uppper case), defaulting to getLocale().

Whether the case of org.jooq.Name references should be modified in any way.

Whether to render the optional AS keyword in table aliases, if it is optional in the output dialect.

Whether to render the optional INNER keyword in INNER JOIN, if it is optional in the output dialect.

Whether rendered schema, table, column names, etc should be quoted.

The type of statement that is to be executed.

The order of invocation for [action]end() methods registered org.jooq.TransactionListeners.

Transform GROUP BY [column index] clauses by substituting the column index.

Transform Common Table Expressions (CTE) by inlining their WITH clause definition to wherever they're referenced.

Transform ROWNUM expressions to corresponding LIMIT clauses or ROW_NUMBER() expressions.

Whether org.jooq.UpdatableRecord#update() calls should be executed if the record is unchanged.

The order of invocation for [action]start() methods registered org.jooq.VisitListeners.

[#7963] Apply workaround for ORA-04043 when inserting into Oracle tables with qualified, quoted identifiers, and fetching generated keys

Whether the java.time (JSR 310) type java.time.OffsetDateTime should be bound natively to JDBC.

Whether parsing connection translations should be cached in the configuration.

Whether record mappers should be cached in the configuration.

Whether to run the org.jooq.DiagnosticsListener#concatenationInPredicate(org.jooq.DiagnosticsContext) diagnostic.

Whether to run the org.jooq.DiagnosticsListener#duplicateStatements(org.jooq.DiagnosticsContext) diagnostic.

When set to true, this will add jOOQ's default logging DiagnosticsListeners.

Whether to run the org.jooq.DiagnosticsListener#nullConditoin(org.jooq.DiagnosticsContext) diagnostic.

Whether to run the org.jooq.DiagnosticsListener#possiblyWrongExpression(org.jooq.DiagnosticsContext) diagnostic.

Whether to run the org.jooq.DiagnosticsListener#tooManyColumnsFetched(org.jooq.DiagnosticsContext) diagnostic.

Whether to run the org.jooq.DiagnosticsListener#trivialCondition(org.jooq.DiagnosticsContext) diagnostic.

[#13418] Whether computed columns should be emulated in the client.

When set to true, this will add jOOQ's default org.jooq.tools.LoggerListener for debug logging.

Whether store() and delete() methods should be executed with optimistic locking.

Fetch trigger values after SQL Server OUTPUT clause.

Historically, zero-scale decimal types are generated as their most appropriate, corresponding integer type (e.g. NUMBER(2, 0) and less: Byte).

Whether org.jooq.TableRecord#insert() calls should be executed if the record is unchanged.

Whether constructor parameter names obtained via reflection in Java 8+ should be considered by the DefaultRecordMapper.

Whether constructor parameter names obtained from the java.beans.ConstructorProperties annotation should be considered by the DefaultRecordMapper.

Whether constructor parameter names obtained from the java.lang.Record component names should be considered by the DefaultRecordMapper.

The org.jooq.Meta implementation that is backed by java.sql.DatabaseMetaData does not produce system generated sequences, by default.

Whether to automatically existing schemas that are not yet managed by jOOQ Migrations.

Various migrateTo() methods (e.g. org.jooq.Meta#migrateTo(org.jooq.Meta)) ignore the difference between TIMESTAMP and TIMESTAMP(6), if 6 is the default precision for timestamps on the configured dialect.

[#8325] Whether the parser should ignore content between ignore comment tokens.

[#8469] Whether to parse default expressions retrieved from java.sql.DatabaseMetaData.

[#9780] Whether commands of the type SET key = value should be parsed rather than ignored.

Whether any catalog name should be rendered at all.

Whether rendered SQL should be pretty-printed.

Whether an additional ORDER BY rn clause should be rendered on emulated paginated queries.

Whether queries combined with set operators (e.g. UNION and UNION ALL) should always be surrounded by a parenthesis pair.

Whether a redundant (a <= :a) predicate should be rendered for a (a, b) < (:a, :b) predicate for the SEEK clause.

Whether stored function calls should be wrapped in scalar subqueries.

Whether emulations that require repeating expressions should render variables for those expressions in derived tables.

Whether calls to store(), insert() and update() should return values for columns that are org.jooq.DataType#computed().

Whether calls to store(), insert() and update() should return the identity column.

Transform ANSI join to table lists if possible.

Transform various syntax patterns to better versions, if possible.

Transform a + 1 = 2 to a = 2 - 1, and other transformations.

Transform bitwise operations to an equivalent BIT_GET(a, b) expression.

Transform ~(bitnor(x, y)) to bitor(x, y) and ~(bitor(x, y) to bitnor(x, y).

Transform ~(bitxnor(x, y)) to bitxor(x, y) and ~(bitxor(x, y) to bitxnor(x, y).

Transform CASE WHEN a IS NOT DISTINCT FROM b … to an equivalent DECODE function.

Transform CASE WHEN a THEN x WHEN b THEN y ELSE y END to CASE WHEN a THEN x ELSE y END.

Transform a searched CASE WHEN x = ..

Transform COUNT(1) or any other COUNT(const) to COUNT(*).

Transform empty scalar subqueries like (SELECT 1 WHERE FALSE) to NULL.

Flatten nested CASE abbreviations such as NVL or CASE.

Transform (EXP(x) - EXP(-x)) / 2 to SINH(x), and other transformations.

Transform LN(x + SQRT(SQUARE(x) + 1)) to ASINH(x), and other transformations.

Activate debug logging of the transformPatterns feature.

Transform x BETWEEN a AND b OR x BETWEEN b AND a to x BETWEEN SYMMETRIC a AND b.

Transform x = a OR x > a to x >= a.

Transform -(-(x)) to x

This transformation removes a redundant arithmetic negation.

Transform 2 argument COALESCE(a, b) to NVL(a, b).

Transform x IN (a) to x = a and x NOT IN (a) to x != a.

Transform NOT (a != b) to a = b, and similar comparisons.

Transform NOT (a IS NOT DISTINCT FROM b) to a IS DISTINCT FROM b.

Any {org.jooq.impl.QOM.UReturnsNullOnNullInput} function or expression with NULL arguments can be replaced by NULL.

Transform predicates comparing scalar subqueries with a count (SELECT COUNT(*) …) > 0 to equivalent EXISTS (SELECT 1 …).

Transform complex predicates into simpler CASE abbreviations.

Transform LTRIM(RTRIM(x)) or RTRIM(LTRIM(x)) to TRIM(x).

Transform trivial case abbreviations like NVL(NULL, a) to a.

Transform SELECT DISTINCT a, b FROM t GROUP BY a, b to SELECT a, b FROM t GROUP BY a, b.

Transform SELECT a, b FROM t GROUP BY a, a, b to SELECT a, b FROM t GROUP BY a, b.

Transform SELECT a, b FROM t ORDER BY a, a, b to SELECT a, b FROM t ORDER BY a, b.

Transform CASE by removing unreachable clauses.

Transform table lists to ANSI join if possible.

Whether store(), insert(), and update() methods should update the record timestamp prior to the operation, for use with executeWithOptimisticLocking.

Sets the value of the applyWorkaroundFor7962 property.

Whether string literals should be escaped with backslash.

Sets the value of the bindOffsetDateTimeType property.

Sets the value of the cacheParsingConnection property.

Sets the value of the cachePreparedStatementInLoader property.

Sets the value of the debugInfoOnStackTrace property.

Sets the value of the diagnosticsConcatenationInPredicate property.

Sets the value of the diagnosticsConsecutiveAggregation property.

Sets the value of the diagnosticsDuplicateStatementsUsingTransformPatterns property.

Sets the value of the diagnosticsMissingWasNullCall property.

Sets the value of the diagnosticsPatterns property.

Sets the value of the diagnosticsRepeatedStatements property.

Sets the value of the diagnosticsTooManyRowsFetched property.

Sets the value of the diagnosticsUnnecessaryWasNullCall property.

[#3884] How MULTISET support should be emulated.

[#6771] Specifies whether DELETE statements are allowed to be executed lacking a WHERE clause.

The order of invocation for [action]start() methods registered org.jooq.ExecuteListeners.

Sets the value of the executeLoggingSQLExceptions property.

Sets the value of the executeWithOptimisticLocking property.

Whether to fetch data into intermediate org.jooq.Result instances.

The default JDBC fetchSize property that should be applied to all jOOQ queries, for which no specific fetchSize value was specified.

Sets the value of the fetchWarnings property.

The maximum number of allowed bind variables before inlining all values where 0 uses the dialect defaults:

• org.jooq.SQLDialect#ACCESS : 768
• org.jooq.SQLDialect#ASE : 2000
• org.jooq.SQLDialect#INGRES : 1024
• org.jooq.SQLDialect#ORACLE : 32767
• org.jooq.SQLDialect#POSTGRES : 32767
• org.jooq.SQLDialect#SQLITE : 999
• org.jooq.SQLDialect#SQLSERVER : 2100

Sets the value of the inListPadding property.

Sets the value of the interpreterDelayForeignKeyDeclarations property.

The Locale to be used with any interpreter locale dependent logic, defaulting to getLocale().

Sets the value of the mapConstructorParameterNames property.

Sets the value of the mapConstructorPropertiesParameterNames property.

Sets the value of the mapRecordComponentParameterNames property.

Sets the value of the metaIncludeSystemIndexes property.

Sets the value of the migrationAllowsUndo property.

Sets the value of the migrationAutoValidation property.

The order of invocation for [action]end() methods registered org.jooq.MigrationListeners.

Sets the value of the migrationRevertUntracked property.

The character(s) to be used as a separator in paths encoded in a Name

A few hierarchical mapping features work with paths encoded in names (specifically field aliases), such as the reflective mapping of nested values when aliasing fields as:

SELECT 
  a.first_name AS "book.author.firstName"
  a.last_name AS "book.author.lastName"
FROM ...

Specify how bind variables are to be rendered.

The date format to use when parsing functions whose behaviour depends on some session date format, such as NLS_DATE_FORMAT in Oracle

Sets the value of the parseIgnoreComments property.

[#8325] The ignore comment stop token

The Locale to be used with any parser locale dependent logic, defaulting to getLocale().

[#7337] The default name case for parsed identifiers.

Sets the value of the parseRetainCommentsBetweenQueries property.

Sets the value of the parseSetCommands property.

[#7344] Whether the parser should accept unknown functions.

[#7163] Whether the parser should perform meta lookups in the Configuration's MetaProvider.

The default JDBC queryTimeout property that should be applied to all jOOQ queries, for which no specific queryTimeout was specified.

[#9864] The behaviour when trying to insert into readonly columns using org.jooq.TableRecord#insert().

[#9864] The behaviour when trying to update a readonly column using org.jooq.Update statements, or the update clause of a org.jooq.Merge statement.

The order of invocation for [action]start() methods registered org.jooq.RecordListeners.

Sets the value of the renderCatalog property.

Whether the org.jooq.Nullability#DEFAULT nullablity should be rendered in generated DDL, and how it should be rendered.

All sorts of formatting flags / settings.

The join type to be generated by implicit joins.

Whether the case of org.jooq.Keyword references should be modified in any way.

The Locale to be used with any render locale dependent logic (as e.g. transforming names to lower / uppper case), defaulting to getLocale().

Whether the case of org.jooq.Name references should be modified in any way.

Whether to render the optional AS keyword in table aliases, if it is optional in the output dialect.

Whether to render the optional INNER keyword in INNER JOIN, if it is optional in the output dialect.

Sets the value of the renderOrderByRownumberForEmulatedPagination property.

Sets the value of the renderParenthesisAroundSetOperationQueries property.

Whether rendered schema, table, column names, etc should be quoted.

Sets the value of the renderRowConditionForSeekClause property.

Sets the value of the renderSchema property.

Sets the value of the renderVariablesInDerivedTablesForEmulations property.

Sets the value of the returnComputedOnUpdatableRecord property.

Sets the value of the returnIdentityOnUpdatableRecord property.

The type of statement that is to be executed.

The order of invocation for [action]end() methods registered org.jooq.TransactionListeners.

Sets the value of the transformAnsiJoinToTableLists property.

Transform Common Table Expressions (CTE) by inlining their WITH clause definition to wherever they're referenced.

Sets the value of the transformPatternsAndNeToNotIn property.

Sets the value of the transformPatternsArithmeticExpressions property.

Sets the value of the transformPatternsBitNotBitNand property.

Sets the value of the transformPatternsBitNotBitNot property.

Sets the value of the transformPatternsBitSet property.

Sets the value of the transformPatternsCaseElseNull property.

Sets the value of the transformPatternsCaseMergeWhenWhen property.

Sets the value of the transformPatternsCaseToCaseAbbreviation property.

Sets the value of the transformPatternsDistinctFromNull property.

Sets the value of the transformPatternsFlattenCase property.

Sets the value of the transformPatternsFlattenDecode property.

Sets the value of the transformPatternsIdempotentFunctionRepetition property.

Sets the value of the transformPatternsLogarithmicFunctions property.

Sets the value of the transformPatternsMergeAndComparison property.

Sets the value of the transformPatternsMergeInLists property.