- java.lang.Object
- 
- org.jooq.conf.Settings
 
- 
- All Implemented Interfaces:
- Serializable,- Cloneable,- XMLAppendable
 
 public class Settings extends Object implements Serializable, Cloneable, XMLAppendable Settings that influence the way jOOQ renders SQL code.- See Also:
- Serialized Form
 
- 
- 
Field Summary
 - 
Constructor SummaryConstructors Constructor Description Settings()
 - 
Method SummaryAll Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description voidappendTo(XMLBuilder builder)Objectclone()booleanequals(Object that)BackslashEscapinggetBackslashEscaping()Whether string literals should be escaped with backslash.IntegergetBatchSize()A property specifying a batch size that should be applied to all automatically createdBatchedConnectioninstances.StringgetDelimiter()[#5826] The delimiter character to be used to delimit statements in batches.ExecuteWithoutWheregetExecuteDeleteWithoutWhere()[#6771] Specifies whether DELETE statements are allowed to be executed lacking a WHERE clause.InvocationOrdergetExecuteListenerEndInvocationOrder()The order of invocation for [action]end() methods registeredExecuteListeners.InvocationOrdergetExecuteListenerStartInvocationOrder()The order of invocation for [action]start() methods registeredExecuteListeners.ExecuteWithoutWheregetExecuteUpdateWithoutWhere()[#6771] Specifies whether UPDATE statements are allowed to be executed lacking a WHERE clause.IntegergetFetchServerOutputSize()Whether server output should be fetched after each query execution.IntegergetFetchSize()The default JDBC fetchSize property that should be applied to all jOOQ queries, for which no specific fetchSize value was specified.IntegergetInlineThreshold()The maximum number of allowed bind variables before inlining all values where0uses the dialect defaults:SQLDialect.ACCESS: 768SQLDialect.ASE: 2000SQLDialect.INGRES: 1024SQLDialect.ORACLE: 32767SQLDialect.POSTGRES: 32767SQLDialect.SQLITE: 999SQLDialect.SQLSERVER: 2100IntegergetInListPadBase()[#7095] The base to use to calculate the powers of when applying in list padding.SQLDialectgetInterpreterDialect()[#7337] The dialect that should be used to interpret SQL DDL statements.LocalegetInterpreterLocale()The Locale to be used with any interpreter locale dependent logic, defaulting togetLocale().InterpreterNameLookupCaseSensitivitygetInterpreterNameLookupCaseSensitivity()[#9633] The case sensitivity of identifiers used when interpreting SQL DDL statements.List<InterpreterSearchSchema>getInterpreterSearchPath()LocalegetLocale()The Locale to be used with any locale dependent logic if there is not a more specific locale available.IntegergetMaxRows()The default JDBC maxRows property that should be applied to all jOOQ queries, for which no specific maxRows value was specified.InvocationOrdergetMigrationListenerEndInvocationOrder()The order of invocation for [action]end() methods registeredMigrationListeners.InvocationOrdergetMigrationListenerStartInvocationOrder()The order of invocation for [action]start() methods registeredMigrationListeners.ParamCastModegetParamCastMode()Whether rendered bind values should be cast to their respective type.ParamTypegetParamType()Specify how bind variables are to be rendered.SQLDialectgetParseDialect()[#7337] The input dialect that should be chosen to disambiguate ambiguous SQL syntax.StringgetParseIgnoreCommentStart()[#8325] The ignore comment start tokenStringgetParseIgnoreCommentStop()[#8325] The ignore comment stop tokenLocalegetParseLocale()The Locale to be used with any parser locale dependent logic, defaulting togetLocale().ParseNameCasegetParseNameCase()[#7337] The default name case for parsed identifiers.List<ParseSearchSchema>getParseSearchPath()ParseUnknownFunctionsgetParseUnknownFunctions()[#7344] Whether the parser should accept unknown functions.ParseUnsupportedSyntaxgetParseUnsupportedSyntax()[#5917] Whether the parser should accept unsupported (but known) syntax.ParseWithMetaLookupsgetParseWithMetaLookups()[#7163] Whether the parser should perform meta lookups in the Configuration's MetaProvider.QueryPoolablegetQueryPoolable()The default JDBC poolable property that should be applied to all jOOQ queries, for which no specific poolable flag was specified.IntegergetQueryTimeout()The default JDBC queryTimeout property that should be applied to all jOOQ queries, for which no specific queryTimeout was specified.InvocationOrdergetRecordListenerEndInvocationOrder()The order of invocation for [action]end() methods registeredRecordListeners.InvocationOrdergetRecordListenerStartInvocationOrder()The order of invocation for [action]start() methods registeredRecordListeners.RenderFormattinggetRenderFormatting()All sorts of formatting flags / settings.RenderImplicitJoinTypegetRenderImplicitJoinType()The join type to be generated by implicit joins.RenderKeywordCasegetRenderKeywordCase()Whether the case ofKeywordreferences should be modified in any way.RenderKeywordStylegetRenderKeywordStyle()Deprecated.- 3.12.0 - [#5909] - UseRenderKeywordCaseinstead.LocalegetRenderLocale()The Locale to be used with any render locale dependent logic (as e.g.RenderMappinggetRenderMapping()Configure render mapping for runtime schema / table rewriting in generated SQL.RenderNameCasegetRenderNameCase()Whether the case ofNamereferences should be modified in any way.StringgetRenderNamedParamPrefix()The prefix to use for named parameters.RenderNameStylegetRenderNameStyle()Deprecated.- 3.12.0 - [#5909] - UseRenderQuotedNamesandRenderNameCaseinstead.RenderOptionalKeywordgetRenderOptionalAsKeywordForFieldAliases()Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect.RenderOptionalKeywordgetRenderOptionalAsKeywordForTableAliases()Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect.RenderOptionalKeywordgetRenderOptionalInnerKeyword()Whether to render the optionalINNERkeyword inINNER JOIN, if it is optional in the output dialect.RenderOptionalKeywordgetRenderOptionalOuterKeyword()Whether to render the optionalOUTERkeyword inOUTER JOIN, if it is optional in the output dialect.RenderQuotedNamesgetRenderQuotedNames()Whether rendered schema, table, column names, etc should be quoted.StatementTypegetStatementType()The type of statement that is to be executed.ThrowExceptionsgetThrowExceptions()A strategy defining how exceptions from the database / JDBC driver should be propagatedInvocationOrdergetTransactionListenerEndInvocationOrder()The order of invocation for [action]end() methods registeredTransactionListeners.InvocationOrdergetTransactionListenerStartInvocationOrder()The order of invocation for [action]start() methods registeredTransactionListeners.TransformUnneededArithmeticExpressionsgetTransformUnneededArithmeticExpressions()Transform arithmetic expressions on literals and bind variables.UpdateUnchangedRecordsgetUpdateUnchangedRecords()WhetherUpdatableRecord.update()calls should be executed if the record is unchanged.InvocationOrdergetVisitListenerEndInvocationOrder()The order of invocation for [action]end() methods registeredVisitListeners.InvocationOrdergetVisitListenerStartInvocationOrder()The order of invocation for [action]start() methods registeredVisitListeners.inthashCode()BooleanisApplyWorkaroundFor7962()[#7963] Apply workaround for ORA-04043 when inserting into Oracle tables with qualified, quoted identifiers, and fetching generated keysBooleanisAttachRecords()Whether fetched records should be attached to the fetching configuration.BooleanisBindOffsetDateTimeType()Whether thejava.time(JSR 310) typeOffsetDateTimeshould be bound natively to JDBC.BooleanisBindOffsetTimeType()Whether thejava.time(JSR 310) typeOffsetTimeshould be bound natively to JDBC.BooleanisCachePreparedStatementInLoader()Whether JDBCPreparedStatementinstances should be cached in loader API.BooleanisCacheRecordMappers()Whether record mappers should be cached in the configuration.BooleanisDebugInfoOnStackTrace()[#5570] Whether exception stack traces should be enhanced with additional debug information.BooleanisEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly()[#6462] Use only the primary key to emulate MySQL's INSERT ..BooleanisExecuteLogging()When set to true, this will add jOOQ's default logging ExecuteListeners.BooleanisExecuteWithOptimisticLocking()Whether store() and delete() methods should be executed with optimistic locking.BooleanisExecuteWithOptimisticLockingExcludeUnversioned()Whether store() and delete() methods should be executed with optimistic locking also on "unversioned" tables, i.e.BooleanisFetchTriggerValuesAfterSQLServerOutput()Fetch trigger values after SQL ServerOUTPUTclause.BooleanisFetchWarnings()Whether warnings should be fetched after each query execution.BooleanisForceIntegerTypesOnZeroScaleDecimals()Historically, zero-scale decimal types are generated as their most appropriate, corresponding integer type (e.g.BooleanisInListPadding()[#5600] Whether IN lists in IN predicates should be padded to powers of inListPadBase (default 2).BooleanisInsertUnchangedRecords()WhetherTableRecord.insert()calls should be executed if the record is unchanged.BooleanisInterpreterDelayForeignKeyDeclarations()Using this flag, the interpreter will be able to delay the addition of foreign key declarations until the end of the interpretation run.BooleanisMapConstructorParameterNames()Whether constructor parameter names obtained via reflection in Java 8+ should be considered by the DefaultRecordMapper.BooleanisMapConstructorParameterNamesInKotlin()Whether constructor parameter names obtained via reflection in Kotlin should be considered by the DefaultRecordMapper.BooleanisMapJPAAnnotations()Whether JPA annotations should be considered by the DefaultRecordMapper.BooleanisMigrationAllowsUndo()Whether migrations are allowed to be executed in inverse order.BooleanisMigrationAutoValidation()Whether a migration automatically runs a validation first.BooleanisMigrationRevertUntracked()Whether migrations revert any untracked changes in the schemas that are being migrated.BooleanisParseIgnoreComments()[#8325] Whether the parser should ignore content between ignore comment tokens.BooleanisParseSetCommands()[#9780] Whether commands of the typeSET key = valueshould be parsed rather than ignored.BooleanisReflectionCaching()Whether reflection information should be cached in the configuration.BooleanisRenderCatalog()Whether any catalog name should be rendered at all.BooleanisRenderFormatted()Whether rendered SQL should be pretty-printed.BooleanisRenderOrderByRownumberForEmulatedPagination()Whether an additionalORDER BY rnclause should be rendered on emulated paginated queries.BooleanisRenderOutputForSQLServerReturningClause()Whether the jOOQRETURNINGclause should map to SQL Server'sOUTPUTclause.BooleanisRenderParenthesisAroundSetOperationQueries()Whether queries combined with set operators (e.g.BooleanisRenderScalarSubqueriesForStoredFunctions()Whether stored function calls should be wrapped in scalar subqueries.BooleanisRenderSchema()Whether any schema name should be rendered at all.BooleanisReturnAllOnUpdatableRecord()Whether calls to store(), insert() and update() should return all columns, not just identity columns.BooleanisReturnIdentityOnUpdatableRecord()Whether calls to store(), insert() and update() should return the identity column.BooleanisReturnRecordToPojo()Whether calls to store(), insert(), update(), and delete() that are called on an UpdatableRecord that is created from a POJO (e.g.BooleanisTransformAnsiJoinToTableLists()Transform ANSI join to table lists if possible.BooleanisTransformRownum()TransformROWNUMexpressions to correspondingLIMITclauses orROW_NUMBER()expressions.BooleanisTransformTableListsToAnsiJoin()Transform table lists to ANSI join if possible.BooleanisUpdatablePrimaryKeys()Whether primary key values are deemed to be "updatable" in jOOQ.BooleanisUpdateRecordTimestamp()Whether store(), insert(), and update() methods should update the record timestamp prior to the operation, for use withexecuteWithOptimisticLocking.BooleanisUpdateRecordVersion()Whether store(), insert(), and update() methods should update the record version prior to the operation, for use withexecuteWithOptimisticLocking.voidsetApplyWorkaroundFor7962(Boolean value)Sets the value of the applyWorkaroundFor7962 property.voidsetAttachRecords(Boolean value)Sets the value of the attachRecords property.voidsetBackslashEscaping(BackslashEscaping value)Whether string literals should be escaped with backslash.voidsetBatchSize(Integer value)A property specifying a batch size that should be applied to all automatically createdBatchedConnectioninstances.voidsetBindOffsetDateTimeType(Boolean value)Sets the value of the bindOffsetDateTimeType property.voidsetBindOffsetTimeType(Boolean value)Sets the value of the bindOffsetTimeType property.voidsetCachePreparedStatementInLoader(Boolean value)Sets the value of the cachePreparedStatementInLoader property.voidsetCacheRecordMappers(Boolean value)Sets the value of the cacheRecordMappers property.voidsetDebugInfoOnStackTrace(Boolean value)Sets the value of the debugInfoOnStackTrace property.voidsetDelimiter(String value)[#5826] The delimiter character to be used to delimit statements in batches.voidsetEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value)Sets the value of the emulateOnDuplicateKeyUpdateOnPrimaryKeyOnly property.voidsetExecuteDeleteWithoutWhere(ExecuteWithoutWhere value)[#6771] Specifies whether DELETE statements are allowed to be executed lacking a WHERE clause.voidsetExecuteListenerEndInvocationOrder(InvocationOrder value)The order of invocation for [action]end() methods registeredExecuteListeners.voidsetExecuteListenerStartInvocationOrder(InvocationOrder value)The order of invocation for [action]start() methods registeredExecuteListeners.voidsetExecuteLogging(Boolean value)Sets the value of the executeLogging property.voidsetExecuteUpdateWithoutWhere(ExecuteWithoutWhere value)[#6771] Specifies whether UPDATE statements are allowed to be executed lacking a WHERE clause.voidsetExecuteWithOptimisticLocking(Boolean value)Sets the value of the executeWithOptimisticLocking property.voidsetExecuteWithOptimisticLockingExcludeUnversioned(Boolean value)Sets the value of the executeWithOptimisticLockingExcludeUnversioned property.voidsetFetchServerOutputSize(Integer value)Whether server output should be fetched after each query execution.voidsetFetchSize(Integer value)The default JDBC fetchSize property that should be applied to all jOOQ queries, for which no specific fetchSize value was specified.voidsetFetchTriggerValuesAfterSQLServerOutput(Boolean value)Sets the value of the fetchTriggerValuesAfterSQLServerOutput property.voidsetFetchWarnings(Boolean value)Sets the value of the fetchWarnings property.voidsetForceIntegerTypesOnZeroScaleDecimals(Boolean value)Sets the value of the forceIntegerTypesOnZeroScaleDecimals property.voidsetInlineThreshold(Integer value)The maximum number of allowed bind variables before inlining all values where0uses the dialect defaults:SQLDialect.ACCESS: 768SQLDialect.ASE: 2000SQLDialect.INGRES: 1024SQLDialect.ORACLE: 32767SQLDialect.POSTGRES: 32767SQLDialect.SQLITE: 999SQLDialect.SQLSERVER: 2100voidsetInListPadBase(Integer value)[#7095] The base to use to calculate the powers of when applying in list padding.voidsetInListPadding(Boolean value)Sets the value of the inListPadding property.voidsetInsertUnchangedRecords(Boolean value)Sets the value of the insertUnchangedRecords property.voidsetInterpreterDelayForeignKeyDeclarations(Boolean value)Sets the value of the interpreterDelayForeignKeyDeclarations property.voidsetInterpreterDialect(SQLDialect value)[#7337] The dialect that should be used to interpret SQL DDL statements.voidsetInterpreterLocale(Locale value)The Locale to be used with any interpreter locale dependent logic, defaulting togetLocale().voidsetInterpreterNameLookupCaseSensitivity(InterpreterNameLookupCaseSensitivity value)[#9633] The case sensitivity of identifiers used when interpreting SQL DDL statements.voidsetInterpreterSearchPath(List<InterpreterSearchSchema> interpreterSearchPath)voidsetLocale(Locale value)The Locale to be used with any locale dependent logic if there is not a more specific locale available.voidsetMapConstructorParameterNames(Boolean value)Sets the value of the mapConstructorParameterNames property.voidsetMapConstructorParameterNamesInKotlin(Boolean value)Sets the value of the mapConstructorParameterNamesInKotlin property.voidsetMapJPAAnnotations(Boolean value)Sets the value of the mapJPAAnnotations property.voidsetMaxRows(Integer value)The default JDBC maxRows property that should be applied to all jOOQ queries, for which no specific maxRows value was specified.voidsetMigrationAllowsUndo(Boolean value)Sets the value of the migrationAllowsUndo property.voidsetMigrationAutoValidation(Boolean value)Sets the value of the migrationAutoValidation property.voidsetMigrationListenerEndInvocationOrder(InvocationOrder value)The order of invocation for [action]end() methods registeredMigrationListeners.voidsetMigrationListenerStartInvocationOrder(InvocationOrder value)The order of invocation for [action]start() methods registeredMigrationListeners.voidsetMigrationRevertUntracked(Boolean value)Sets the value of the migrationRevertUntracked property.voidsetParamCastMode(ParamCastMode value)Whether rendered bind values should be cast to their respective type.voidsetParamType(ParamType value)Specify how bind variables are to be rendered.voidsetParseDialect(SQLDialect value)[#7337] The input dialect that should be chosen to disambiguate ambiguous SQL syntax.voidsetParseIgnoreComments(Boolean value)Sets the value of the parseIgnoreComments property.voidsetParseIgnoreCommentStart(String value)[#8325] The ignore comment start tokenvoidsetParseIgnoreCommentStop(String value)[#8325] The ignore comment stop tokenvoidsetParseLocale(Locale value)The Locale to be used with any parser locale dependent logic, defaulting togetLocale().voidsetParseNameCase(ParseNameCase value)[#7337] The default name case for parsed identifiers.voidsetParseSearchPath(List<ParseSearchSchema> parseSearchPath)voidsetParseSetCommands(Boolean value)Sets the value of the parseSetCommands property.voidsetParseUnknownFunctions(ParseUnknownFunctions value)[#7344] Whether the parser should accept unknown functions.voidsetParseUnsupportedSyntax(ParseUnsupportedSyntax value)[#5917] Whether the parser should accept unsupported (but known) syntax.voidsetParseWithMetaLookups(ParseWithMetaLookups value)[#7163] Whether the parser should perform meta lookups in the Configuration's MetaProvider.voidsetQueryPoolable(QueryPoolable value)The default JDBC poolable property that should be applied to all jOOQ queries, for which no specific poolable flag was specified.voidsetQueryTimeout(Integer value)The default JDBC queryTimeout property that should be applied to all jOOQ queries, for which no specific queryTimeout was specified.voidsetRecordListenerEndInvocationOrder(InvocationOrder value)The order of invocation for [action]end() methods registeredRecordListeners.voidsetRecordListenerStartInvocationOrder(InvocationOrder value)The order of invocation for [action]start() methods registeredRecordListeners.voidsetReflectionCaching(Boolean value)Sets the value of the reflectionCaching property.voidsetRenderCatalog(Boolean value)Sets the value of the renderCatalog property.voidsetRenderFormatted(Boolean value)Sets the value of the renderFormatted property.voidsetRenderFormatting(RenderFormatting value)All sorts of formatting flags / settings.voidsetRenderImplicitJoinType(RenderImplicitJoinType value)The join type to be generated by implicit joins.voidsetRenderKeywordCase(RenderKeywordCase value)Whether the case ofKeywordreferences should be modified in any way.voidsetRenderKeywordStyle(RenderKeywordStyle value)Deprecated.- 3.12.0 - [#5909] - UseRenderKeywordCaseinstead.voidsetRenderLocale(Locale value)The Locale to be used with any render locale dependent logic (as e.g.voidsetRenderMapping(RenderMapping value)Configure render mapping for runtime schema / table rewriting in generated SQL.voidsetRenderNameCase(RenderNameCase value)Whether the case ofNamereferences should be modified in any way.voidsetRenderNamedParamPrefix(String value)The prefix to use for named parameters.voidsetRenderNameStyle(RenderNameStyle value)Deprecated.- 3.12.0 - [#5909] - UseRenderQuotedNamesandRenderNameCaseinstead.voidsetRenderOptionalAsKeywordForFieldAliases(RenderOptionalKeyword value)Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect.voidsetRenderOptionalAsKeywordForTableAliases(RenderOptionalKeyword value)Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect.voidsetRenderOptionalInnerKeyword(RenderOptionalKeyword value)Whether to render the optionalINNERkeyword inINNER JOIN, if it is optional in the output dialect.voidsetRenderOptionalOuterKeyword(RenderOptionalKeyword value)Whether to render the optionalOUTERkeyword inOUTER JOIN, if it is optional in the output dialect.voidsetRenderOrderByRownumberForEmulatedPagination(Boolean value)Sets the value of the renderOrderByRownumberForEmulatedPagination property.voidsetRenderOutputForSQLServerReturningClause(Boolean value)Sets the value of the renderOutputForSQLServerReturningClause property.voidsetRenderParenthesisAroundSetOperationQueries(Boolean value)Sets the value of the renderParenthesisAroundSetOperationQueries property.voidsetRenderQuotedNames(RenderQuotedNames value)Whether rendered schema, table, column names, etc should be quoted.voidsetRenderScalarSubqueriesForStoredFunctions(Boolean value)Sets the value of the renderScalarSubqueriesForStoredFunctions property.voidsetRenderSchema(Boolean value)Sets the value of the renderSchema property.voidsetReturnAllOnUpdatableRecord(Boolean value)Sets the value of the returnAllOnUpdatableRecord property.voidsetReturnIdentityOnUpdatableRecord(Boolean value)Sets the value of the returnIdentityOnUpdatableRecord property.voidsetReturnRecordToPojo(Boolean value)Sets the value of the returnRecordToPojo property.voidsetStatementType(StatementType value)The type of statement that is to be executed.voidsetThrowExceptions(ThrowExceptions value)A strategy defining how exceptions from the database / JDBC driver should be propagatedvoidsetTransactionListenerEndInvocationOrder(InvocationOrder value)The order of invocation for [action]end() methods registeredTransactionListeners.voidsetTransactionListenerStartInvocationOrder(InvocationOrder value)The order of invocation for [action]start() methods registeredTransactionListeners.voidsetTransformAnsiJoinToTableLists(Boolean value)Sets the value of the transformAnsiJoinToTableLists property.voidsetTransformRownum(Boolean value)Sets the value of the transformRownum property.voidsetTransformTableListsToAnsiJoin(Boolean value)Sets the value of the transformTableListsToAnsiJoin property.voidsetTransformUnneededArithmeticExpressions(TransformUnneededArithmeticExpressions value)Transform arithmetic expressions on literals and bind variables.voidsetUpdatablePrimaryKeys(Boolean value)Sets the value of the updatablePrimaryKeys property.voidsetUpdateRecordTimestamp(Boolean value)Sets the value of the updateRecordTimestamp property.voidsetUpdateRecordVersion(Boolean value)Sets the value of the updateRecordVersion property.voidsetUpdateUnchangedRecords(UpdateUnchangedRecords value)WhetherUpdatableRecord.update()calls should be executed if the record is unchanged.voidsetVisitListenerEndInvocationOrder(InvocationOrder value)The order of invocation for [action]end() methods registeredVisitListeners.voidsetVisitListenerStartInvocationOrder(InvocationOrder value)The order of invocation for [action]start() methods registeredVisitListeners.StringtoString()SettingswithApplyWorkaroundFor7962(Boolean value)SettingswithAttachRecords(Boolean value)SettingswithBackslashEscaping(BackslashEscaping value)Whether string literals should be escaped with backslash.SettingswithBatchSize(Integer value)A property specifying a batch size that should be applied to all automatically createdBatchedConnectioninstances.SettingswithBindOffsetDateTimeType(Boolean value)SettingswithBindOffsetTimeType(Boolean value)SettingswithCachePreparedStatementInLoader(Boolean value)SettingswithCacheRecordMappers(Boolean value)SettingswithDebugInfoOnStackTrace(Boolean value)SettingswithDelimiter(String value)[#5826] The delimiter character to be used to delimit statements in batches.SettingswithEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value)SettingswithExecuteDeleteWithoutWhere(ExecuteWithoutWhere value)[#6771] Specifies whether DELETE statements are allowed to be executed lacking a WHERE clause.SettingswithExecuteListenerEndInvocationOrder(InvocationOrder value)The order of invocation for [action]end() methods registeredExecuteListeners.SettingswithExecuteListenerStartInvocationOrder(InvocationOrder value)The order of invocation for [action]start() methods registeredExecuteListeners.SettingswithExecuteLogging(Boolean value)SettingswithExecuteUpdateWithoutWhere(ExecuteWithoutWhere value)[#6771] Specifies whether UPDATE statements are allowed to be executed lacking a WHERE clause.SettingswithExecuteWithOptimisticLocking(Boolean value)SettingswithExecuteWithOptimisticLockingExcludeUnversioned(Boolean value)SettingswithFetchServerOutputSize(Integer value)Whether server output should be fetched after each query execution.SettingswithFetchSize(Integer value)The default JDBC fetchSize property that should be applied to all jOOQ queries, for which no specific fetchSize value was specified.SettingswithFetchTriggerValuesAfterSQLServerOutput(Boolean value)SettingswithFetchWarnings(Boolean value)SettingswithForceIntegerTypesOnZeroScaleDecimals(Boolean value)SettingswithInlineThreshold(Integer value)The maximum number of allowed bind variables before inlining all values where0uses the dialect defaults:SQLDialect.ACCESS: 768SQLDialect.ASE: 2000SQLDialect.INGRES: 1024SQLDialect.ORACLE: 32767SQLDialect.POSTGRES: 32767SQLDialect.SQLITE: 999SQLDialect.SQLSERVER: 2100SettingswithInListPadBase(Integer value)[#7095] The base to use to calculate the powers of when applying in list padding.SettingswithInListPadding(Boolean value)SettingswithInsertUnchangedRecords(Boolean value)SettingswithInterpreterDelayForeignKeyDeclarations(Boolean value)SettingswithInterpreterDialect(SQLDialect value)[#7337] The dialect that should be used to interpret SQL DDL statements.SettingswithInterpreterLocale(Locale value)The Locale to be used with any interpreter locale dependent logic, defaulting togetLocale().SettingswithInterpreterNameLookupCaseSensitivity(InterpreterNameLookupCaseSensitivity value)[#9633] The case sensitivity of identifiers used when interpreting SQL DDL statements.SettingswithInterpreterSearchPath(Collection<InterpreterSearchSchema> values)SettingswithInterpreterSearchPath(List<InterpreterSearchSchema> interpreterSearchPath)SettingswithInterpreterSearchPath(InterpreterSearchSchema... values)SettingswithLocale(Locale value)The Locale to be used with any locale dependent logic if there is not a more specific locale available.SettingswithMapConstructorParameterNames(Boolean value)SettingswithMapConstructorParameterNamesInKotlin(Boolean value)SettingswithMapJPAAnnotations(Boolean value)SettingswithMaxRows(Integer value)The default JDBC maxRows property that should be applied to all jOOQ queries, for which no specific maxRows value was specified.SettingswithMigrationAllowsUndo(Boolean value)SettingswithMigrationAutoValidation(Boolean value)SettingswithMigrationListenerEndInvocationOrder(InvocationOrder value)The order of invocation for [action]end() methods registeredMigrationListeners.SettingswithMigrationListenerStartInvocationOrder(InvocationOrder value)The order of invocation for [action]start() methods registeredMigrationListeners.SettingswithMigrationRevertUntracked(Boolean value)SettingswithParamCastMode(ParamCastMode value)Whether rendered bind values should be cast to their respective type.SettingswithParamType(ParamType value)Specify how bind variables are to be rendered.SettingswithParseDialect(SQLDialect value)[#7337] The input dialect that should be chosen to disambiguate ambiguous SQL syntax.SettingswithParseIgnoreComments(Boolean value)SettingswithParseIgnoreCommentStart(String value)[#8325] The ignore comment start tokenSettingswithParseIgnoreCommentStop(String value)[#8325] The ignore comment stop tokenSettingswithParseLocale(Locale value)The Locale to be used with any parser locale dependent logic, defaulting togetLocale().SettingswithParseNameCase(ParseNameCase value)[#7337] The default name case for parsed identifiers.SettingswithParseSearchPath(Collection<ParseSearchSchema> values)SettingswithParseSearchPath(List<ParseSearchSchema> parseSearchPath)SettingswithParseSearchPath(ParseSearchSchema... values)SettingswithParseSetCommands(Boolean value)SettingswithParseUnknownFunctions(ParseUnknownFunctions value)[#7344] Whether the parser should accept unknown functions.SettingswithParseUnsupportedSyntax(ParseUnsupportedSyntax value)[#5917] Whether the parser should accept unsupported (but known) syntax.SettingswithParseWithMetaLookups(ParseWithMetaLookups value)[#7163] Whether the parser should perform meta lookups in the Configuration's MetaProvider.SettingswithQueryPoolable(QueryPoolable value)The default JDBC poolable property that should be applied to all jOOQ queries, for which no specific poolable flag was specified.SettingswithQueryTimeout(Integer value)The default JDBC queryTimeout property that should be applied to all jOOQ queries, for which no specific queryTimeout was specified.SettingswithRecordListenerEndInvocationOrder(InvocationOrder value)The order of invocation for [action]end() methods registeredRecordListeners.SettingswithRecordListenerStartInvocationOrder(InvocationOrder value)The order of invocation for [action]start() methods registeredRecordListeners.SettingswithReflectionCaching(Boolean value)SettingswithRenderCatalog(Boolean value)SettingswithRenderFormatted(Boolean value)SettingswithRenderFormatting(RenderFormatting value)All sorts of formatting flags / settings.SettingswithRenderImplicitJoinType(RenderImplicitJoinType value)The join type to be generated by implicit joins.SettingswithRenderKeywordCase(RenderKeywordCase value)Whether the case ofKeywordreferences should be modified in any way.SettingswithRenderKeywordStyle(RenderKeywordStyle value)Deprecated.- 3.12.0 - [#5909] - UseRenderKeywordCaseinstead.SettingswithRenderLocale(Locale value)The Locale to be used with any render locale dependent logic (as e.g.SettingswithRenderMapping(RenderMapping value)Configure render mapping for runtime schema / table rewriting in generated SQL.SettingswithRenderNameCase(RenderNameCase value)Whether the case ofNamereferences should be modified in any way.SettingswithRenderNamedParamPrefix(String value)The prefix to use for named parameters.SettingswithRenderNameStyle(RenderNameStyle value)Deprecated.- 3.12.0 - [#5909] - UseRenderQuotedNamesandRenderNameCaseinstead.SettingswithRenderOptionalAsKeywordForFieldAliases(RenderOptionalKeyword value)Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect.SettingswithRenderOptionalAsKeywordForTableAliases(RenderOptionalKeyword value)Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect.SettingswithRenderOptionalInnerKeyword(RenderOptionalKeyword value)Whether to render the optionalINNERkeyword inINNER JOIN, if it is optional in the output dialect.SettingswithRenderOptionalOuterKeyword(RenderOptionalKeyword value)Whether to render the optionalOUTERkeyword inOUTER JOIN, if it is optional in the output dialect.SettingswithRenderOrderByRownumberForEmulatedPagination(Boolean value)SettingswithRenderOutputForSQLServerReturningClause(Boolean value)SettingswithRenderParenthesisAroundSetOperationQueries(Boolean value)SettingswithRenderQuotedNames(RenderQuotedNames value)Whether rendered schema, table, column names, etc should be quoted.SettingswithRenderScalarSubqueriesForStoredFunctions(Boolean value)SettingswithRenderSchema(Boolean value)SettingswithReturnAllOnUpdatableRecord(Boolean value)SettingswithReturnIdentityOnUpdatableRecord(Boolean value)SettingswithReturnRecordToPojo(Boolean value)SettingswithStatementType(StatementType value)The type of statement that is to be executed.SettingswithThrowExceptions(ThrowExceptions value)A strategy defining how exceptions from the database / JDBC driver should be propagatedSettingswithTransactionListenerEndInvocationOrder(InvocationOrder value)The order of invocation for [action]end() methods registeredTransactionListeners.SettingswithTransactionListenerStartInvocationOrder(InvocationOrder value)The order of invocation for [action]start() methods registeredTransactionListeners.SettingswithTransformAnsiJoinToTableLists(Boolean value)SettingswithTransformRownum(Boolean value)SettingswithTransformTableListsToAnsiJoin(Boolean value)SettingswithTransformUnneededArithmeticExpressions(TransformUnneededArithmeticExpressions value)Transform arithmetic expressions on literals and bind variables.SettingswithUpdatablePrimaryKeys(Boolean value)SettingswithUpdateRecordTimestamp(Boolean value)SettingswithUpdateRecordVersion(Boolean value)SettingswithUpdateUnchangedRecords(UpdateUnchangedRecords value)WhetherUpdatableRecord.update()calls should be executed if the record is unchanged.SettingswithVisitListenerEndInvocationOrder(InvocationOrder value)The order of invocation for [action]end() methods registeredVisitListeners.SettingswithVisitListenerStartInvocationOrder(InvocationOrder value)The order of invocation for [action]start() methods registeredVisitListeners.
 
- 
- 
- 
Field Detail- 
forceIntegerTypesOnZeroScaleDecimalsprotected Boolean forceIntegerTypesOnZeroScaleDecimals 
 - 
renderCatalogprotected Boolean renderCatalog 
 - 
renderSchemaprotected Boolean renderSchema 
 - 
renderMappingprotected RenderMapping renderMapping 
 - 
renderQuotedNamesprotected RenderQuotedNames renderQuotedNames 
 - 
renderNameCaseprotected RenderNameCase renderNameCase 
 - 
renderNameStyleprotected RenderNameStyle renderNameStyle 
 - 
renderNamedParamPrefixprotected String renderNamedParamPrefix 
 - 
renderKeywordCaseprotected RenderKeywordCase renderKeywordCase 
 - 
renderKeywordStyleprotected RenderKeywordStyle renderKeywordStyle 
 - 
renderLocaleprotected Locale renderLocale 
 - 
renderFormattedprotected Boolean renderFormatted 
 - 
renderFormattingprotected RenderFormatting renderFormatting 
 - 
renderOptionalAsKeywordForTableAliasesprotected RenderOptionalKeyword renderOptionalAsKeywordForTableAliases 
 - 
renderOptionalAsKeywordForFieldAliasesprotected RenderOptionalKeyword renderOptionalAsKeywordForFieldAliases 
 - 
renderOptionalInnerKeywordprotected RenderOptionalKeyword renderOptionalInnerKeyword 
 - 
renderOptionalOuterKeywordprotected RenderOptionalKeyword renderOptionalOuterKeyword 
 - 
renderScalarSubqueriesForStoredFunctionsprotected Boolean renderScalarSubqueriesForStoredFunctions 
 - 
renderImplicitJoinTypeprotected RenderImplicitJoinType renderImplicitJoinType 
 - 
renderOrderByRownumberForEmulatedPaginationprotected Boolean renderOrderByRownumberForEmulatedPagination 
 - 
renderOutputForSQLServerReturningClauseprotected Boolean renderOutputForSQLServerReturningClause 
 - 
renderParenthesisAroundSetOperationQueriesprotected Boolean renderParenthesisAroundSetOperationQueries 
 - 
bindOffsetDateTimeTypeprotected Boolean bindOffsetDateTimeType 
 - 
bindOffsetTimeTypeprotected Boolean bindOffsetTimeType 
 - 
fetchTriggerValuesAfterSQLServerOutputprotected Boolean fetchTriggerValuesAfterSQLServerOutput 
 - 
transformAnsiJoinToTableListsprotected Boolean transformAnsiJoinToTableLists 
 - 
transformTableListsToAnsiJoinprotected Boolean transformTableListsToAnsiJoin 
 - 
transformRownumprotected Boolean transformRownum 
 - 
transformUnneededArithmeticExpressionsprotected TransformUnneededArithmeticExpressions transformUnneededArithmeticExpressions 
 - 
backslashEscapingprotected BackslashEscaping backslashEscaping 
 - 
paramTypeprotected ParamType paramType 
 - 
paramCastModeprotected ParamCastMode paramCastMode 
 - 
statementTypeprotected StatementType statementType 
 - 
inlineThresholdprotected Integer inlineThreshold 
 - 
transactionListenerStartInvocationOrderprotected InvocationOrder transactionListenerStartInvocationOrder 
 - 
transactionListenerEndInvocationOrderprotected InvocationOrder transactionListenerEndInvocationOrder 
 - 
migrationListenerStartInvocationOrderprotected InvocationOrder migrationListenerStartInvocationOrder 
 - 
migrationListenerEndInvocationOrderprotected InvocationOrder migrationListenerEndInvocationOrder 
 - 
visitListenerStartInvocationOrderprotected InvocationOrder visitListenerStartInvocationOrder 
 - 
visitListenerEndInvocationOrderprotected InvocationOrder visitListenerEndInvocationOrder 
 - 
recordListenerStartInvocationOrderprotected InvocationOrder recordListenerStartInvocationOrder 
 - 
recordListenerEndInvocationOrderprotected InvocationOrder recordListenerEndInvocationOrder 
 - 
executeListenerStartInvocationOrderprotected InvocationOrder executeListenerStartInvocationOrder 
 - 
executeListenerEndInvocationOrderprotected InvocationOrder executeListenerEndInvocationOrder 
 - 
executeLoggingprotected Boolean executeLogging 
 - 
updateRecordVersionprotected Boolean updateRecordVersion 
 - 
updateRecordTimestampprotected Boolean updateRecordTimestamp 
 - 
executeWithOptimisticLockingprotected Boolean executeWithOptimisticLocking 
 - 
executeWithOptimisticLockingExcludeUnversionedprotected Boolean executeWithOptimisticLockingExcludeUnversioned 
 - 
attachRecordsprotected Boolean attachRecords 
 - 
insertUnchangedRecordsprotected Boolean insertUnchangedRecords 
 - 
updateUnchangedRecordsprotected UpdateUnchangedRecords updateUnchangedRecords 
 - 
updatablePrimaryKeysprotected Boolean updatablePrimaryKeys 
 - 
reflectionCachingprotected Boolean reflectionCaching 
 - 
cacheRecordMappersprotected Boolean cacheRecordMappers 
 - 
cachePreparedStatementInLoaderprotected Boolean cachePreparedStatementInLoader 
 - 
throwExceptionsprotected ThrowExceptions throwExceptions 
 - 
fetchWarningsprotected Boolean fetchWarnings 
 - 
fetchServerOutputSizeprotected Integer fetchServerOutputSize 
 - 
returnIdentityOnUpdatableRecordprotected Boolean returnIdentityOnUpdatableRecord 
 - 
returnAllOnUpdatableRecordprotected Boolean returnAllOnUpdatableRecord 
 - 
returnRecordToPojoprotected Boolean returnRecordToPojo 
 - 
mapJPAAnnotationsprotected Boolean mapJPAAnnotations 
 - 
mapConstructorParameterNamesprotected Boolean mapConstructorParameterNames 
 - 
mapConstructorParameterNamesInKotlinprotected Boolean mapConstructorParameterNamesInKotlin 
 - 
queryPoolableprotected QueryPoolable queryPoolable 
 - 
queryTimeoutprotected Integer queryTimeout 
 - 
maxRowsprotected Integer maxRows 
 - 
fetchSizeprotected Integer fetchSize 
 - 
batchSizeprotected Integer batchSize 
 - 
debugInfoOnStackTraceprotected Boolean debugInfoOnStackTrace 
 - 
inListPaddingprotected Boolean inListPadding 
 - 
inListPadBaseprotected Integer inListPadBase 
 - 
delimiterprotected String delimiter 
 - 
emulateOnDuplicateKeyUpdateOnPrimaryKeyOnlyprotected Boolean emulateOnDuplicateKeyUpdateOnPrimaryKeyOnly 
 - 
executeUpdateWithoutWhereprotected ExecuteWithoutWhere executeUpdateWithoutWhere 
 - 
executeDeleteWithoutWhereprotected ExecuteWithoutWhere executeDeleteWithoutWhere 
 - 
interpreterDialectprotected SQLDialect interpreterDialect 
 - 
interpreterNameLookupCaseSensitivityprotected InterpreterNameLookupCaseSensitivity interpreterNameLookupCaseSensitivity 
 - 
interpreterLocaleprotected Locale interpreterLocale 
 - 
interpreterDelayForeignKeyDeclarationsprotected Boolean interpreterDelayForeignKeyDeclarations 
 - 
migrationAllowsUndoprotected Boolean migrationAllowsUndo 
 - 
migrationRevertUntrackedprotected Boolean migrationRevertUntracked 
 - 
migrationAutoValidationprotected Boolean migrationAutoValidation 
 - 
localeprotected Locale locale 
 - 
parseDialectprotected SQLDialect parseDialect 
 - 
parseLocaleprotected Locale parseLocale 
 - 
parseNameCaseprotected ParseNameCase parseNameCase 
 - 
parseWithMetaLookupsprotected ParseWithMetaLookups parseWithMetaLookups 
 - 
parseSetCommandsprotected Boolean parseSetCommands 
 - 
parseUnsupportedSyntaxprotected ParseUnsupportedSyntax parseUnsupportedSyntax 
 - 
parseUnknownFunctionsprotected ParseUnknownFunctions parseUnknownFunctions 
 - 
parseIgnoreCommentsprotected Boolean parseIgnoreComments 
 - 
parseIgnoreCommentStartprotected String parseIgnoreCommentStart 
 - 
parseIgnoreCommentStopprotected String parseIgnoreCommentStop 
 - 
applyWorkaroundFor7962protected Boolean applyWorkaroundFor7962 
 - 
interpreterSearchPathprotected List<InterpreterSearchSchema> interpreterSearchPath 
 - 
parseSearchPathprotected List<ParseSearchSchema> parseSearchPath 
 
- 
 - 
Method Detail- 
isForceIntegerTypesOnZeroScaleDecimalspublic Boolean isForceIntegerTypesOnZeroScaleDecimals() Historically, zero-scale decimal types are generated as their most appropriate, corresponding integer type (e.g. NUMBER(2, 0) and less: Byte). The same behaviour is replicated in theMetaAPI. This flag allows for turning off this feature.- Returns:
- possible object is
     Boolean
 
 - 
setForceIntegerTypesOnZeroScaleDecimalspublic void setForceIntegerTypesOnZeroScaleDecimals(Boolean value) Sets the value of the forceIntegerTypesOnZeroScaleDecimals property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isRenderCatalogpublic Boolean isRenderCatalog() Whether any catalog name should be rendered at all.Use this for single-catalog environments, or when all objects are made available using synonyms - Returns:
- possible object is
     Boolean
 
 - 
setRenderCatalogpublic void setRenderCatalog(Boolean value) Sets the value of the renderCatalog property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isRenderSchemapublic Boolean isRenderSchema() 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 - Returns:
- possible object is
     Boolean
 
 - 
setRenderSchemapublic void setRenderSchema(Boolean value) Sets the value of the renderSchema property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getRenderMappingpublic RenderMapping getRenderMapping() Configure render mapping for runtime schema / table rewriting in generated SQL.
 - 
setRenderMappingpublic void setRenderMapping(RenderMapping value) Configure render mapping for runtime schema / table rewriting in generated SQL.
 - 
getRenderQuotedNamespublic RenderQuotedNames getRenderQuotedNames() Whether rendered schema, table, column names, etc should be quoted.This only affects names created through DSL.name(String)methods (including those that are implicitly created through this method), notDSL.quotedName(String)orDSL.unquotedName(String), whose behaviour cannot be overridden.This setting does not affect any plain SQL usage. 
 - 
setRenderQuotedNamespublic void setRenderQuotedNames(RenderQuotedNames value) Whether rendered schema, table, column names, etc should be quoted.This only affects names created through DSL.name(String)methods (including those that are implicitly created through this method), notDSL.quotedName(String)orDSL.unquotedName(String), whose behaviour cannot be overridden.This setting does not affect any plain SQL usage. 
 - 
getRenderNameCasepublic RenderNameCase getRenderNameCase() Whether the case ofNamereferences should be modified in any way.Names are modified irrespective of the getRenderQuotedNames()setting.This setting does not affect any plain SQL usage. 
 - 
setRenderNameCasepublic void setRenderNameCase(RenderNameCase value) Whether the case ofNamereferences should be modified in any way.Names are modified irrespective of the getRenderQuotedNames()setting.This setting does not affect any plain SQL usage. 
 - 
getRenderNameStyle@Deprecated public RenderNameStyle getRenderNameStyle() Deprecated.- 3.12.0 - [#5909] - UseRenderQuotedNamesandRenderNameCaseinstead.Whether rendered schema, table, column names, etc should be quoted in rendered SQL, or transformed in any other way.This is set to "QUOTED" by default for backwards-compatibility. 
 - 
setRenderNameStyle@Deprecated public void setRenderNameStyle(RenderNameStyle value) Deprecated.- 3.12.0 - [#5909] - UseRenderQuotedNamesandRenderNameCaseinstead.Whether rendered schema, table, column names, etc should be quoted in rendered SQL, or transformed in any other way.This is set to "QUOTED" by default for backwards-compatibility. 
 - 
getRenderNamedParamPrefixpublic String getRenderNamedParamPrefix() The prefix to use for named parameters.Named parameter syntax defaults to :name(such as supported by Oracle, JPA, Spring), but vendor specific parameters may look differently. This flag can be used to determine the prefix to be used by named parameters, such as@for SQL Server's@nameor$for PostgreSQL's$name."Named indexed" parameters can be obtained in the same way by specifingy ParamType#NAMEDand not providing a name to parameters, resulting in:1or@1or$1, etc.
 - 
setRenderNamedParamPrefixpublic void setRenderNamedParamPrefix(String value) The prefix to use for named parameters.Named parameter syntax defaults to :name(such as supported by Oracle, JPA, Spring), but vendor specific parameters may look differently. This flag can be used to determine the prefix to be used by named parameters, such as@for SQL Server's@nameor$for PostgreSQL's$name."Named indexed" parameters can be obtained in the same way by specifingy ParamType#NAMEDand not providing a name to parameters, resulting in:1or@1or$1, etc.
 - 
getRenderKeywordCasepublic RenderKeywordCase getRenderKeywordCase() Whether the case ofKeywordreferences should be modified in any way.
 - 
setRenderKeywordCasepublic void setRenderKeywordCase(RenderKeywordCase value) Whether the case ofKeywordreferences should be modified in any way.
 - 
getRenderKeywordStyle@Deprecated public RenderKeywordStyle getRenderKeywordStyle() Deprecated.- 3.12.0 - [#5909] - UseRenderKeywordCaseinstead.Whether the case ofKeywordreferences should be modified in any way.
 - 
setRenderKeywordStyle@Deprecated public void setRenderKeywordStyle(RenderKeywordStyle value) Deprecated.- 3.12.0 - [#5909] - UseRenderKeywordCaseinstead.Whether the case ofKeywordreferences should be modified in any way.
 - 
getRenderLocalepublic Locale getRenderLocale() The Locale to be used with any render locale dependent logic (as e.g. transforming names to lower / uppper case), defaulting togetLocale().
 - 
setRenderLocalepublic void setRenderLocale(Locale value) The Locale to be used with any render locale dependent logic (as e.g. transforming names to lower / uppper case), defaulting togetLocale().
 - 
isRenderFormattedpublic Boolean isRenderFormatted() Whether rendered SQL should be pretty-printed.- Returns:
- possible object is
     Boolean
 
 - 
setRenderFormattedpublic void setRenderFormatted(Boolean value) Sets the value of the renderFormatted property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getRenderFormattingpublic RenderFormatting getRenderFormatting() All sorts of formatting flags / settings.
 - 
setRenderFormattingpublic void setRenderFormatting(RenderFormatting value) All sorts of formatting flags / settings.
 - 
getRenderOptionalAsKeywordForTableAliasespublic RenderOptionalKeyword getRenderOptionalAsKeywordForTableAliases() Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect. This is ignored if the keyword is not supported (e.g. in Oracle)
 - 
setRenderOptionalAsKeywordForTableAliasespublic void setRenderOptionalAsKeywordForTableAliases(RenderOptionalKeyword value) Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect. This is ignored if the keyword is not supported (e.g. in Oracle)
 - 
getRenderOptionalAsKeywordForFieldAliasespublic RenderOptionalKeyword getRenderOptionalAsKeywordForFieldAliases() Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect.
 - 
setRenderOptionalAsKeywordForFieldAliasespublic void setRenderOptionalAsKeywordForFieldAliases(RenderOptionalKeyword value) Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect.
 - 
getRenderOptionalInnerKeywordpublic RenderOptionalKeyword getRenderOptionalInnerKeyword() Whether to render the optionalINNERkeyword inINNER JOIN, if it is optional in the output dialect.
 - 
setRenderOptionalInnerKeywordpublic void setRenderOptionalInnerKeyword(RenderOptionalKeyword value) Whether to render the optionalINNERkeyword inINNER JOIN, if it is optional in the output dialect.
 - 
getRenderOptionalOuterKeywordpublic RenderOptionalKeyword getRenderOptionalOuterKeyword() Whether to render the optionalOUTERkeyword inOUTER JOIN, if it is optional in the output dialect.
 - 
setRenderOptionalOuterKeywordpublic void setRenderOptionalOuterKeyword(RenderOptionalKeyword value) Whether to render the optionalOUTERkeyword inOUTER JOIN, if it is optional in the output dialect.
 - 
isRenderScalarSubqueriesForStoredFunctionspublic Boolean isRenderScalarSubqueriesForStoredFunctions() Whether stored function calls should be wrapped in scalar subqueries.Oracle 11g (and potentially, other databases too) implements scalar subquery caching. With this flag set to true, users can automatically profit from this feature in all SQL statements. - Returns:
- possible object is
     Boolean
 
 - 
setRenderScalarSubqueriesForStoredFunctionspublic void setRenderScalarSubqueriesForStoredFunctions(Boolean value) Sets the value of the renderScalarSubqueriesForStoredFunctions property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getRenderImplicitJoinTypepublic RenderImplicitJoinType getRenderImplicitJoinType() The join type to be generated by implicit joins.
 - 
setRenderImplicitJoinTypepublic void setRenderImplicitJoinType(RenderImplicitJoinType value) The join type to be generated by implicit joins.
 - 
isRenderOrderByRownumberForEmulatedPaginationpublic Boolean isRenderOrderByRownumberForEmulatedPagination() Whether an additionalORDER BY rnclause should be rendered on emulated paginated queries.Older databases did not support OFFSET .. FETCH pagination, so jOOQ emulates it using derived tables and ROWNUM(Oracle 11g and older) orROW_NUMBER()(e.g. DB2, SQL Server, etc.) filtering. While these subqueries are ordered, the ordering is not guaranteed to be stable in the outer most queries. It may be stable (and e.g. in Oracle, it mostly is, if queries are not parallel, or joined to other queries, etc.), so the excessORDER BYclause may add some additional performance overhead. This setting forces jOOQ to not generate the additionalORDER BYclause.For details, see https://github.com/jOOQ/jOOQ/issues/7609. - Returns:
- possible object is
     Boolean
 
 - 
setRenderOrderByRownumberForEmulatedPaginationpublic void setRenderOrderByRownumberForEmulatedPagination(Boolean value) Sets the value of the renderOrderByRownumberForEmulatedPagination property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isRenderOutputForSQLServerReturningClausepublic Boolean isRenderOutputForSQLServerReturningClause() Whether the jOOQRETURNINGclause should map to SQL Server'sOUTPUTclause.SQL Server supports an OUTPUTclause in most DML statements, whose behaviour is almost identical toRETURNINGin Firebird, Oracle, PostgreSQL. Users who want to prevent jOOQ from rendering thisOUTPUTclause can deactivate this flag to revert to jOOQ callingjava.sql.Statement#getGeneratedKeys()instead, which is only supported for single row inserts.This OUTPUTclause does not support fetching trigger generated values. In order to fetch trigger generated values,fetchTriggerValuesAfterSQLServerOutputneeds to be enabled as well.For details, see https://github.com/jOOQ/jOOQ/issues/4498. - Returns:
- possible object is
     Boolean
 
 - 
setRenderOutputForSQLServerReturningClausepublic void setRenderOutputForSQLServerReturningClause(Boolean value) Sets the value of the renderOutputForSQLServerReturningClause property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isRenderParenthesisAroundSetOperationQueriespublic Boolean isRenderParenthesisAroundSetOperationQueries() Whether queries combined with set operators (e.g. UNION and UNION ALL) should always be surrounded by a parenthesis pair.By default (i.e. when this setting is set to falsejOOQ will only render parenthesis pairs around queries combined with set operators when required. This is for example the case when set operators are nested, when non-associative operators like EXCEPT are used, or when the queries are rendered as derived tables.When this setting is set to truethe queries combined with set operators will always be surrounded by a parenthesis pair.For details, see https://github.com/jOOQ/jOOQ/issues/3676 and https://github.com/jOOQ/jOOQ/issues/9751. - Returns:
- possible object is
     Boolean
 
 - 
setRenderParenthesisAroundSetOperationQueriespublic void setRenderParenthesisAroundSetOperationQueries(Boolean value) Sets the value of the renderParenthesisAroundSetOperationQueries property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isBindOffsetDateTimeTypepublic Boolean isBindOffsetDateTimeType() Whether thejava.time(JSR 310) typeOffsetDateTimeshould be bound natively to JDBC.Historically, jOOQ encoded the java.timetypes as strings to offer better compatibility with older JDBC drivers. By now, most drivers should support thejava.timetypes. Using them may produce better performance both on the server and on the client side.This flag allows for reverting to pre-jOOQ 3.14 behaviour, where the default is to bind these types natively. For details, see https://github.com/jOOQ/jOOQ/issues/9902. - Returns:
- possible object is
     Boolean
 
 - 
setBindOffsetDateTimeTypepublic void setBindOffsetDateTimeType(Boolean value) Sets the value of the bindOffsetDateTimeType property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isBindOffsetTimeTypepublic Boolean isBindOffsetTimeType() Whether thejava.time(JSR 310) typeOffsetTimeshould be bound natively to JDBC.Historically, jOOQ encoded the java.timetypes as strings to offer better compatibility with older JDBC drivers. By now, most drivers should support thejava.timetypes. Using them may produce better performance both on the server and on the client side.This flag allows for reverting to pre-jOOQ 3.14 behaviour, where the default is to bind these types natively. For details, see https://github.com/jOOQ/jOOQ/issues/9902. - Returns:
- possible object is
     Boolean
 
 - 
setBindOffsetTimeTypepublic void setBindOffsetTimeType(Boolean value) Sets the value of the bindOffsetTimeType property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isFetchTriggerValuesAfterSQLServerOutputpublic Boolean isFetchTriggerValuesAfterSQLServerOutput() Fetch trigger values after SQL ServerOUTPUTclause.SQL Server OUTPUTstatements do not support fetching trigger generated values. This is a limitation of therenderOutputForSQLServerReturningClause. An additionalMERGEstatement can run a second query if (and only if) the primary key has been included in theOUTPUTclause.For details, see https://github.com/jOOQ/jOOQ/issues/4498. - Returns:
- possible object is
     Boolean
 
 - 
setFetchTriggerValuesAfterSQLServerOutputpublic void setFetchTriggerValuesAfterSQLServerOutput(Boolean value) Sets the value of the fetchTriggerValuesAfterSQLServerOutput property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isTransformAnsiJoinToTableListspublic Boolean isTransformAnsiJoinToTableLists() Transform ANSI join to table lists if possible.Historically, prior to ANSI join syntax, joins were implemented by listing tables in the FROM clause and providing join predicates in the WHERE clause, possibly using vendor specific operators like (+)(Oracle, DB2) or*=(SQL Server) for outer join support. For backwards compatibility with older RDBMS versions, ANSI joins in jOOQ code may be converted to equivalent table lists in generated SQL using this flag.This flag has a limited implementation that supports inner joins (in most cases) and outer joins (only for simple comparison predicates). This feature is available in the commercial distribution only. - Returns:
- possible object is
     Boolean
 
 - 
setTransformAnsiJoinToTableListspublic void setTransformAnsiJoinToTableLists(Boolean value) Sets the value of the transformAnsiJoinToTableLists property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isTransformTableListsToAnsiJoinpublic Boolean isTransformTableListsToAnsiJoin() Transform table lists to ANSI join if possible.(Very) historically, prior to ANSI join syntax, joins were implemented by listing tables in the FROM clause and providing join predicates in the WHERE clause, possibly using vendor specific operators like (+)(Oracle, DB2) or*=(SQL Server) for outer join support. Migrating such join syntax is tedious. The jOOQ parser can parse the old syntax and this flag enables the transformation to ANSI join syntax.This feature is available in the commercial distribution only. - Returns:
- possible object is
     Boolean
 
 - 
setTransformTableListsToAnsiJoinpublic void setTransformTableListsToAnsiJoin(Boolean value) Sets the value of the transformTableListsToAnsiJoin property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isTransformRownumpublic Boolean isTransformRownum() TransformROWNUMexpressions to correspondingLIMITclauses orROW_NUMBER()expressions.In Oracle 11g and less, ROWNUMfiltering was the most popular way to paginate. This pseudo column is not supported in other RDBMS, and should be replaced in Oracle 12c by the FETCH clause orROW_NUMBER() OVER ()filtering. This transformation allows for replacing such a filter by equivalent SQL, if possible.This feature is available in the commercial distribution only. - Returns:
- possible object is
     Boolean
 
 - 
setTransformRownumpublic void setTransformRownum(Boolean value) Sets the value of the transformRownum property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getTransformUnneededArithmeticExpressionspublic TransformUnneededArithmeticExpressions getTransformUnneededArithmeticExpressions() Transform arithmetic expressions on literals and bind variables.Arithmetic expressions may be implemented by the user, or arise from emulations from within jOOQ. Expressions on literals and bind variables could be evaluated in the client prior to generating SQL. This feature is available in the commercial distribution only. 
 - 
setTransformUnneededArithmeticExpressionspublic void setTransformUnneededArithmeticExpressions(TransformUnneededArithmeticExpressions value) Transform arithmetic expressions on literals and bind variables.Arithmetic expressions may be implemented by the user, or arise from emulations from within jOOQ. Expressions on literals and bind variables could be evaluated in the client prior to generating SQL. This feature is available in the commercial distribution only. 
 - 
getBackslashEscapingpublic BackslashEscaping getBackslashEscaping() Whether string literals should be escaped with backslash.
 - 
setBackslashEscapingpublic void setBackslashEscaping(BackslashEscaping value) Whether string literals should be escaped with backslash.
 - 
getParamTypepublic ParamType getParamType() Specify how bind variables are to be rendered.Possibilities include: - question marks - named parameters - named or inlined parameters - inlined parameters This value is overridden by statementType == STATIC_STATEMENT, in case of which, this defaults to INLINED 
 - 
setParamTypepublic void setParamType(ParamType value) Specify how bind variables are to be rendered.Possibilities include: - question marks - named parameters - named or inlined parameters - inlined parameters This value is overridden by statementType == STATIC_STATEMENT, in case of which, this defaults to INLINED 
 - 
getParamCastModepublic ParamCastMode getParamCastMode() Whether rendered bind values should be cast to their respective type.
 - 
setParamCastModepublic void setParamCastMode(ParamCastMode value) Whether rendered bind values should be cast to their respective type.
 - 
getStatementTypepublic StatementType getStatementType() The type of statement that is to be executed.
 - 
setStatementTypepublic void setStatementType(StatementType value) The type of statement that is to be executed.
 - 
getInlineThresholdpublic Integer getInlineThreshold() The maximum number of allowed bind variables before inlining all values where0uses the dialect defaults:- SQLDialect.ACCESS: 768
- SQLDialect.ASE: 2000
- SQLDialect.INGRES: 1024
- SQLDialect.ORACLE: 32767
- SQLDialect.POSTGRES: 32767
- SQLDialect.SQLITE: 999
- SQLDialect.SQLSERVER: 2100
 
 - 
setInlineThresholdpublic void setInlineThreshold(Integer value) The maximum number of allowed bind variables before inlining all values where0uses the dialect defaults:- SQLDialect.ACCESS: 768
- SQLDialect.ASE: 2000
- SQLDialect.INGRES: 1024
- SQLDialect.ORACLE: 32767
- SQLDialect.POSTGRES: 32767
- SQLDialect.SQLITE: 999
- SQLDialect.SQLSERVER: 2100
 
 - 
getTransactionListenerStartInvocationOrderpublic InvocationOrder getTransactionListenerStartInvocationOrder() The order of invocation for [action]start() methods registeredTransactionListeners.
 - 
setTransactionListenerStartInvocationOrderpublic void setTransactionListenerStartInvocationOrder(InvocationOrder value) The order of invocation for [action]start() methods registeredTransactionListeners.
 - 
getTransactionListenerEndInvocationOrderpublic InvocationOrder getTransactionListenerEndInvocationOrder() The order of invocation for [action]end() methods registeredTransactionListeners.
 - 
setTransactionListenerEndInvocationOrderpublic void setTransactionListenerEndInvocationOrder(InvocationOrder value) The order of invocation for [action]end() methods registeredTransactionListeners.
 - 
getMigrationListenerStartInvocationOrderpublic InvocationOrder getMigrationListenerStartInvocationOrder() The order of invocation for [action]start() methods registeredMigrationListeners.
 - 
setMigrationListenerStartInvocationOrderpublic void setMigrationListenerStartInvocationOrder(InvocationOrder value) The order of invocation for [action]start() methods registeredMigrationListeners.
 - 
getMigrationListenerEndInvocationOrderpublic InvocationOrder getMigrationListenerEndInvocationOrder() The order of invocation for [action]end() methods registeredMigrationListeners.
 - 
setMigrationListenerEndInvocationOrderpublic void setMigrationListenerEndInvocationOrder(InvocationOrder value) The order of invocation for [action]end() methods registeredMigrationListeners.
 - 
getVisitListenerStartInvocationOrderpublic InvocationOrder getVisitListenerStartInvocationOrder() The order of invocation for [action]start() methods registeredVisitListeners.
 - 
setVisitListenerStartInvocationOrderpublic void setVisitListenerStartInvocationOrder(InvocationOrder value) The order of invocation for [action]start() methods registeredVisitListeners.
 - 
getVisitListenerEndInvocationOrderpublic InvocationOrder getVisitListenerEndInvocationOrder() The order of invocation for [action]end() methods registeredVisitListeners.
 - 
setVisitListenerEndInvocationOrderpublic void setVisitListenerEndInvocationOrder(InvocationOrder value) The order of invocation for [action]end() methods registeredVisitListeners.
 - 
getRecordListenerStartInvocationOrderpublic InvocationOrder getRecordListenerStartInvocationOrder() The order of invocation for [action]start() methods registeredRecordListeners.
 - 
setRecordListenerStartInvocationOrderpublic void setRecordListenerStartInvocationOrder(InvocationOrder value) The order of invocation for [action]start() methods registeredRecordListeners.
 - 
getRecordListenerEndInvocationOrderpublic InvocationOrder getRecordListenerEndInvocationOrder() The order of invocation for [action]end() methods registeredRecordListeners.
 - 
setRecordListenerEndInvocationOrderpublic void setRecordListenerEndInvocationOrder(InvocationOrder value) The order of invocation for [action]end() methods registeredRecordListeners.
 - 
getExecuteListenerStartInvocationOrderpublic InvocationOrder getExecuteListenerStartInvocationOrder() The order of invocation for [action]start() methods registeredExecuteListeners.
 - 
setExecuteListenerStartInvocationOrderpublic void setExecuteListenerStartInvocationOrder(InvocationOrder value) The order of invocation for [action]start() methods registeredExecuteListeners.
 - 
getExecuteListenerEndInvocationOrderpublic InvocationOrder getExecuteListenerEndInvocationOrder() The order of invocation for [action]end() methods registeredExecuteListeners.
 - 
setExecuteListenerEndInvocationOrderpublic void setExecuteListenerEndInvocationOrder(InvocationOrder value) The order of invocation for [action]end() methods registeredExecuteListeners.
 - 
isExecuteLoggingpublic Boolean isExecuteLogging() When set to true, this will add jOOQ's default logging ExecuteListeners.- Returns:
- possible object is
     Boolean
 
 - 
setExecuteLoggingpublic void setExecuteLogging(Boolean value) Sets the value of the executeLogging property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isUpdateRecordVersionpublic Boolean isUpdateRecordVersion() Whether store(), insert(), and update() methods should update the record version prior to the operation, for use withexecuteWithOptimisticLocking.- Returns:
- possible object is
     Boolean
 
 - 
setUpdateRecordVersionpublic void setUpdateRecordVersion(Boolean value) Sets the value of the updateRecordVersion property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isUpdateRecordTimestamppublic Boolean isUpdateRecordTimestamp() Whether store(), insert(), and update() methods should update the record timestamp prior to the operation, for use withexecuteWithOptimisticLocking.- Returns:
- possible object is
     Boolean
 
 - 
setUpdateRecordTimestamppublic void setUpdateRecordTimestamp(Boolean value) Sets the value of the updateRecordTimestamp property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isExecuteWithOptimisticLockingpublic Boolean isExecuteWithOptimisticLocking() Whether store() and delete() methods should be executed with optimistic locking.- Returns:
- possible object is
     Boolean
 
 - 
setExecuteWithOptimisticLockingpublic void setExecuteWithOptimisticLocking(Boolean value) Sets the value of the executeWithOptimisticLocking property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isExecuteWithOptimisticLockingExcludeUnversionedpublic Boolean isExecuteWithOptimisticLockingExcludeUnversioned() Whether store() and delete() methods should be executed with optimistic locking also on "unversioned" tables, i.e. on tables that do not have a version and/or timestamp column.This flag has no effect when "executeWithOptimisticLocking" is turned off. - Returns:
- possible object is
     Boolean
 
 - 
setExecuteWithOptimisticLockingExcludeUnversionedpublic void setExecuteWithOptimisticLockingExcludeUnversioned(Boolean value) Sets the value of the executeWithOptimisticLockingExcludeUnversioned property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isAttachRecordspublic Boolean isAttachRecords() Whether fetched records should be attached to the fetching configuration.- Returns:
- possible object is
     Boolean
 
 - 
setAttachRecordspublic void setAttachRecords(Boolean value) Sets the value of the attachRecords property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isInsertUnchangedRecordspublic Boolean isInsertUnchangedRecords() WhetherTableRecord.insert()calls should be executed if the record is unchanged. This also affects theINSERTpart ofUpdatableRecord.store()andUpdatableRecord.merge()calls.- Returns:
- possible object is
     Boolean
 
 - 
setInsertUnchangedRecordspublic void setInsertUnchangedRecords(Boolean value) Sets the value of the insertUnchangedRecords property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getUpdateUnchangedRecordspublic UpdateUnchangedRecords getUpdateUnchangedRecords() WhetherUpdatableRecord.update()calls should be executed if the record is unchanged. This also affects theUPDATEpart ofUpdatableRecord.store()andUpdatableRecord.merge()calls.
 - 
setUpdateUnchangedRecordspublic void setUpdateUnchangedRecords(UpdateUnchangedRecords value) WhetherUpdatableRecord.update()calls should be executed if the record is unchanged. This also affects theUPDATEpart ofUpdatableRecord.store()andUpdatableRecord.merge()calls.
 - 
isUpdatablePrimaryKeyspublic Boolean isUpdatablePrimaryKeys() Whether primary key values are deemed to be "updatable" in jOOQ.Setting this to "true" will allow for updating primary key values through UpdatableRecord.store() and UpdatableRecord.update(). - Returns:
- possible object is
     Boolean
 
 - 
setUpdatablePrimaryKeyspublic void setUpdatablePrimaryKeys(Boolean value) Sets the value of the updatablePrimaryKeys property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isReflectionCachingpublic Boolean isReflectionCaching() Whether reflection information should be cached in the configuration.- Returns:
- possible object is
     Boolean
 
 - 
setReflectionCachingpublic void setReflectionCaching(Boolean value) Sets the value of the reflectionCaching property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isCacheRecordMapperspublic Boolean isCacheRecordMappers() Whether record mappers should be cached in the configuration.- Returns:
- possible object is
     Boolean
 
 - 
setCacheRecordMapperspublic void setCacheRecordMappers(Boolean value) Sets the value of the cacheRecordMappers property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isCachePreparedStatementInLoaderpublic Boolean isCachePreparedStatementInLoader() Whether JDBCPreparedStatementinstances should be cached in loader API.- Returns:
- possible object is
     Boolean
 
 - 
setCachePreparedStatementInLoaderpublic void setCachePreparedStatementInLoader(Boolean value) Sets the value of the cachePreparedStatementInLoader property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getThrowExceptionspublic ThrowExceptions getThrowExceptions() A strategy defining how exceptions from the database / JDBC driver should be propagated
 - 
setThrowExceptionspublic void setThrowExceptions(ThrowExceptions value) A strategy defining how exceptions from the database / JDBC driver should be propagated
 - 
isFetchWarningspublic Boolean isFetchWarnings() Whether warnings should be fetched after each query execution.- Returns:
- possible object is
     Boolean
 
 - 
setFetchWarningspublic void setFetchWarnings(Boolean value) Sets the value of the fetchWarnings property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getFetchServerOutputSizepublic Integer getFetchServerOutputSize() Whether server output should be fetched after each query execution.
 - 
setFetchServerOutputSizepublic void setFetchServerOutputSize(Integer value) Whether server output should be fetched after each query execution.
 - 
isReturnIdentityOnUpdatableRecordpublic Boolean isReturnIdentityOnUpdatableRecord() Whether calls to store(), insert() and update() should return the identity column.- Returns:
- possible object is
     Boolean
 
 - 
setReturnIdentityOnUpdatableRecordpublic void setReturnIdentityOnUpdatableRecord(Boolean value) Sets the value of the returnIdentityOnUpdatableRecord property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isReturnAllOnUpdatableRecordpublic Boolean isReturnAllOnUpdatableRecord() Whether calls to store(), insert() and update() should return all columns, not just identity columns.Do note that only few databases support this feature. It is supported only in case the INSERT's or UPDATE's RETURNING clause is fully supported, also for non-IDENTITY columns. - Returns:
- possible object is
     Boolean
 
 - 
setReturnAllOnUpdatableRecordpublic void setReturnAllOnUpdatableRecord(Boolean value) Sets the value of the returnAllOnUpdatableRecord property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isReturnRecordToPojopublic Boolean isReturnRecordToPojo() Whether calls to store(), insert(), update(), and delete() that are called on an UpdatableRecord that is created from a POJO (e.g. in a DAO) should return all Record values to the POJO, including IDENTITY values, and ifis active, also other values. - Returns:
- possible object is
     Boolean
 
 - 
setReturnRecordToPojopublic void setReturnRecordToPojo(Boolean value) Sets the value of the returnRecordToPojo property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isMapJPAAnnotationspublic Boolean isMapJPAAnnotations() Whether JPA annotations should be considered by the DefaultRecordMapper.- Returns:
- possible object is
     Boolean
 
 - 
setMapJPAAnnotationspublic void setMapJPAAnnotations(Boolean value) Sets the value of the mapJPAAnnotations property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isMapConstructorParameterNamespublic Boolean isMapConstructorParameterNames() Whether constructor parameter names obtained via reflection in Java 8+ should be considered by the DefaultRecordMapper. This flag has no effect in Java 6 or 7.- Returns:
- possible object is
     Boolean
 
 - 
setMapConstructorParameterNamespublic void setMapConstructorParameterNames(Boolean value) Sets the value of the mapConstructorParameterNames property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isMapConstructorParameterNamesInKotlinpublic Boolean isMapConstructorParameterNamesInKotlin() Whether constructor parameter names obtained via reflection in Kotlin should be considered by the DefaultRecordMapper. This flag has no effect in Java.- Returns:
- possible object is
     Boolean
 
 - 
setMapConstructorParameterNamesInKotlinpublic void setMapConstructorParameterNamesInKotlin(Boolean value) Sets the value of the mapConstructorParameterNamesInKotlin property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getQueryPoolablepublic QueryPoolable getQueryPoolable() The default JDBC poolable property that should be applied to all jOOQ queries, for which no specific poolable flag was specified.
 - 
setQueryPoolablepublic void setQueryPoolable(QueryPoolable value) The default JDBC poolable property that should be applied to all jOOQ queries, for which no specific poolable flag was specified.
 - 
getQueryTimeoutpublic Integer getQueryTimeout() The default JDBC queryTimeout property that should be applied to all jOOQ queries, for which no specific queryTimeout was specified.
 - 
setQueryTimeoutpublic void setQueryTimeout(Integer value) The default JDBC queryTimeout property that should be applied to all jOOQ queries, for which no specific queryTimeout was specified.
 - 
getMaxRowspublic Integer getMaxRows() The default JDBC maxRows property that should be applied to all jOOQ queries, for which no specific maxRows value was specified.
 - 
setMaxRowspublic void setMaxRows(Integer value) The default JDBC maxRows property that should be applied to all jOOQ queries, for which no specific maxRows value was specified.
 - 
getFetchSizepublic Integer getFetchSize() The default JDBC fetchSize property that should be applied to all jOOQ queries, for which no specific fetchSize value was specified.
 - 
setFetchSizepublic void setFetchSize(Integer value) The default JDBC fetchSize property that should be applied to all jOOQ queries, for which no specific fetchSize value was specified.
 - 
getBatchSizepublic Integer getBatchSize() A property specifying a batch size that should be applied to all automatically createdBatchedConnectioninstances.
 - 
setBatchSizepublic void setBatchSize(Integer value) A property specifying a batch size that should be applied to all automatically createdBatchedConnectioninstances.
 - 
isDebugInfoOnStackTracepublic Boolean isDebugInfoOnStackTrace() [#5570] Whether exception stack traces should be enhanced with additional debug information.- Returns:
- possible object is
     Boolean
 
 - 
setDebugInfoOnStackTracepublic void setDebugInfoOnStackTrace(Boolean value) Sets the value of the debugInfoOnStackTrace property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isInListPaddingpublic Boolean isInListPadding() [#5600] Whether IN lists in IN predicates should be padded to powers of inListPadBase (default 2).- Returns:
- possible object is
     Boolean
 
 - 
setInListPaddingpublic void setInListPadding(Boolean value) Sets the value of the inListPadding property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getInListPadBasepublic Integer getInListPadBase() [#7095] The base to use to calculate the powers of when applying in list padding.
 - 
setInListPadBasepublic void setInListPadBase(Integer value) [#7095] The base to use to calculate the powers of when applying in list padding.
 - 
getDelimiterpublic String getDelimiter() [#5826] The delimiter character to be used to delimit statements in batches.
 - 
setDelimiterpublic void setDelimiter(String value) [#5826] The delimiter character to be used to delimit statements in batches.
 - 
isEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnlypublic Boolean isEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly() [#6462] Use only the primary key to emulate MySQL's INSERT .. ON DUPLICATE KEY UPDATE statement. In MySQL, the statement considers all unique keys for duplicates to apply an update rather than an insert. Earlier versions of jOOQ considered only the PRIMARY KEY. This flag can be turned on to maintain backwards compatibility.- Returns:
- possible object is
     Boolean
 
 - 
setEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnlypublic void setEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value) Sets the value of the emulateOnDuplicateKeyUpdateOnPrimaryKeyOnly property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getExecuteUpdateWithoutWherepublic ExecuteWithoutWhere getExecuteUpdateWithoutWhere() [#6771] Specifies whether UPDATE statements are allowed to be executed lacking a WHERE clause. This has no effect on rendering the statements SQL string.
 - 
setExecuteUpdateWithoutWherepublic void setExecuteUpdateWithoutWhere(ExecuteWithoutWhere value) [#6771] Specifies whether UPDATE statements are allowed to be executed lacking a WHERE clause. This has no effect on rendering the statements SQL string.
 - 
getExecuteDeleteWithoutWherepublic ExecuteWithoutWhere getExecuteDeleteWithoutWhere() [#6771] Specifies whether DELETE statements are allowed to be executed lacking a WHERE clause. This has no effect on rendering the statements SQL string.
 - 
setExecuteDeleteWithoutWherepublic void setExecuteDeleteWithoutWhere(ExecuteWithoutWhere value) [#6771] Specifies whether DELETE statements are allowed to be executed lacking a WHERE clause. This has no effect on rendering the statements SQL string.
 - 
getInterpreterDialectpublic SQLDialect getInterpreterDialect() [#7337] The dialect that should be used to interpret SQL DDL statements.SQLDialect.DEFAULTmeans that jOOQ interprets the SQL itself. Any other dialect (if supported) will be interpreted on an actual JDBC connection.
 - 
setInterpreterDialectpublic void setInterpreterDialect(SQLDialect value) [#7337] The dialect that should be used to interpret SQL DDL statements.SQLDialect.DEFAULTmeans that jOOQ interprets the SQL itself. Any other dialect (if supported) will be interpreted on an actual JDBC connection.
 - 
getInterpreterNameLookupCaseSensitivitypublic InterpreterNameLookupCaseSensitivity getInterpreterNameLookupCaseSensitivity() [#9633] The case sensitivity of identifiers used when interpreting SQL DDL statements.
 - 
setInterpreterNameLookupCaseSensitivitypublic void setInterpreterNameLookupCaseSensitivity(InterpreterNameLookupCaseSensitivity value) [#9633] The case sensitivity of identifiers used when interpreting SQL DDL statements.
 - 
getInterpreterLocalepublic Locale getInterpreterLocale() The Locale to be used with any interpreter locale dependent logic, defaulting togetLocale().
 - 
setInterpreterLocalepublic void setInterpreterLocale(Locale value) The Locale to be used with any interpreter locale dependent logic, defaulting togetLocale().
 - 
isInterpreterDelayForeignKeyDeclarationspublic Boolean isInterpreterDelayForeignKeyDeclarations() Using this flag, the interpreter will be able to delay the addition of foreign key declarations until the end of the interpretation run.- Returns:
- possible object is
     Boolean
 
 - 
setInterpreterDelayForeignKeyDeclarationspublic void setInterpreterDelayForeignKeyDeclarations(Boolean value) Sets the value of the interpreterDelayForeignKeyDeclarations property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isMigrationAllowsUndopublic Boolean isMigrationAllowsUndo() Whether migrations are allowed to be executed in inverse order.This is a potentially destructive feature, which should not be turned on in production. It is useful mostly to quickly switch between branches in a development environment. This feature is available only in commercial distributions. - Returns:
- possible object is
     Boolean
 
 - 
setMigrationAllowsUndopublic void setMigrationAllowsUndo(Boolean value) Sets the value of the migrationAllowsUndo property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isMigrationRevertUntrackedpublic Boolean isMigrationRevertUntracked() Whether migrations revert any untracked changes in the schemas that are being migrated.This is a potentially destructive feature, which should not be turned on in production. It is useful mostly to quickly revert any elements created in a development environment. This feature is available only in commercial distributions. - Returns:
- possible object is
     Boolean
 
 - 
setMigrationRevertUntrackedpublic void setMigrationRevertUntracked(Boolean value) Sets the value of the migrationRevertUntracked property.- Parameters:
- value- allowed object is- Boolean
 
 - 
isMigrationAutoValidationpublic Boolean isMigrationAutoValidation() Whether a migration automatically runs a validation first.- Returns:
- possible object is
     Boolean
 
 - 
setMigrationAutoValidationpublic void setMigrationAutoValidation(Boolean value) Sets the value of the migrationAutoValidation property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getLocalepublic Locale getLocale() The Locale to be used with any locale dependent logic if there is not a more specific locale available. More specific locales include e.g.getRenderLocale(),getParseLocale(), orgetInterpreterLocale().
 - 
setLocalepublic void setLocale(Locale value) The Locale to be used with any locale dependent logic if there is not a more specific locale available. More specific locales include e.g.getRenderLocale(),getParseLocale(), orgetInterpreterLocale().
 - 
getParseDialectpublic SQLDialect getParseDialect() [#7337] The input dialect that should be chosen to disambiguate ambiguous SQL syntax.
 - 
setParseDialectpublic void setParseDialect(SQLDialect value) [#7337] The input dialect that should be chosen to disambiguate ambiguous SQL syntax.
 - 
getParseLocalepublic Locale getParseLocale() The Locale to be used with any parser locale dependent logic, defaulting togetLocale().
 - 
setParseLocalepublic void setParseLocale(Locale value) The Locale to be used with any parser locale dependent logic, defaulting togetLocale().
 - 
getParseNameCasepublic ParseNameCase getParseNameCase() [#7337] The default name case for parsed identifiers.
 - 
setParseNameCasepublic void setParseNameCase(ParseNameCase value) [#7337] The default name case for parsed identifiers.
 - 
getParseWithMetaLookupspublic ParseWithMetaLookups getParseWithMetaLookups() [#7163] Whether the parser should perform meta lookups in the Configuration's MetaProvider.
 - 
setParseWithMetaLookupspublic void setParseWithMetaLookups(ParseWithMetaLookups value) [#7163] Whether the parser should perform meta lookups in the Configuration's MetaProvider.
 - 
isParseSetCommandspublic Boolean isParseSetCommands() [#9780] Whether commands of the typeSET key = valueshould be parsed rather than ignored.- Returns:
- possible object is
     Boolean
 
 - 
setParseSetCommandspublic void setParseSetCommands(Boolean value) Sets the value of the parseSetCommands property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getParseUnsupportedSyntaxpublic ParseUnsupportedSyntax getParseUnsupportedSyntax() [#5917] Whether the parser should accept unsupported (but known) syntax.
 - 
setParseUnsupportedSyntaxpublic void setParseUnsupportedSyntax(ParseUnsupportedSyntax value) [#5917] Whether the parser should accept unsupported (but known) syntax.
 - 
getParseUnknownFunctionspublic ParseUnknownFunctions getParseUnknownFunctions() [#7344] Whether the parser should accept unknown functions.
 - 
setParseUnknownFunctionspublic void setParseUnknownFunctions(ParseUnknownFunctions value) [#7344] Whether the parser should accept unknown functions.
 - 
isParseIgnoreCommentspublic Boolean isParseIgnoreComments() [#8325] Whether the parser should ignore content between ignore comment tokens.- Returns:
- possible object is
     Boolean
 
 - 
setParseIgnoreCommentspublic void setParseIgnoreComments(Boolean value) Sets the value of the parseIgnoreComments property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getParseIgnoreCommentStartpublic String getParseIgnoreCommentStart() [#8325] The ignore comment start token
 - 
setParseIgnoreCommentStartpublic void setParseIgnoreCommentStart(String value) [#8325] The ignore comment start token
 - 
getParseIgnoreCommentStoppublic String getParseIgnoreCommentStop() [#8325] The ignore comment stop token
 - 
setParseIgnoreCommentStoppublic void setParseIgnoreCommentStop(String value) [#8325] The ignore comment stop token
 - 
isApplyWorkaroundFor7962public Boolean isApplyWorkaroundFor7962() [#7963] Apply workaround for ORA-04043 when inserting into Oracle tables with qualified, quoted identifiers, and fetching generated keys- Returns:
- possible object is
     Boolean
 
 - 
setApplyWorkaroundFor7962public void setApplyWorkaroundFor7962(Boolean value) Sets the value of the applyWorkaroundFor7962 property.- Parameters:
- value- allowed object is- Boolean
 
 - 
getInterpreterSearchPathpublic List<InterpreterSearchSchema> getInterpreterSearchPath() 
 - 
setInterpreterSearchPathpublic void setInterpreterSearchPath(List<InterpreterSearchSchema> interpreterSearchPath) 
 - 
getParseSearchPathpublic List<ParseSearchSchema> getParseSearchPath() 
 - 
setParseSearchPathpublic void setParseSearchPath(List<ParseSearchSchema> parseSearchPath) 
 - 
withForceIntegerTypesOnZeroScaleDecimalspublic Settings withForceIntegerTypesOnZeroScaleDecimals(Boolean value) 
 - 
withRenderMappingpublic Settings withRenderMapping(RenderMapping value) Configure render mapping for runtime schema / table rewriting in generated SQL.
 - 
withRenderQuotedNamespublic Settings withRenderQuotedNames(RenderQuotedNames value) Whether rendered schema, table, column names, etc should be quoted.This only affects names created through DSL.name(String)methods (including those that are implicitly created through this method), notDSL.quotedName(String)orDSL.unquotedName(String), whose behaviour cannot be overridden.This setting does not affect any plain SQL usage. 
 - 
withRenderNameCasepublic Settings withRenderNameCase(RenderNameCase value) Whether the case ofNamereferences should be modified in any way.Names are modified irrespective of the getRenderQuotedNames()setting.This setting does not affect any plain SQL usage. 
 - 
withRenderNameStyle@Deprecated public Settings withRenderNameStyle(RenderNameStyle value) Deprecated.- 3.12.0 - [#5909] - UseRenderQuotedNamesandRenderNameCaseinstead.Whether rendered schema, table, column names, etc should be quoted in rendered SQL, or transformed in any other way.This is set to "QUOTED" by default for backwards-compatibility. 
 - 
withRenderNamedParamPrefixpublic Settings withRenderNamedParamPrefix(String value) The prefix to use for named parameters.Named parameter syntax defaults to :name(such as supported by Oracle, JPA, Spring), but vendor specific parameters may look differently. This flag can be used to determine the prefix to be used by named parameters, such as@for SQL Server's@nameor$for PostgreSQL's$name."Named indexed" parameters can be obtained in the same way by specifingy ParamType#NAMEDand not providing a name to parameters, resulting in:1or@1or$1, etc.
 - 
withRenderKeywordCasepublic Settings withRenderKeywordCase(RenderKeywordCase value) Whether the case ofKeywordreferences should be modified in any way.
 - 
withRenderKeywordStyle@Deprecated public Settings withRenderKeywordStyle(RenderKeywordStyle value) Deprecated.- 3.12.0 - [#5909] - UseRenderKeywordCaseinstead.Whether the case ofKeywordreferences should be modified in any way.
 - 
withRenderLocalepublic Settings withRenderLocale(Locale value) The Locale to be used with any render locale dependent logic (as e.g. transforming names to lower / uppper case), defaulting togetLocale().
 - 
withRenderFormattingpublic Settings withRenderFormatting(RenderFormatting value) All sorts of formatting flags / settings.
 - 
withRenderOptionalAsKeywordForTableAliasespublic Settings withRenderOptionalAsKeywordForTableAliases(RenderOptionalKeyword value) Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect. This is ignored if the keyword is not supported (e.g. in Oracle)
 - 
withRenderOptionalAsKeywordForFieldAliasespublic Settings withRenderOptionalAsKeywordForFieldAliases(RenderOptionalKeyword value) Whether to render the optionalASkeyword in table aliases, if it is optional in the output dialect.
 - 
withRenderOptionalInnerKeywordpublic Settings withRenderOptionalInnerKeyword(RenderOptionalKeyword value) Whether to render the optionalINNERkeyword inINNER JOIN, if it is optional in the output dialect.
 - 
withRenderOptionalOuterKeywordpublic Settings withRenderOptionalOuterKeyword(RenderOptionalKeyword value) Whether to render the optionalOUTERkeyword inOUTER JOIN, if it is optional in the output dialect.
 - 
withRenderScalarSubqueriesForStoredFunctionspublic Settings withRenderScalarSubqueriesForStoredFunctions(Boolean value) 
 - 
withRenderImplicitJoinTypepublic Settings withRenderImplicitJoinType(RenderImplicitJoinType value) The join type to be generated by implicit joins.
 - 
withRenderOrderByRownumberForEmulatedPaginationpublic Settings withRenderOrderByRownumberForEmulatedPagination(Boolean value) 
 - 
withRenderOutputForSQLServerReturningClausepublic Settings withRenderOutputForSQLServerReturningClause(Boolean value) 
 - 
withRenderParenthesisAroundSetOperationQueriespublic Settings withRenderParenthesisAroundSetOperationQueries(Boolean value) 
 - 
withFetchTriggerValuesAfterSQLServerOutputpublic Settings withFetchTriggerValuesAfterSQLServerOutput(Boolean value) 
 - 
withTransformUnneededArithmeticExpressionspublic Settings withTransformUnneededArithmeticExpressions(TransformUnneededArithmeticExpressions value) Transform arithmetic expressions on literals and bind variables.Arithmetic expressions may be implemented by the user, or arise from emulations from within jOOQ. Expressions on literals and bind variables could be evaluated in the client prior to generating SQL. This feature is available in the commercial distribution only. 
 - 
withBackslashEscapingpublic Settings withBackslashEscaping(BackslashEscaping value) Whether string literals should be escaped with backslash.
 - 
withParamTypepublic Settings withParamType(ParamType value) Specify how bind variables are to be rendered.Possibilities include: - question marks - named parameters - named or inlined parameters - inlined parameters This value is overridden by statementType == STATIC_STATEMENT, in case of which, this defaults to INLINED 
 - 
withParamCastModepublic Settings withParamCastMode(ParamCastMode value) Whether rendered bind values should be cast to their respective type.
 - 
withStatementTypepublic Settings withStatementType(StatementType value) The type of statement that is to be executed.
 - 
withInlineThresholdpublic Settings withInlineThreshold(Integer value) The maximum number of allowed bind variables before inlining all values where0uses the dialect defaults:- SQLDialect.ACCESS: 768
- SQLDialect.ASE: 2000
- SQLDialect.INGRES: 1024
- SQLDialect.ORACLE: 32767
- SQLDialect.POSTGRES: 32767
- SQLDialect.SQLITE: 999
- SQLDialect.SQLSERVER: 2100
 
 - 
withTransactionListenerStartInvocationOrderpublic Settings withTransactionListenerStartInvocationOrder(InvocationOrder value) The order of invocation for [action]start() methods registeredTransactionListeners.
 - 
withTransactionListenerEndInvocationOrderpublic Settings withTransactionListenerEndInvocationOrder(InvocationOrder value) The order of invocation for [action]end() methods registeredTransactionListeners.
 - 
withMigrationListenerStartInvocationOrderpublic Settings withMigrationListenerStartInvocationOrder(InvocationOrder value) The order of invocation for [action]start() methods registeredMigrationListeners.
 - 
withMigrationListenerEndInvocationOrderpublic Settings withMigrationListenerEndInvocationOrder(InvocationOrder value) The order of invocation for [action]end() methods registeredMigrationListeners.
 - 
withVisitListenerStartInvocationOrderpublic Settings withVisitListenerStartInvocationOrder(InvocationOrder value) The order of invocation for [action]start() methods registeredVisitListeners.
 - 
withVisitListenerEndInvocationOrderpublic Settings withVisitListenerEndInvocationOrder(InvocationOrder value) The order of invocation for [action]end() methods registeredVisitListeners.
 - 
withRecordListenerStartInvocationOrderpublic Settings withRecordListenerStartInvocationOrder(InvocationOrder value) The order of invocation for [action]start() methods registeredRecordListeners.
 - 
withRecordListenerEndInvocationOrderpublic Settings withRecordListenerEndInvocationOrder(InvocationOrder value) The order of invocation for [action]end() methods registeredRecordListeners.
 - 
withExecuteListenerStartInvocationOrderpublic Settings withExecuteListenerStartInvocationOrder(InvocationOrder value) The order of invocation for [action]start() methods registeredExecuteListeners.
 - 
withExecuteListenerEndInvocationOrderpublic Settings withExecuteListenerEndInvocationOrder(InvocationOrder value) The order of invocation for [action]end() methods registeredExecuteListeners.
 - 
withExecuteWithOptimisticLockingExcludeUnversionedpublic Settings withExecuteWithOptimisticLockingExcludeUnversioned(Boolean value) 
 - 
withUpdateUnchangedRecordspublic Settings withUpdateUnchangedRecords(UpdateUnchangedRecords value) WhetherUpdatableRecord.update()calls should be executed if the record is unchanged. This also affects theUPDATEpart ofUpdatableRecord.store()andUpdatableRecord.merge()calls.
 - 
withCachePreparedStatementInLoaderpublic Settings withCachePreparedStatementInLoader(Boolean value) 
 - 
withThrowExceptionspublic Settings withThrowExceptions(ThrowExceptions value) A strategy defining how exceptions from the database / JDBC driver should be propagated
 - 
withFetchServerOutputSizepublic Settings withFetchServerOutputSize(Integer value) Whether server output should be fetched after each query execution.
 - 
withReturnIdentityOnUpdatableRecordpublic Settings withReturnIdentityOnUpdatableRecord(Boolean value) 
 - 
withMapConstructorParameterNamesInKotlinpublic Settings withMapConstructorParameterNamesInKotlin(Boolean value) 
 - 
withQueryPoolablepublic 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.
 - 
withQueryTimeoutpublic Settings withQueryTimeout(Integer value) The default JDBC queryTimeout property that should be applied to all jOOQ queries, for which no specific queryTimeout was specified.
 - 
withMaxRowspublic 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.
 - 
withFetchSizepublic 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.
 - 
withBatchSizepublic Settings withBatchSize(Integer value) A property specifying a batch size that should be applied to all automatically createdBatchedConnectioninstances.
 - 
withInListPadBasepublic Settings withInListPadBase(Integer value) [#7095] The base to use to calculate the powers of when applying in list padding.
 - 
withDelimiterpublic Settings withDelimiter(String value) [#5826] The delimiter character to be used to delimit statements in batches.
 - 
withEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnlypublic Settings withEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value) 
 - 
withExecuteUpdateWithoutWherepublic Settings withExecuteUpdateWithoutWhere(ExecuteWithoutWhere value) [#6771] Specifies whether UPDATE statements are allowed to be executed lacking a WHERE clause. This has no effect on rendering the statements SQL string.
 - 
withExecuteDeleteWithoutWherepublic Settings withExecuteDeleteWithoutWhere(ExecuteWithoutWhere value) [#6771] Specifies whether DELETE statements are allowed to be executed lacking a WHERE clause. This has no effect on rendering the statements SQL string.
 - 
withInterpreterDialectpublic Settings withInterpreterDialect(SQLDialect value) [#7337] The dialect that should be used to interpret SQL DDL statements.SQLDialect.DEFAULTmeans that jOOQ interprets the SQL itself. Any other dialect (if supported) will be interpreted on an actual JDBC connection.
 - 
withInterpreterNameLookupCaseSensitivitypublic Settings withInterpreterNameLookupCaseSensitivity(InterpreterNameLookupCaseSensitivity value) [#9633] The case sensitivity of identifiers used when interpreting SQL DDL statements.
 - 
withInterpreterLocalepublic Settings withInterpreterLocale(Locale value) The Locale to be used with any interpreter locale dependent logic, defaulting togetLocale().
 - 
withInterpreterDelayForeignKeyDeclarationspublic Settings withInterpreterDelayForeignKeyDeclarations(Boolean value) 
 - 
withLocalepublic Settings withLocale(Locale value) The Locale to be used with any locale dependent logic if there is not a more specific locale available. More specific locales include e.g.getRenderLocale(),getParseLocale(), orgetInterpreterLocale().
 - 
withParseDialectpublic Settings withParseDialect(SQLDialect value) [#7337] The input dialect that should be chosen to disambiguate ambiguous SQL syntax.
 - 
withParseLocalepublic Settings withParseLocale(Locale value) The Locale to be used with any parser locale dependent logic, defaulting togetLocale().
 - 
withParseNameCasepublic Settings withParseNameCase(ParseNameCase value) [#7337] The default name case for parsed identifiers.
 - 
withParseWithMetaLookupspublic Settings withParseWithMetaLookups(ParseWithMetaLookups value) [#7163] Whether the parser should perform meta lookups in the Configuration's MetaProvider.
 - 
withParseUnsupportedSyntaxpublic Settings withParseUnsupportedSyntax(ParseUnsupportedSyntax value) [#5917] Whether the parser should accept unsupported (but known) syntax.
 - 
withParseUnknownFunctionspublic Settings withParseUnknownFunctions(ParseUnknownFunctions value) [#7344] Whether the parser should accept unknown functions.
 - 
withParseIgnoreCommentStartpublic Settings withParseIgnoreCommentStart(String value) [#8325] The ignore comment start token
 - 
withParseIgnoreCommentStoppublic Settings withParseIgnoreCommentStop(String value) [#8325] The ignore comment stop token
 - 
withInterpreterSearchPathpublic Settings withInterpreterSearchPath(InterpreterSearchSchema... values) 
 - 
withInterpreterSearchPathpublic Settings withInterpreterSearchPath(Collection<InterpreterSearchSchema> values) 
 - 
withInterpreterSearchPathpublic Settings withInterpreterSearchPath(List<InterpreterSearchSchema> interpreterSearchPath) 
 - 
withParseSearchPathpublic Settings withParseSearchPath(ParseSearchSchema... values) 
 - 
withParseSearchPathpublic Settings withParseSearchPath(Collection<ParseSearchSchema> values) 
 - 
withParseSearchPathpublic Settings withParseSearchPath(List<ParseSearchSchema> parseSearchPath) 
 - 
appendTopublic final void appendTo(XMLBuilder builder) - Specified by:
- appendToin interface- XMLAppendable
 
 
- 
 
-