Uses of Class
org.jooq.conf.Settings

Packages that use Settings

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.conf
org.jooq.impl	This package contains jOOQ's implementation classes.
org.jooq.tools.jdbc	JDBC tooling.

Uses of Settings in org.jooq

Methods in org.jooq that return Settings

Modifier and Type	Method	Description
@NotNull Settings	Configuration.settings()	Retrieve the runtime configuration settings.
@NotNull Settings	DAO.settings()	The settings wrapped by this context.
@NotNull Settings	Scope.settings()	The settings wrapped by this context.

Methods in org.jooq with parameters of type Settings

Modifier and Type	Method	Description
@NotNull Configuration	Configuration.derive(Settings newSettings)	Create a derived configuration from this one, with new settings.
@NotNull Configuration	Configuration.set(Settings newSettings)	Change this configuration to hold a new settings.

Method parameters in org.jooq with type arguments of type Settings

Modifier and Type	Method	Description
@NotNull Configuration	Configuration.deriveSettings(Function<? super Settings,? extends Settings> newSettings)	Create a derived configuration from this one, with new settings constructed from a clone of the current settings.
@NotNull Configuration	Configuration.deriveSettings(Function<? super Settings,? extends Settings> newSettings)	Create a derived configuration from this one, with new settings constructed from a clone of the current settings.

Uses of Settings in org.jooq.conf

Methods in org.jooq.conf that return Settings

Modifier and Type	Method	Description
static final Settings	SettingsTools.clone(Settings settings)	Clone some settings.
Settings	ObjectFactory.createSettings()	Create an instance of Settings
static final Settings	SettingsTools.defaultSettings()	Retrieve the configured default settings.
Settings	Settings.withApplyWorkaroundFor7962(Boolean value)	[#7963] Apply workaround for ORA-04043 when inserting into Oracle tables with qualified, quoted identifiers, and fetching generated keys
Settings	Settings.withAttachRecords(Boolean value)	Whether fetched records should be attached to the fetching configuration.
Settings	Settings.withBackslashEscaping(BackslashEscaping value)	Whether string literals should be escaped with backslash.
Settings	Settings.withBatchSize(Integer value)	A property specifying a batch size that should be applied to all automatically created BatchedConnection instances.
Settings	Settings.withBindOffsetDateTimeType(Boolean value)	Whether the java.time (JSR 310) type OffsetDateTime should be bound natively to JDBC.
Settings	Settings.withBindOffsetTimeType(Boolean value)	Whether the java.time (JSR 310) type OffsetTime should be bound natively to JDBC.
Settings	Settings.withCacheParsingConnection(Boolean value)	Whether parsing connection translations should be cached in the configuration.
Settings	Settings.withCacheParsingConnectionLRUCacheSize(Integer value)	The default value of the ParsingConnection cache's LRU cache size.
Settings	Settings.withCachePreparedStatementInLoader(Boolean value)	Whether JDBC PreparedStatement instances should be cached in loader API.
Settings	Settings.withCacheRecordMappers(Boolean value)	Whether record mappers should be cached in the configuration.
Settings	Settings.withCacheRecordMappersLRUCacheSize(Integer value)	The default value of the RecordMapper cache's LRU cache size.
Settings	Settings.withComputedOnClientStored(Boolean value)	Whether STORED client side computed columns should be applied to queries (including audit columns).
Settings	Settings.withComputedOnClientVirtual(Boolean value)	Whether VIRTUAL client side computed columns should be applied to queries.
Settings	Settings.withDebugInfoOnStackTrace(Boolean value)	[#5570] Whether exception stack traces should be enhanced with additional debug information.
Settings	Settings.withDelimiter(String value)	[#5826] The delimiter character to be used to delimit statements in batches.
Settings	Settings.withDiagnosticsConcatenationInPredicate(Boolean value)	Whether to run the DiagnosticsListener.concatenationInPredicate(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withDiagnosticsConnection(DiagnosticsConnection value)	Whether to activate the DiagnosticsConnection, explicit by DEFAULT, implicit if ON, or turned OFF entirely.
Settings	Settings.withDiagnosticsConsecutiveAggregation(Boolean value)	Whether to run the DiagnosticsListener.consecutiveAggregation(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withDiagnosticsDuplicateStatements(Boolean value)	Whether to run the DiagnosticsListener.duplicateStatements(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withDiagnosticsDuplicateStatementsUsingTransformPatterns(Boolean value)	Whether to run the DiagnosticsListener.duplicateStatements(org.jooq.DiagnosticsContext) diagnostic with the transformPatterns feature activated.
Settings	Settings.withDiagnosticsLogging(Boolean value)	When set to true, this will add jOOQ's default logging DiagnosticsListeners.
Settings	Settings.withDiagnosticsMissingWasNullCall(Boolean value)	Whether to run the DiagnosticsListener.missingWasNullCall(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withDiagnosticsNullCondition(Boolean value)	Whether to run the invalid reference org.jooq.DiagnosticsListener#nullConditoin(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withDiagnosticsPatterns(Boolean value)	Whether to run the various pattern transformation diagnostics.
Settings	Settings.withDiagnosticsPossiblyWrongExpression(Boolean value)	Whether to run the DiagnosticsListener.possiblyWrongExpression(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withDiagnosticsRepeatedStatements(Boolean value)	Whether to run the DiagnosticsListener.repeatedStatements(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withDiagnosticsTooManyColumnsFetched(Boolean value)	Whether to run the DiagnosticsListener.tooManyColumnsFetched(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withDiagnosticsTooManyRowsFetched(Boolean value)	Whether to run the DiagnosticsListener.tooManyRowsFetched(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withDiagnosticsTrivialCondition(Boolean value)	Whether to run the DiagnosticsListener.trivialCondition(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withDiagnosticsUnnecessaryWasNullCall(Boolean value)	Whether to run the DiagnosticsListener.unnecessaryWasNullCall(org.jooq.DiagnosticsContext) diagnostic.
Settings	Settings.withEmulateComputedColumns(Boolean value)	[#13418] Whether computed columns should be emulated in the client.
Settings	Settings.withEmulateMultiset(NestedCollectionEmulation value)	[#3884] How MULTISET support should be emulated.
Settings	Settings.withEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value)	[#6462] Use only the primary key to emulate MySQL's INSERT ..
Settings	Settings.withExecuteDeleteWithoutWhere(ExecuteWithoutWhere value)	[#6771] Specifies whether DELETE statements are allowed to be executed lacking a WHERE clause.
Settings	Settings.withExecuteListenerEndInvocationOrder(InvocationOrder value)	The order of invocation for [action]end() methods registered ExecuteListeners.
Settings	Settings.withExecuteListenerStartInvocationOrder(InvocationOrder value)	The order of invocation for [action]start() methods registered ExecuteListeners.
Settings	Settings.withExecuteLogging(Boolean value)	When set to true, this will add jOOQ's default LoggerListener for debug logging.
Settings	Settings.withExecuteLoggingSQLExceptions(Boolean value)	[#14420] Whether constraint violations and other SQLException should produce additional log information about the column name and data causing the problem.
Settings	Settings.withExecuteUpdateWithoutWhere(ExecuteWithoutWhere value)	[#6771] Specifies whether UPDATE statements are allowed to be executed lacking a WHERE clause.
Settings	Settings.withExecuteWithOptimisticLocking(Boolean value)	Whether store() and delete() methods should be executed with optimistic locking.
Settings	Settings.withExecuteWithOptimisticLockingExcludeUnversioned(Boolean value)	Whether store() and delete() methods should be executed with optimistic locking also on "unversioned" tables, i.e.
Settings	Settings.withFetchIntermediateResult(FetchIntermediateResult value)	Whether to fetch data into intermediate Result instances.
Settings	Settings.withFetchServerOutputSize(Integer value)	Whether server output should be fetched after each query execution.
Settings	Settings.withFetchSize(Integer value)	The default JDBC fetchSize property that should be applied to all jOOQ queries, for which no specific fetchSize value was specified.
Settings	Settings.withFetchTriggerValuesAfterReturning(FetchTriggerValuesAfterReturning value)	Fetch trigger values after a RETURNING clause in dialects that don't have native support for this.
Settings	Settings.withFetchTriggerValuesAfterSQLServerOutput(Boolean value)	Deprecated. - 3.18.0 - [#13912] [#15316] - Use fetchTriggerValuesAfterReturning instead.
Settings	Settings.withFetchTrimmedCharValues(Boolean value)	Whether right trim fetched CHAR typed strings from JDBC ResultSet.
Settings	Settings.withFetchWarnings(Boolean value)	Whether warnings should be fetched after each query execution.
Settings	Settings.withForceIntegerTypesOnZeroScaleDecimals(Boolean value)	Historically, zero-scale decimal types are generated as their most appropriate, corresponding integer type (e.g.
Settings	Settings.withInlineThreshold(Integer value)	The maximum number of allowed bind variables before inlining all values where 0 uses the dialect defaults: SQLDialect.ACCESS : 768 SQLDialect.ASE : 2000 SQLDialect.INGRES : 1024 SQLDialect.ORACLE : 32767 SQLDialect.POSTGRES : 32767 SQLDialect.SQLITE : 999 SQLDialect.SQLSERVER : 2100 SQLDialect.TERADATA : 2536
Settings	Settings.withInListPadBase(Integer value)	[#7095] The base to use to calculate the powers of when applying in list padding.
Settings	Settings.withInListPadding(Boolean value)	[#5600] Whether IN lists in IN predicates should be padded to powers of inListPadBase (default 2).
Settings	Settings.withInsertUnchangedRecords(Boolean value)	Whether TableRecord.insert() calls should be executed if the record is unchanged.
Settings	Settings.withInterpreterDelayForeignKeyDeclarations(Boolean value)	Using this flag, the interpreter will be able to delay the addition of foreign key declarations until the end of the interpretation run.
Settings	Settings.withInterpreterDialect(SQLDialect value)	[#7337] The dialect that should be used to interpret SQL DDL statements.
Settings	Settings.withInterpreterLocale(Locale value)	The Locale to be used with any interpreter locale dependent logic, defaulting to getLocale().
Settings	Settings.withInterpreterNameLookupCaseSensitivity(InterpreterNameLookupCaseSensitivity value)	[#9633] The case sensitivity of identifiers used when interpreting SQL DDL statements.
Settings	Settings.withInterpreterSearchPath(Collection<InterpreterSearchSchema> values)
Settings	Settings.withInterpreterSearchPath(List<InterpreterSearchSchema> interpreterSearchPath)
Settings	Settings.withInterpreterSearchPath(InterpreterSearchSchema... values)
Settings	Settings.withLocale(Locale value)	The Locale to be used with any locale dependent logic if there is not a more specific locale available.
Settings	Settings.withMapConstructorParameterNames(Boolean value)	Whether constructor parameter names obtained via reflection in Java 8+ should be considered by the DefaultRecordMapper.
Settings	Settings.withMapConstructorParameterNamesInKotlin(Boolean value)	Whether constructor parameter names obtained via reflection in Kotlin should be considered by the DefaultRecordMapper.
Settings	Settings.withMapConstructorPropertiesParameterNames(Boolean value)	Whether constructor parameter names obtained from the ConstructorPropertiesProvider SPI (default implementation in the jOOQ-beans-extensions module) should be considered by the DefaultRecordMapper.
Settings	Settings.withMapJPAAnnotations(Boolean value)	Whether JPA annotations should be considered by the DefaultRecordMapper, assuming the jOOQ-jpa-extensions is on the classpath.
Settings	Settings.withMapRecordComponentParameterNames(Boolean value)	Whether constructor parameter names obtained from the Record component names should be considered by the DefaultRecordMapper.
Settings	Settings.withMaxRows(Integer value)	The default JDBC maxRows property that should be applied to all jOOQ queries, for which no specific maxRows value was specified.
Settings	Settings.withMetaIncludeSystemIndexes(Boolean value)	The Meta implementation that is backed by DatabaseMetaData does not produce system generated indexes on constraints, by default.
Settings	Settings.withMetaIncludeSystemSequences(Boolean value)	The Meta implementation that is backed by DatabaseMetaData does not produce system generated sequences, by default.
Settings	Settings.withMigrationAllowInvalidCommits(Boolean value)	Whether migrations to invalid commits (Commit.valid()) are allowed.
Settings	Settings.withMigrationAllowUndo(Boolean value)	Whether migrations are allowed to be executed in inverse order.
Settings	Settings.withMigrationAutoBaseline(Boolean value)	Whether to automatically existing schemas that are not yet managed by jOOQ Migrations.
Settings	Settings.withMigrationAutoVerification(Boolean value)	Whether a migration automatically runs a verification first.
Settings	Settings.withMigrationDefaultContentType(MigrationDefaultContentType value)	The default ContentType that is used when loading migrations.
Settings	Settings.withMigrationDefaultSchema(MigrationSchema value)	The default schema whose unqualified objects that are included in the migration.
Settings	Settings.withMigrationHistorySchema(MigrationSchema value)	The database schema where the migration history is located.
Settings	Settings.withMigrationHistorySchemaCreateSchemaIfNotExists(Boolean value)	Whether getMigrationHistorySchema() should be created if it doesn't exist.
Settings	Settings.withMigrationIgnoreDefaultTimestampPrecisionDiffs(Boolean value)	Various migrateTo() methods (e.g.
Settings	Settings.withMigrationIgnoreImplicitPrimaryKeyNotNullConstraints(Boolean value)	Various migrateTo() methods (e.g.
Settings	Settings.withMigrationIgnoreUnnamedConstraintDiffs(Boolean value)	Various migrateTo() methods (e.g.
Settings	Settings.withMigrationListenerEndInvocationOrder(InvocationOrder value)	The order of invocation for [action]end() methods registered MigrationListeners.
Settings	Settings.withMigrationListenerStartInvocationOrder(InvocationOrder value)	The order of invocation for [action]start() methods registered MigrationListeners.
Settings	Settings.withMigrationRevertUntracked(Boolean value)	Whether migrations revert any untracked changes in the schemas that are being migrated.
Settings	Settings.withMigrationSchemata(Collection<MigrationSchema> values)
Settings	Settings.withMigrationSchemata(List<MigrationSchema> migrationSchemata)
Settings	Settings.withMigrationSchemata(MigrationSchema... values)
Settings	Settings.withMigrationSchemataCreateSchemaIfNotExists(Boolean value)	Whether getMigrationSchemata() should be created if they don't exist.
Settings	Settings.withNamePathSeparator(String value)	The character(s) to be used as a separator in paths encoded in a invalid reference Name
Settings	Settings.withParamCastMode(ParamCastMode value)	Whether rendered bind values should be cast to their respective type.
Settings	Settings.withParamType(ParamType value)	Specify how bind variables are to be rendered.
Settings	Settings.withParseAppendMissingTableReferences(Transformation value)	Transform the parsed SQL to append missing table references to the query's FROM or USING clause, if applicable.
Settings	Settings.withParseDateFormat(String value)	The date format to use when parsing functions whose behaviour depends on some session date format, such as NLS_DATE_FORMAT in Oracle
Settings	Settings.withParseDialect(SQLDialect value)	[#7337] The input dialect that should be chosen to disambiguate ambiguous SQL syntax.
Settings	Settings.withParseIgnoreComments(Boolean value)	[#8325] Whether the parser should ignore content between ignore comment tokens.
Settings	Settings.withParseIgnoreCommentStart(String value)	[#8325] The ignore comment start token
Settings	Settings.withParseIgnoreCommentStop(String value)	[#8325] The ignore comment stop token
Settings	Settings.withParseIgnoreCommercialOnlyFeatures(Boolean value)	[#13109] Whether the parser of the jOOQ Open Source Edition should ignore commercial only features, rather than failing.
Settings	Settings.withParseLocale(Locale value)	The Locale to be used with any parser locale dependent logic, defaulting to getLocale().
Settings	Settings.withParseMetaDefaultExpressions(Boolean value)	[#8469] Whether to parse default expressions retrieved from DatabaseMetaData.
Settings	Settings.withParseMetaViewSources(Boolean value)	[#8469] Whether to parse view sources retrieved from DatabaseMetaData.
Settings	Settings.withParseNameCase(ParseNameCase value)	[#7337] The default name case for parsed identifiers.
Settings	Settings.withParseNamedParamPrefix(String value)	The prefix to use for named parameters in parsed SQL.
Settings	Settings.withParseRetainCommentsBetweenQueries(Boolean value)	[#12538] Whether the parser should retain comments and whitespace between queries when parsing multiple queries through Parser.parse(String).
Settings	Settings.withParseSearchPath(Collection<ParseSearchSchema> values)
Settings	Settings.withParseSearchPath(List<ParseSearchSchema> parseSearchPath)
Settings	Settings.withParseSearchPath(ParseSearchSchema... values)
Settings	Settings.withParseSetCommands(Boolean value)	[#9780] Whether commands of the type SET key = value should be parsed rather than ignored.
Settings	Settings.withParseTimestampFormat(String value)	The timestamp format to use when parsing functions whose behaviour depends on some session date format, such as NLS_TIMESTAMP_FORMAT in Oracle
Settings	Settings.withParseUnknownFunctions(ParseUnknownFunctions value)	[#7344] Whether the parser should accept unknown functions.
Settings	Settings.withParseUnsupportedSyntax(ParseUnsupportedSyntax value)	[#5917] Whether the parser should accept unsupported (but known) syntax.
Settings	Settings.withParseWithMetaLookups(ParseWithMetaLookups value)	[#7163] Whether the parser should perform meta lookups in the Configuration's MetaProvider.
Settings	Settings.withQueryPoolable(QueryPoolable value)	The default JDBC poolable property that should be applied to all jOOQ queries, for which no specific poolable flag was specified.
Settings	Settings.withQueryTimeout(Integer value)	The default JDBC queryTimeout property that should be applied to all jOOQ queries, for which no specific queryTimeout was specified.
Settings	Settings.withReadonlyInsert(WriteIfReadonly value)	[#9864] The behaviour when trying to insert into readonly columns using Insert statements, or the insert clause of a Merge statement.
Settings	Settings.withReadonlyTableRecordInsert(WriteIfReadonly value)	[#9864] The behaviour when trying to insert into readonly columns using TableRecord.insert().
Settings	Settings.withReadonlyUpdatableRecordUpdate(WriteIfReadonly value)	[#9864] The behaviour when trying to update a readonly column using UpdatableRecord.update().
Settings	Settings.withReadonlyUpdate(WriteIfReadonly value)	[#9864] The behaviour when trying to update a readonly column using Update statements, or the update clause of a Merge statement.
Settings	Settings.withRecordDirtyTracking(RecordDirtyTracking value)	Whether UpdatableRecord.store() and related calls should be based on Record.touched() or Record.modified() semantics.
Settings	Settings.withRecordListenerEndInvocationOrder(InvocationOrder value)	The order of invocation for [action]end() methods registered RecordListeners.
Settings	Settings.withRecordListenerStartInvocationOrder(InvocationOrder value)	The order of invocation for [action]start() methods registered RecordListeners.
Settings	Settings.withReflectionCacheLRUCacheSize(Integer value)	The default value of the reflection cache's LRU cache size.
Settings	Settings.withReflectionCaching(Boolean value)	Whether reflection information should be cached in the configuration.
Settings	Settings.withRenderAutoAliasedDerivedTableExpressions(AutoAliasExpressions value)	Whether to auto-alias expressions in derived tables.
Settings	Settings.withRenderCatalog(Boolean value)	Whether any catalog name should be rendered at all.
Settings	Settings.withRenderCoalesceToEmptyStringInConcat(Boolean value)	Whether string concatenation operands should be coalesced to empty strings.
Settings	Settings.withRenderDefaultNullability(RenderDefaultNullability value)	Whether the Nullability.DEFAULT nullablity should be rendered in generated DDL, and how it should be rendered.
Settings	Settings.withRenderDollarQuotedStringToken(String value)	The token to place between the $$ signs of a PostgreSQL dollar quoted string generated by jOOQ.
Settings	Settings.withRenderFormatted(Boolean value)	Whether rendered SQL should be pretty-printed.
Settings	Settings.withRenderFormatting(RenderFormatting value)	All sorts of formatting flags / settings.
Settings	Settings.withRenderGroupConcatMaxLenSessionVariable(Boolean value)	Whether the jOOQ GROUP_CONCAT function should be overflow-protected by setting the @@group_concat_max_len session variable in MySQL style database systems.
Settings	Settings.withRenderImplicitJoinToManyType(RenderImplicitJoinType value)	The join type to be generated by implicit joins for to-many paths in Select queries.
Settings	Settings.withRenderImplicitJoinType(RenderImplicitJoinType value)	The join type to be generated by implicit joins for to-one paths in Select queries.
Settings	Settings.withRenderImplicitWindowRange(RenderImplicitWindowRange value)	Whether to render an explicit window RANGE clause when an implicit clause is applied.
Settings	Settings.withRenderKeywordCase(RenderKeywordCase value)	Whether the case of Keyword references should be modified in any way.
Settings	Settings.withRenderKeywordStyle(RenderKeywordStyle value)	Deprecated. - 3.12.0 - [#5909] - Use RenderKeywordCase instead.
Settings	Settings.withRenderLocale(Locale value)	The Locale to be used with any render locale dependent logic (as e.g.
Settings	Settings.withRenderMapping(RenderMapping value)	Configure render mapping for runtime schema / table rewriting in generated SQL.
Settings	Settings.withRenderNameCase(RenderNameCase value)	Whether the case of Name references should be modified in any way.
Settings	Settings.withRenderNamedParamPrefix(String value)	The prefix to use for named parameters in generated SQL.
Settings	Settings.withRenderNameStyle(RenderNameStyle value)	Deprecated. - 3.12.0 - [#5909] - Use RenderQuotedNames and RenderNameCase instead.
Settings	Settings.withRenderNullifEmptyStringForBindValues(Boolean value)	Whether to wrap String typed bind values with NULLIF(?, '') for Oracle compatibility.
Settings	Settings.withRenderOptionalAsKeywordForFieldAliases(RenderOptionalKeyword value)	Whether to render the optional AS keyword in table aliases, if it is optional in the output dialect.
Settings	Settings.withRenderOptionalAsKeywordForTableAliases(RenderOptionalKeyword value)	Whether to render the optional AS keyword in table aliases, if it is optional in the output dialect.
Settings	Settings.withRenderOptionalAssociativityParentheses(RenderOptionalKeyword value)	Whether to render optional parentheses to make associativity explicit, e.g.
Settings	Settings.withRenderOptionalInnerKeyword(RenderOptionalKeyword value)	Whether to render the optional INNER keyword in INNER JOIN, if it is optional in the output dialect.
Settings	Settings.withRenderOptionalOuterKeyword(RenderOptionalKeyword value)	Whether to render the optional OUTER keyword in OUTER JOIN, if it is optional in the output dialect.
Settings	Settings.withRenderOrderByRownumberForEmulatedPagination(Boolean value)	Whether an additional ORDER BY rn clause should be rendered on emulated paginated queries.
Settings	Settings.withRenderOutputForSQLServerReturningClause(Boolean value)	Whether the jOOQ RETURNING clause should map to SQL Server's OUTPUT clause.
Settings	Settings.withRenderParenthesisAroundSetOperationQueries(Boolean value)	Whether queries combined with set operators (e.g.
Settings	Settings.withRenderPlainSQLTemplatesAsRaw(Boolean value)	Whether plain SQL templates (SQL) are rendered as raw string content.
Settings	Settings.withRenderQuotedNames(RenderQuotedNames value)	Whether rendered schema, table, column names, etc should be quoted.
Settings	Settings.withRenderRedundantConditionForSeekClause(Boolean value)	Whether a redundant (a invalid input: '<'= :a) predicate should be rendered for a (a, b) invalid input: '<' (:a, :b) predicate for the SEEK clause.
Settings	Settings.withRenderRowConditionForSeekClause(Boolean value)	Whether a (a, b) invalid input: '<' (:a, :b) row predicate should be rendered for the SEEK clause.
Settings	Settings.withRenderScalarSubqueriesForStoredFunctions(Boolean value)	Whether stored function calls should be wrapped in scalar subqueries.
Settings	Settings.withRenderSchema(Boolean value)	Whether any schema name should be rendered at all.
Settings	Settings.withRenderTable(RenderTable value)	Whether any table name qualification should be rendered at all on columns.
Settings	Settings.withRenderVariablesInDerivedTablesForEmulations(Boolean value)	Whether emulations that require repeating expressions should render variables for those expressions in derived tables.
Settings	Settings.withReturnAllOnUpdatableRecord(Boolean value)	Whether calls to store(), insert() and update() should return all columns, not just identity columns.
Settings	Settings.withReturnComputedOnUpdatableRecord(Boolean value)	Whether calls to store(), insert() and update() should return values for columns that are DataType.computed().
Settings	Settings.withReturnDefaultOnUpdatableRecord(Boolean value)	Whether calls to store(), insert() and update() should return values for columns that are DataType.defaulted().
Settings	Settings.withReturnIdentityOnUpdatableRecord(Boolean value)	Whether calls to store(), insert() and update() should return the identity column.
Settings	Settings.withReturnRecordToPojo(Boolean value)	Whether calls to store(), insert(), update(), and delete() that are called on an UpdatableRecord that is created from a POJO (e.g.
Settings	Settings.withStatementType(StatementType value)	The type of statement that is to be executed.
Settings	Settings.withThrowExceptions(ThrowExceptions value)	A strategy defining how exceptions from the database / JDBC driver should be propagated
Settings	Settings.withTransactionListenerEndInvocationOrder(InvocationOrder value)	The order of invocation for [action]end() methods registered TransactionListeners.
Settings	Settings.withTransactionListenerStartInvocationOrder(InvocationOrder value)	The order of invocation for [action]start() methods registered TransactionListeners.
Settings	Settings.withTransformAnsiJoinToTableLists(Boolean value)	Transform ANSI join to table lists if possible.
Settings	Settings.withTransformGroupByColumnIndex(Transformation value)	Transform GROUP BY [column index] clauses by substituting the column index.
Settings	Settings.withTransformInConditionSubqueryWithLimitToDerivedTable(Transformation value)	Deprecated. - 3.18.0 - [#14634] - The configuration of this transformation is deprecated.
Settings	Settings.withTransformInlineBindValuesForFieldComparisons(Boolean value)	Transform QOM.CompareCondition and a few other types of condition to inline their bind values, in case they match
Settings	Settings.withTransformInlineCTE(Transformation value)	Transform Common Table Expressions (CTE) by inlining their WITH clause definition to wherever they're referenced.
Settings	Settings.withTransformPatterns(Boolean value)	Transform various syntax patterns to better versions, if possible.
Settings	Settings.withTransformPatternsAndNeToNotIn(Boolean value)	Transform x != c1 AND x != c2 to x NOT IN (c1, c2).
Settings	Settings.withTransformPatternsArithmeticComparisons(Boolean value)	Transform a + 1 = 2 to a = 2 - 1, and other transformations.
Settings	Settings.withTransformPatternsArithmeticExpressions(Boolean value)	Transform 1 / y * x to x / y, and other transformations.
Settings	Settings.withTransformPatternsBitGet(Boolean value)	Transform bitwise operations to an equivalent BIT_GET(a, b) expression.
Settings	Settings.withTransformPatternsBitNotBitNand(Boolean value)	Transform ~(bitnand(x, y)) to bitand(x, y) and ~(bitand(x, y) to bitnand(x, y).
Settings	Settings.withTransformPatternsBitNotBitNor(Boolean value)	Transform ~(bitnor(x, y)) to bitor(x, y) and ~(bitor(x, y) to bitnor(x, y).
Settings	Settings.withTransformPatternsBitNotBitNot(Boolean value)	Transform ~(~(x)) to x.
Settings	Settings.withTransformPatternsBitNotBitXNor(Boolean value)	Transform ~(bitxnor(x, y)) to bitxor(x, y) and ~(bitxor(x, y) to bitxnor(x, y).
Settings	Settings.withTransformPatternsBitSet(Boolean value)	Transform bitwise operations to an equivalent BIT_SET(a, b) or BIT_SET(a, b, c) expression.
Settings	Settings.withTransformPatternsCaseDistinctToDecode(Boolean value)	Transform CASE WHEN a IS NOT DISTINCT FROM b … to an equivalent DECODE function.
Settings	Settings.withTransformPatternsCaseElseNull(Boolean value)	Transform CASE … ELSE NULL removing the ELSE clause.
Settings	Settings.withTransformPatternsCaseMergeWhenElse(Boolean value)	Transform CASE WHEN a THEN x WHEN b THEN y ELSE y END to CASE WHEN a THEN x ELSE y END.
Settings	Settings.withTransformPatternsCaseMergeWhenWhen(Boolean value)	Transform CASE WHEN a THEN x WHEN b THEN x END to CASE WHEN a OR b THEN x END.
Settings	Settings.withTransformPatternsCaseSearchedToCaseSimple(Boolean value)	Transform a searched CASE WHEN x = ..

Methods in org.jooq.conf that return types with arguments of type Settings

Modifier and Type	Method	Description
jakarta.xml.bind.JAXBElement<Settings>	ObjectFactory.createSettings(Settings value)	Create an instance of JAXBElement<Settings>

Methods in org.jooq.conf with parameters of type Settings

Modifier and Type	Method	Description
static final Settings	SettingsTools.clone(Settings settings)	Clone some settings.
jakarta.xml.bind.JAXBElement<Settings>	ObjectFactory.createSettings(Settings value)	Create an instance of JAXBElement<Settings>
static final boolean	SettingsTools.executePreparedStatements(Settings settings)	Whether a PreparedStatement should be executed.
static final boolean	SettingsTools.executeStaticStatements(Settings settings)	Whether static Statement should be executed.
static final BackslashEscaping	SettingsTools.getBackslashEscaping(Settings settings)	Get the value BackslashEscaping value.
static final int	SettingsTools.getBatchSize(Settings settings)	Return the specified getBatchSize().
static final ExecuteWithoutWhere	SettingsTools.getExecuteDeleteWithoutWhere(Settings settings)	Lazy access to getExecuteDeleteWithoutWhere().
static final ExecuteWithoutWhere	SettingsTools.getExecuteUpdateWithoutWhere(Settings settings)	Lazy access to getExecuteUpdateWithoutWhere().
static final int	SettingsTools.getFetchServerOutputSize(int fetchServerOutputSize, Settings settings)	Return fetchServerOutputSize if it is not 0, or the specified getFetchServerOutputSize().
static final int	SettingsTools.getFetchSize(int fetchSize, Settings settings)	Return fetchSize if it is not 0, or the specified getFetchSize().
static final int	SettingsTools.getMaxRows(int maxRows, Settings settings)	Return maxRows if it is not 0, or the specified getMaxRows().
static final ParamType	SettingsTools.getParamType(Settings settings)	Get the parameter type from the settings.
static final QueryPoolable	SettingsTools.getQueryPoolable(QueryPoolable poolable, Settings settings)	Return poolable if it is not null, or the specified getQueryPoolable().
static final int	SettingsTools.getQueryTimeout(int timeout, Settings settings)	Return timeout if it is not 0, or the specified getQueryTimeout().
static final RenderKeywordCase	SettingsTools.getRenderKeywordCase(Settings settings)	Backwards compatible access to RenderKeywordCase and/or RenderKeywordStyle (the latter being deprecated).
static final RenderMapping	SettingsTools.getRenderMapping(Settings settings)	Lazy access to RenderMapping.
static final RenderNameCase	SettingsTools.getRenderNameCase(Settings settings)	Backwards compatible access to RenderNameCase and/or RenderNameStyle (the latter being deprecated).
static final RenderQuotedNames	SettingsTools.getRenderQuotedNames(Settings settings)	Backwards compatible access to RenderQuotedNames and/or RenderNameStyle (the latter being deprecated).
static final RenderTable	SettingsTools.getRenderTable(Settings settings)	Lazy access to RenderTable.
static final StatementType	SettingsTools.getStatementType(Settings settings)	Get the statement type from the settings.
static final TransformUnneededArithmeticExpressions	SettingsTools.getTransformUnneededArithmeticExpressions(Settings settings)	Lazy access to getTransformUnneededArithmeticExpressions().
static final Locale	SettingsTools.interpreterLocale(Settings settings)	The interpreter locale that is applicable, or the default locale if no such locale is configured.
static final Locale	SettingsTools.locale(Settings settings)	The render locale that is applicable, or the default locale if no such locale is configured.
static final Locale	SettingsTools.parseLocale(Settings settings)	The parser locale that is applicable, or the default locale if no such locale is configured.
static final boolean	SettingsTools.parsingConnectionCaching(Settings settings)	Whether parsing connection caching is active.
static final boolean	SettingsTools.recordMapperCaching(Settings settings)	Whether record mapper caching is active.
static final boolean	SettingsTools.reflectionCaching(Settings settings)	Whether reflection caching is active.
static final Locale	SettingsTools.renderLocale(Settings settings)	The render locale that is applicable, or the default locale if no such locale is configured.
static final boolean	SettingsTools.returnAnyNonIdentityOnUpdatableRecord(Settings settings)	Whether any non-identity value should be returned on an UpdatableRecord operation.
static final boolean	SettingsTools.returnAnyOnUpdatableRecord(Settings settings)	Whether any value should be returned on an UpdatableRecord operation.
static final boolean	SettingsTools.updatablePrimaryKeys(Settings settings)	Whether primary keys should be updatable.

Uses of Settings in org.jooq.impl

Methods in org.jooq.impl that return Settings

Modifier and Type	Method	Description
Settings	DAOImpl.settings()
final Settings	DefaultConfiguration.settings()

Methods in org.jooq.impl with parameters of type Settings

Modifier and Type	Method	Description
final Configuration	DefaultConfiguration.derive(Settings newSettings)
final Configuration	DefaultConfiguration.set(Settings newSettings)
final void	DefaultConfiguration.setSettings(Settings newSettings)
static @NotNull DSLContext	DSL.using(io.r2dbc.spi.ConnectionFactory connectionFactory, SQLDialect dialect, Settings settings)	Create an executor with a custom R2DBC connection factory, a dialect and settings configured.
static @NotNull DSLContext	DSL.using(io.r2dbc.spi.Connection connection, SQLDialect dialect, Settings settings)	Create an executor with a custom R2DBC connection, a dialect and settings configured.
static @NotNull DSLContext	DSL.using(Connection connection, Settings settings)	Create an executor with a connection, a dialect and settings configured.
static @NotNull DSLContext	DSL.using(Connection connection, SQLDialect dialect, Settings settings)	Create an executor with a connection, a dialect and settings configured.
static @NotNull DSLContext	DSL.using(DataSource datasource, SQLDialect dialect, Settings settings)	Create an executor with a data source, a dialect and settings configured.
static @NotNull DSLContext	DSL.using(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings)	Create an executor with a custom connection provider, a dialect and settings configured.
static @NotNull DSLContext	DSL.using(SQLDialect dialect, Settings settings)	Create an executor with a dialect and settings configured.

Method parameters in org.jooq.impl with type arguments of type Settings

Modifier and Type	Method	Description
final Configuration	DefaultConfiguration.deriveSettings(Function<? super Settings,? extends Settings> newSettings)
final Configuration	DefaultConfiguration.deriveSettings(Function<? super Settings,? extends Settings> newSettings)

Constructors in org.jooq.impl with parameters of type Settings

Modifier	Constructor	Description
	DefaultCloseableDSLContext(io.r2dbc.spi.ConnectionFactory connectionFactory, SQLDialect dialect, Settings settings)
	DefaultCloseableDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings)
	DefaultDSLContext(io.r2dbc.spi.ConnectionFactory connectionFactory, SQLDialect dialect, Settings settings)
	DefaultDSLContext(Connection connection, SQLDialect dialect, Settings settings)
	DefaultDSLContext(DataSource datasource, SQLDialect dialect, Settings settings)
	DefaultDSLContext(ConnectionProvider connectionProvider, SQLDialect dialect, Settings settings)
	DefaultDSLContext(SQLDialect dialect, Settings settings)

Uses of Settings in org.jooq.tools.jdbc

Methods in org.jooq.tools.jdbc that return Settings

Modifier and Type	Method	Description
Settings	MockConfiguration.settings()

Methods in org.jooq.tools.jdbc with parameters of type Settings

Modifier and Type	Method	Description
Configuration	MockConfiguration.derive(Settings newSettings)
Configuration	MockConfiguration.set(Settings newSettings)

Method parameters in org.jooq.tools.jdbc with type arguments of type Settings

Modifier and Type	Method	Description
Configuration	MockConfiguration.deriveSettings(Function<? super Settings,? extends Settings> newSettings)
Configuration	MockConfiguration.deriveSettings(Function<? super Settings,? extends Settings> newSettings)