- 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 Summary
Constructors Constructor Description Settings()
-
Method Summary
All 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.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.IntegergetMaxRows()The default JDBC maxRows property that should be applied to all jOOQ queries, for which no specific maxRows value was specified.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 tokenList<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.RenderKeywordCasegetRenderKeywordCase()Whether the case ofKeywordreferences should be modified in any way.RenderKeywordStylegetRenderKeywordStyle()Deprecated.- 3.12.0 - [#5909] - UseRenderQuotedNamesandRenderNameCaseinstead.LocalegetRenderLocale()The Locale to be used with any 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.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.InvocationOrdergetVisitListenerEndInvocationOrder()The order of invocation for [action]end() methods registeredVisitListeners.InvocationOrdergetVisitListenerStartInvocationOrder()The order of invocation for [action]start() methods registeredVisitListeners.inthashCode()BooleanisAttachRecords()Whether fetched records should be attached to the fetching configuration.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.BooleanisInListPadding()[#5600] Whether IN lists in IN predicates should be padded to powers of inListPadBase (default 2).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.BooleanisParseIgnoreComments()[#8325] Whether the parser should ignore content between ignore comment tokens.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.BooleanisTransformTableListsToAnsiJoin()Transform table lists to ANSI join if possibleBooleanisUpdatablePrimaryKeys()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.voidsetAttachRecords(Boolean value)Sets the value of the attachRecords property.voidsetBackslashEscaping(BackslashEscaping value)Sets the value of the backslashEscaping property.voidsetCacheRecordMappers(Boolean value)Sets the value of the cacheRecordMappers property.voidsetDebugInfoOnStackTrace(Boolean value)Sets the value of the debugInfoOnStackTrace property.voidsetDelimiter(String value)Sets the value of the delimiter property.voidsetEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value)Sets the value of the emulateOnDuplicateKeyUpdateOnPrimaryKeyOnly property.voidsetExecuteDeleteWithoutWhere(ExecuteWithoutWhere value)Sets the value of the executeDeleteWithoutWhere property.voidsetExecuteListenerEndInvocationOrder(InvocationOrder value)Sets the value of the executeListenerEndInvocationOrder property.voidsetExecuteListenerStartInvocationOrder(InvocationOrder value)Sets the value of the executeListenerStartInvocationOrder property.voidsetExecuteLogging(Boolean value)Sets the value of the executeLogging property.voidsetExecuteUpdateWithoutWhere(ExecuteWithoutWhere value)Sets the value of the executeUpdateWithoutWhere property.voidsetExecuteWithOptimisticLocking(Boolean value)Sets the value of the executeWithOptimisticLocking property.voidsetExecuteWithOptimisticLockingExcludeUnversioned(Boolean value)Sets the value of the executeWithOptimisticLockingExcludeUnversioned property.voidsetFetchServerOutputSize(Integer value)Sets the value of the fetchServerOutputSize property.voidsetFetchSize(Integer value)Sets the value of the fetchSize property.voidsetFetchTriggerValuesAfterSQLServerOutput(Boolean value)Sets the value of the fetchTriggerValuesAfterSQLServerOutput property.voidsetFetchWarnings(Boolean value)Sets the value of the fetchWarnings property.voidsetInlineThreshold(Integer value)Sets the value of the inlineThreshold property.voidsetInListPadBase(Integer value)Sets the value of the inListPadBase property.voidsetInListPadding(Boolean value)Sets the value of the inListPadding property.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)Sets the value of the maxRows property.voidsetParamCastMode(ParamCastMode value)Sets the value of the paramCastMode property.voidsetParamType(ParamType value)Sets the value of the paramType property.voidsetParseDialect(SQLDialect value)Sets the value of the parseDialect property.voidsetParseIgnoreComments(Boolean value)Sets the value of the parseIgnoreComments property.voidsetParseIgnoreCommentStart(String value)Sets the value of the parseIgnoreCommentStart property.voidsetParseIgnoreCommentStop(String value)Sets the value of the parseIgnoreCommentStop property.voidsetParseSearchPath(List<ParseSearchSchema> parseSearchPath)voidsetParseUnknownFunctions(ParseUnknownFunctions value)Sets the value of the parseUnknownFunctions property.voidsetParseUnsupportedSyntax(ParseUnsupportedSyntax value)Sets the value of the parseUnsupportedSyntax property.voidsetParseWithMetaLookups(ParseWithMetaLookups value)Sets the value of the parseWithMetaLookups property.voidsetQueryPoolable(QueryPoolable value)Sets the value of the queryPoolable property.voidsetQueryTimeout(Integer value)Sets the value of the queryTimeout property.voidsetRecordListenerEndInvocationOrder(InvocationOrder value)Sets the value of the recordListenerEndInvocationOrder property.voidsetRecordListenerStartInvocationOrder(InvocationOrder value)Sets the value of the recordListenerStartInvocationOrder property.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)Sets the value of the renderFormatting property.voidsetRenderKeywordCase(RenderKeywordCase value)Sets the value of the renderKeywordCase property.voidsetRenderKeywordStyle(RenderKeywordStyle value)Sets the value of the renderKeywordStyle property.voidsetRenderLocale(Locale value)Sets the value of the renderLocale property.voidsetRenderMapping(RenderMapping value)Sets the value of the renderMapping property.voidsetRenderNameCase(RenderNameCase value)Sets the value of the renderNameCase property.voidsetRenderNamedParamPrefix(String value)Sets the value of the renderNamedParamPrefix property.voidsetRenderNameStyle(RenderNameStyle value)Sets the value of the renderNameStyle property.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)Sets the value of the renderQuotedNames property.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)Sets the value of the statementType property.voidsetThrowExceptions(ThrowExceptions value)Sets the value of the throwExceptions property.voidsetTransactionListenerEndInvocationOrder(InvocationOrder value)Sets the value of the transactionListenerEndInvocationOrder property.voidsetTransactionListenerStartInvocationOrder(InvocationOrder value)Sets the value of the transactionListenerStartInvocationOrder property.voidsetTransformTableListsToAnsiJoin(Boolean value)Sets the value of the transformTableListsToAnsiJoin property.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.voidsetVisitListenerEndInvocationOrder(InvocationOrder value)Sets the value of the visitListenerEndInvocationOrder property.voidsetVisitListenerStartInvocationOrder(InvocationOrder value)Sets the value of the visitListenerStartInvocationOrder property.StringtoString()SettingswithAttachRecords(Boolean value)SettingswithBackslashEscaping(BackslashEscaping value)SettingswithCacheRecordMappers(Boolean value)SettingswithDebugInfoOnStackTrace(Boolean value)SettingswithDelimiter(String value)SettingswithEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value)SettingswithExecuteDeleteWithoutWhere(ExecuteWithoutWhere value)SettingswithExecuteListenerEndInvocationOrder(InvocationOrder value)SettingswithExecuteListenerStartInvocationOrder(InvocationOrder value)SettingswithExecuteLogging(Boolean value)SettingswithExecuteUpdateWithoutWhere(ExecuteWithoutWhere value)SettingswithExecuteWithOptimisticLocking(Boolean value)SettingswithExecuteWithOptimisticLockingExcludeUnversioned(Boolean value)SettingswithFetchServerOutputSize(Integer value)SettingswithFetchSize(Integer value)SettingswithFetchTriggerValuesAfterSQLServerOutput(Boolean value)SettingswithFetchWarnings(Boolean value)SettingswithInlineThreshold(Integer value)SettingswithInListPadBase(Integer value)SettingswithInListPadding(Boolean value)SettingswithMapConstructorParameterNames(Boolean value)SettingswithMapConstructorParameterNamesInKotlin(Boolean value)SettingswithMapJPAAnnotations(Boolean value)SettingswithMaxRows(Integer value)SettingswithParamCastMode(ParamCastMode value)SettingswithParamType(ParamType value)SettingswithParseDialect(SQLDialect value)SettingswithParseIgnoreComments(Boolean value)SettingswithParseIgnoreCommentStart(String value)SettingswithParseIgnoreCommentStop(String value)SettingswithParseSearchPath(Collection<ParseSearchSchema> values)SettingswithParseSearchPath(List<ParseSearchSchema> parseSearchPath)SettingswithParseSearchPath(ParseSearchSchema... values)SettingswithParseUnknownFunctions(ParseUnknownFunctions value)SettingswithParseUnsupportedSyntax(ParseUnsupportedSyntax value)SettingswithParseWithMetaLookups(ParseWithMetaLookups value)SettingswithQueryPoolable(QueryPoolable value)SettingswithQueryTimeout(Integer value)SettingswithRecordListenerEndInvocationOrder(InvocationOrder value)SettingswithRecordListenerStartInvocationOrder(InvocationOrder value)SettingswithReflectionCaching(Boolean value)SettingswithRenderCatalog(Boolean value)SettingswithRenderFormatted(Boolean value)SettingswithRenderFormatting(RenderFormatting value)SettingswithRenderKeywordCase(RenderKeywordCase value)SettingswithRenderKeywordStyle(RenderKeywordStyle value)SettingswithRenderLocale(Locale value)SettingswithRenderMapping(RenderMapping value)SettingswithRenderNameCase(RenderNameCase value)SettingswithRenderNamedParamPrefix(String value)SettingswithRenderNameStyle(RenderNameStyle value)SettingswithRenderOrderByRownumberForEmulatedPagination(Boolean value)SettingswithRenderOutputForSQLServerReturningClause(Boolean value)SettingswithRenderParenthesisAroundSetOperationQueries(Boolean value)SettingswithRenderQuotedNames(RenderQuotedNames value)SettingswithRenderScalarSubqueriesForStoredFunctions(Boolean value)SettingswithRenderSchema(Boolean value)SettingswithReturnAllOnUpdatableRecord(Boolean value)SettingswithReturnIdentityOnUpdatableRecord(Boolean value)SettingswithReturnRecordToPojo(Boolean value)SettingswithStatementType(StatementType value)SettingswithThrowExceptions(ThrowExceptions value)SettingswithTransactionListenerEndInvocationOrder(InvocationOrder value)SettingswithTransactionListenerStartInvocationOrder(InvocationOrder value)SettingswithTransformTableListsToAnsiJoin(Boolean value)SettingswithUpdatablePrimaryKeys(Boolean value)SettingswithUpdateRecordTimestamp(Boolean value)SettingswithUpdateRecordVersion(Boolean value)SettingswithVisitListenerEndInvocationOrder(InvocationOrder value)SettingswithVisitListenerStartInvocationOrder(InvocationOrder value)
-
-
-
Field Detail
-
renderCatalog
protected Boolean renderCatalog
-
renderSchema
protected Boolean renderSchema
-
renderMapping
protected RenderMapping renderMapping
-
renderQuotedNames
protected RenderQuotedNames renderQuotedNames
-
renderNameCase
protected RenderNameCase renderNameCase
-
renderNameStyle
protected RenderNameStyle renderNameStyle
-
renderNamedParamPrefix
protected String renderNamedParamPrefix
-
renderKeywordCase
protected RenderKeywordCase renderKeywordCase
-
renderKeywordStyle
protected RenderKeywordStyle renderKeywordStyle
-
renderLocale
protected Locale renderLocale
-
renderFormatted
protected Boolean renderFormatted
-
renderFormatting
protected RenderFormatting renderFormatting
-
renderScalarSubqueriesForStoredFunctions
protected Boolean renderScalarSubqueriesForStoredFunctions
-
renderOrderByRownumberForEmulatedPagination
protected Boolean renderOrderByRownumberForEmulatedPagination
-
renderOutputForSQLServerReturningClause
protected Boolean renderOutputForSQLServerReturningClause
-
renderParenthesisAroundSetOperationQueries
protected Boolean renderParenthesisAroundSetOperationQueries
-
fetchTriggerValuesAfterSQLServerOutput
protected Boolean fetchTriggerValuesAfterSQLServerOutput
-
transformTableListsToAnsiJoin
protected Boolean transformTableListsToAnsiJoin
-
backslashEscaping
protected BackslashEscaping backslashEscaping
-
paramType
protected ParamType paramType
-
paramCastMode
protected ParamCastMode paramCastMode
-
statementType
protected StatementType statementType
-
inlineThreshold
protected Integer inlineThreshold
-
transactionListenerStartInvocationOrder
protected InvocationOrder transactionListenerStartInvocationOrder
-
transactionListenerEndInvocationOrder
protected InvocationOrder transactionListenerEndInvocationOrder
-
visitListenerStartInvocationOrder
protected InvocationOrder visitListenerStartInvocationOrder
-
visitListenerEndInvocationOrder
protected InvocationOrder visitListenerEndInvocationOrder
-
recordListenerStartInvocationOrder
protected InvocationOrder recordListenerStartInvocationOrder
-
recordListenerEndInvocationOrder
protected InvocationOrder recordListenerEndInvocationOrder
-
executeListenerStartInvocationOrder
protected InvocationOrder executeListenerStartInvocationOrder
-
executeListenerEndInvocationOrder
protected InvocationOrder executeListenerEndInvocationOrder
-
executeLogging
protected Boolean executeLogging
-
updateRecordVersion
protected Boolean updateRecordVersion
-
updateRecordTimestamp
protected Boolean updateRecordTimestamp
-
executeWithOptimisticLocking
protected Boolean executeWithOptimisticLocking
-
executeWithOptimisticLockingExcludeUnversioned
protected Boolean executeWithOptimisticLockingExcludeUnversioned
-
attachRecords
protected Boolean attachRecords
-
updatablePrimaryKeys
protected Boolean updatablePrimaryKeys
-
reflectionCaching
protected Boolean reflectionCaching
-
cacheRecordMappers
protected Boolean cacheRecordMappers
-
throwExceptions
protected ThrowExceptions throwExceptions
-
fetchWarnings
protected Boolean fetchWarnings
-
fetchServerOutputSize
protected Integer fetchServerOutputSize
-
returnIdentityOnUpdatableRecord
protected Boolean returnIdentityOnUpdatableRecord
-
returnAllOnUpdatableRecord
protected Boolean returnAllOnUpdatableRecord
-
returnRecordToPojo
protected Boolean returnRecordToPojo
-
mapJPAAnnotations
protected Boolean mapJPAAnnotations
-
mapConstructorParameterNames
protected Boolean mapConstructorParameterNames
-
mapConstructorParameterNamesInKotlin
protected Boolean mapConstructorParameterNamesInKotlin
-
queryPoolable
protected QueryPoolable queryPoolable
-
queryTimeout
protected Integer queryTimeout
-
maxRows
protected Integer maxRows
-
fetchSize
protected Integer fetchSize
-
debugInfoOnStackTrace
protected Boolean debugInfoOnStackTrace
-
inListPadding
protected Boolean inListPadding
-
inListPadBase
protected Integer inListPadBase
-
delimiter
protected String delimiter
-
emulateOnDuplicateKeyUpdateOnPrimaryKeyOnly
protected Boolean emulateOnDuplicateKeyUpdateOnPrimaryKeyOnly
-
executeUpdateWithoutWhere
protected ExecuteWithoutWhere executeUpdateWithoutWhere
-
executeDeleteWithoutWhere
protected ExecuteWithoutWhere executeDeleteWithoutWhere
-
parseDialect
protected SQLDialect parseDialect
-
parseWithMetaLookups
protected ParseWithMetaLookups parseWithMetaLookups
-
parseUnsupportedSyntax
protected ParseUnsupportedSyntax parseUnsupportedSyntax
-
parseUnknownFunctions
protected ParseUnknownFunctions parseUnknownFunctions
-
parseIgnoreComments
protected Boolean parseIgnoreComments
-
parseIgnoreCommentStart
protected String parseIgnoreCommentStart
-
parseIgnoreCommentStop
protected String parseIgnoreCommentStop
-
parseSearchPath
protected List<ParseSearchSchema> parseSearchPath
-
-
Method Detail
-
isRenderCatalog
public 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
-
setRenderCatalog
public void setRenderCatalog(Boolean value)
Sets the value of the renderCatalog property.- Parameters:
value- allowed object isBoolean
-
isRenderSchema
public 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
-
setRenderSchema
public void setRenderSchema(Boolean value)
Sets the value of the renderSchema property.- Parameters:
value- allowed object isBoolean
-
getRenderMapping
public RenderMapping getRenderMapping()
Configure render mapping for runtime schema / table rewriting in generated SQL.- Returns:
- possible object is
RenderMapping
-
setRenderMapping
public void setRenderMapping(RenderMapping value)
Sets the value of the renderMapping property.- Parameters:
value- allowed object isRenderMapping
-
getRenderQuotedNames
public 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.
- Returns:
- possible object is
RenderQuotedNames
-
setRenderQuotedNames
public void setRenderQuotedNames(RenderQuotedNames value)
Sets the value of the renderQuotedNames property.- Parameters:
value- allowed object isRenderQuotedNames
-
getRenderNameCase
public 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.
- Returns:
- possible object is
RenderNameCase
-
setRenderNameCase
public void setRenderNameCase(RenderNameCase value)
Sets the value of the renderNameCase property.- Parameters:
value- allowed object isRenderNameCase
-
getRenderNameStyle
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.
- Returns:
- possible object is
RenderNameStyle
-
setRenderNameStyle
public void setRenderNameStyle(RenderNameStyle value)
Sets the value of the renderNameStyle property.- Parameters:
value- allowed object isRenderNameStyle
-
getRenderNamedParamPrefix
public 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.- Returns:
- possible object is
String
-
setRenderNamedParamPrefix
public void setRenderNamedParamPrefix(String value)
Sets the value of the renderNamedParamPrefix property.- Parameters:
value- allowed object isString
-
getRenderKeywordCase
public RenderKeywordCase getRenderKeywordCase()
Whether the case ofKeywordreferences should be modified in any way.- Returns:
- possible object is
RenderKeywordCase
-
setRenderKeywordCase
public void setRenderKeywordCase(RenderKeywordCase value)
Sets the value of the renderKeywordCase property.- Parameters:
value- allowed object isRenderKeywordCase
-
getRenderKeywordStyle
public RenderKeywordStyle getRenderKeywordStyle()
Deprecated.- 3.12.0 - [#5909] - UseRenderQuotedNamesandRenderNameCaseinstead.Whether the case ofKeywordreferences should be modified in any way.- Returns:
- possible object is
RenderKeywordStyle
-
setRenderKeywordStyle
public void setRenderKeywordStyle(RenderKeywordStyle value)
Sets the value of the renderKeywordStyle property.- Parameters:
value- allowed object isRenderKeywordStyle
-
getRenderLocale
public Locale getRenderLocale()
The Locale to be used with any locale dependent logic (as e.g. transforming names to lower / uppper case).- Returns:
- possible object is
String
-
setRenderLocale
public void setRenderLocale(Locale value)
Sets the value of the renderLocale property.- Parameters:
value- allowed object isString
-
isRenderFormatted
public Boolean isRenderFormatted()
Whether rendered SQL should be pretty-printed.- Returns:
- possible object is
Boolean
-
setRenderFormatted
public void setRenderFormatted(Boolean value)
Sets the value of the renderFormatted property.- Parameters:
value- allowed object isBoolean
-
getRenderFormatting
public RenderFormatting getRenderFormatting()
All sorts of formatting flags / settings.- Returns:
- possible object is
RenderFormatting
-
setRenderFormatting
public void setRenderFormatting(RenderFormatting value)
Sets the value of the renderFormatting property.- Parameters:
value- allowed object isRenderFormatting
-
isRenderScalarSubqueriesForStoredFunctions
public 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
-
setRenderScalarSubqueriesForStoredFunctions
public void setRenderScalarSubqueriesForStoredFunctions(Boolean value)
Sets the value of the renderScalarSubqueriesForStoredFunctions property.- Parameters:
value- allowed object isBoolean
-
isRenderOrderByRownumberForEmulatedPagination
public 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
-
setRenderOrderByRownumberForEmulatedPagination
public void setRenderOrderByRownumberForEmulatedPagination(Boolean value)
Sets the value of the renderOrderByRownumberForEmulatedPagination property.- Parameters:
value- allowed object isBoolean
-
isRenderOutputForSQLServerReturningClause
public 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
-
setRenderOutputForSQLServerReturningClause
public void setRenderOutputForSQLServerReturningClause(Boolean value)
Sets the value of the renderOutputForSQLServerReturningClause property.- Parameters:
value- allowed object isBoolean
-
isRenderParenthesisAroundSetOperationQueries
public 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
-
setRenderParenthesisAroundSetOperationQueries
public void setRenderParenthesisAroundSetOperationQueries(Boolean value)
Sets the value of the renderParenthesisAroundSetOperationQueries property.- Parameters:
value- allowed object isBoolean
-
isFetchTriggerValuesAfterSQLServerOutput
public 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
-
setFetchTriggerValuesAfterSQLServerOutput
public void setFetchTriggerValuesAfterSQLServerOutput(Boolean value)
Sets the value of the fetchTriggerValuesAfterSQLServerOutput property.- Parameters:
value- allowed object isBoolean
-
isTransformTableListsToAnsiJoin
public 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
-
setTransformTableListsToAnsiJoin
public void setTransformTableListsToAnsiJoin(Boolean value)
Sets the value of the transformTableListsToAnsiJoin property.- Parameters:
value- allowed object isBoolean
-
getBackslashEscaping
public BackslashEscaping getBackslashEscaping()
Whether string literals should be escaped with backslash.- Returns:
- possible object is
BackslashEscaping
-
setBackslashEscaping
public void setBackslashEscaping(BackslashEscaping value)
Sets the value of the backslashEscaping property.- Parameters:
value- allowed object isBackslashEscaping
-
getParamType
public 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
- Returns:
- possible object is
ParamType
-
setParamType
public void setParamType(ParamType value)
Sets the value of the paramType property.- Parameters:
value- allowed object isParamType
-
getParamCastMode
public ParamCastMode getParamCastMode()
Whether rendered bind values should be cast to their respective type.- Returns:
- possible object is
ParamCastMode
-
setParamCastMode
public void setParamCastMode(ParamCastMode value)
Sets the value of the paramCastMode property.- Parameters:
value- allowed object isParamCastMode
-
getStatementType
public StatementType getStatementType()
The type of statement that is to be executed.- Returns:
- possible object is
StatementType
-
setStatementType
public void setStatementType(StatementType value)
Sets the value of the statementType property.- Parameters:
value- allowed object isStatementType
-
getInlineThreshold
public Integer getInlineThreshold()
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: 2100
- Returns:
- possible object is
Integer
-
setInlineThreshold
public void setInlineThreshold(Integer value)
Sets the value of the inlineThreshold property.- Parameters:
value- allowed object isInteger
-
getTransactionListenerStartInvocationOrder
public InvocationOrder getTransactionListenerStartInvocationOrder()
The order of invocation for [action]start() methods registeredTransactionListeners.- Returns:
- possible object is
InvocationOrder
-
setTransactionListenerStartInvocationOrder
public void setTransactionListenerStartInvocationOrder(InvocationOrder value)
Sets the value of the transactionListenerStartInvocationOrder property.- Parameters:
value- allowed object isInvocationOrder
-
getTransactionListenerEndInvocationOrder
public InvocationOrder getTransactionListenerEndInvocationOrder()
The order of invocation for [action]end() methods registeredTransactionListeners.- Returns:
- possible object is
InvocationOrder
-
setTransactionListenerEndInvocationOrder
public void setTransactionListenerEndInvocationOrder(InvocationOrder value)
Sets the value of the transactionListenerEndInvocationOrder property.- Parameters:
value- allowed object isInvocationOrder
-
getVisitListenerStartInvocationOrder
public InvocationOrder getVisitListenerStartInvocationOrder()
The order of invocation for [action]start() methods registeredVisitListeners.- Returns:
- possible object is
InvocationOrder
-
setVisitListenerStartInvocationOrder
public void setVisitListenerStartInvocationOrder(InvocationOrder value)
Sets the value of the visitListenerStartInvocationOrder property.- Parameters:
value- allowed object isInvocationOrder
-
getVisitListenerEndInvocationOrder
public InvocationOrder getVisitListenerEndInvocationOrder()
The order of invocation for [action]end() methods registeredVisitListeners.- Returns:
- possible object is
InvocationOrder
-
setVisitListenerEndInvocationOrder
public void setVisitListenerEndInvocationOrder(InvocationOrder value)
Sets the value of the visitListenerEndInvocationOrder property.- Parameters:
value- allowed object isInvocationOrder
-
getRecordListenerStartInvocationOrder
public InvocationOrder getRecordListenerStartInvocationOrder()
The order of invocation for [action]start() methods registeredRecordListeners.- Returns:
- possible object is
InvocationOrder
-
setRecordListenerStartInvocationOrder
public void setRecordListenerStartInvocationOrder(InvocationOrder value)
Sets the value of the recordListenerStartInvocationOrder property.- Parameters:
value- allowed object isInvocationOrder
-
getRecordListenerEndInvocationOrder
public InvocationOrder getRecordListenerEndInvocationOrder()
The order of invocation for [action]end() methods registeredRecordListeners.- Returns:
- possible object is
InvocationOrder
-
setRecordListenerEndInvocationOrder
public void setRecordListenerEndInvocationOrder(InvocationOrder value)
Sets the value of the recordListenerEndInvocationOrder property.- Parameters:
value- allowed object isInvocationOrder
-
getExecuteListenerStartInvocationOrder
public InvocationOrder getExecuteListenerStartInvocationOrder()
The order of invocation for [action]start() methods registeredExecuteListeners.- Returns:
- possible object is
InvocationOrder
-
setExecuteListenerStartInvocationOrder
public void setExecuteListenerStartInvocationOrder(InvocationOrder value)
Sets the value of the executeListenerStartInvocationOrder property.- Parameters:
value- allowed object isInvocationOrder
-
getExecuteListenerEndInvocationOrder
public InvocationOrder getExecuteListenerEndInvocationOrder()
The order of invocation for [action]end() methods registeredExecuteListeners.- Returns:
- possible object is
InvocationOrder
-
setExecuteListenerEndInvocationOrder
public void setExecuteListenerEndInvocationOrder(InvocationOrder value)
Sets the value of the executeListenerEndInvocationOrder property.- Parameters:
value- allowed object isInvocationOrder
-
isExecuteLogging
public Boolean isExecuteLogging()
When set to true, this will add jOOQ's default logging ExecuteListeners.- Returns:
- possible object is
Boolean
-
setExecuteLogging
public void setExecuteLogging(Boolean value)
Sets the value of the executeLogging property.- Parameters:
value- allowed object isBoolean
-
isUpdateRecordVersion
public 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
-
setUpdateRecordVersion
public void setUpdateRecordVersion(Boolean value)
Sets the value of the updateRecordVersion property.- Parameters:
value- allowed object isBoolean
-
isUpdateRecordTimestamp
public 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
-
setUpdateRecordTimestamp
public void setUpdateRecordTimestamp(Boolean value)
Sets the value of the updateRecordTimestamp property.- Parameters:
value- allowed object isBoolean
-
isExecuteWithOptimisticLocking
public Boolean isExecuteWithOptimisticLocking()
Whether store() and delete() methods should be executed with optimistic locking.- Returns:
- possible object is
Boolean
-
setExecuteWithOptimisticLocking
public void setExecuteWithOptimisticLocking(Boolean value)
Sets the value of the executeWithOptimisticLocking property.- Parameters:
value- allowed object isBoolean
-
isExecuteWithOptimisticLockingExcludeUnversioned
public 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
-
setExecuteWithOptimisticLockingExcludeUnversioned
public void setExecuteWithOptimisticLockingExcludeUnversioned(Boolean value)
Sets the value of the executeWithOptimisticLockingExcludeUnversioned property.- Parameters:
value- allowed object isBoolean
-
isAttachRecords
public Boolean isAttachRecords()
Whether fetched records should be attached to the fetching configuration.- Returns:
- possible object is
Boolean
-
setAttachRecords
public void setAttachRecords(Boolean value)
Sets the value of the attachRecords property.- Parameters:
value- allowed object isBoolean
-
isUpdatablePrimaryKeys
public 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
-
setUpdatablePrimaryKeys
public void setUpdatablePrimaryKeys(Boolean value)
Sets the value of the updatablePrimaryKeys property.- Parameters:
value- allowed object isBoolean
-
isReflectionCaching
public Boolean isReflectionCaching()
Whether reflection information should be cached in the configuration.- Returns:
- possible object is
Boolean
-
setReflectionCaching
public void setReflectionCaching(Boolean value)
Sets the value of the reflectionCaching property.- Parameters:
value- allowed object isBoolean
-
isCacheRecordMappers
public Boolean isCacheRecordMappers()
Whether record mappers should be cached in the configuration.- Returns:
- possible object is
Boolean
-
setCacheRecordMappers
public void setCacheRecordMappers(Boolean value)
Sets the value of the cacheRecordMappers property.- Parameters:
value- allowed object isBoolean
-
getThrowExceptions
public ThrowExceptions getThrowExceptions()
A strategy defining how exceptions from the database / JDBC driver should be propagated- Returns:
- possible object is
ThrowExceptions
-
setThrowExceptions
public void setThrowExceptions(ThrowExceptions value)
Sets the value of the throwExceptions property.- Parameters:
value- allowed object isThrowExceptions
-
isFetchWarnings
public Boolean isFetchWarnings()
Whether warnings should be fetched after each query execution.- Returns:
- possible object is
Boolean
-
setFetchWarnings
public void setFetchWarnings(Boolean value)
Sets the value of the fetchWarnings property.- Parameters:
value- allowed object isBoolean
-
getFetchServerOutputSize
public Integer getFetchServerOutputSize()
Whether server output should be fetched after each query execution.- Returns:
- possible object is
Integer
-
setFetchServerOutputSize
public void setFetchServerOutputSize(Integer value)
Sets the value of the fetchServerOutputSize property.- Parameters:
value- allowed object isInteger
-
isReturnIdentityOnUpdatableRecord
public Boolean isReturnIdentityOnUpdatableRecord()
Whether calls to store(), insert() and update() should return the identity column.- Returns:
- possible object is
Boolean
-
setReturnIdentityOnUpdatableRecord
public void setReturnIdentityOnUpdatableRecord(Boolean value)
Sets the value of the returnIdentityOnUpdatableRecord property.- Parameters:
value- allowed object isBoolean
-
isReturnAllOnUpdatableRecord
public 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
-
setReturnAllOnUpdatableRecord
public void setReturnAllOnUpdatableRecord(Boolean value)
Sets the value of the returnAllOnUpdatableRecord property.- Parameters:
value- allowed object isBoolean
-
isReturnRecordToPojo
public 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
-
setReturnRecordToPojo
public void setReturnRecordToPojo(Boolean value)
Sets the value of the returnRecordToPojo property.- Parameters:
value- allowed object isBoolean
-
isMapJPAAnnotations
public Boolean isMapJPAAnnotations()
Whether JPA annotations should be considered by the DefaultRecordMapper.- Returns:
- possible object is
Boolean
-
setMapJPAAnnotations
public void setMapJPAAnnotations(Boolean value)
Sets the value of the mapJPAAnnotations property.- Parameters:
value- allowed object isBoolean
-
isMapConstructorParameterNames
public 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
-
setMapConstructorParameterNames
public void setMapConstructorParameterNames(Boolean value)
Sets the value of the mapConstructorParameterNames property.- Parameters:
value- allowed object isBoolean
-
isMapConstructorParameterNamesInKotlin
public 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
-
setMapConstructorParameterNamesInKotlin
public void setMapConstructorParameterNamesInKotlin(Boolean value)
Sets the value of the mapConstructorParameterNamesInKotlin property.- Parameters:
value- allowed object isBoolean
-
getQueryPoolable
public QueryPoolable getQueryPoolable()
The default JDBC poolable property that should be applied to all jOOQ queries, for which no specific poolable flag was specified.- Returns:
- possible object is
QueryPoolable
-
setQueryPoolable
public void setQueryPoolable(QueryPoolable value)
Sets the value of the queryPoolable property.- Parameters:
value- allowed object isQueryPoolable
-
getQueryTimeout
public Integer getQueryTimeout()
The default JDBC queryTimeout property that should be applied to all jOOQ queries, for which no specific queryTimeout was specified.- Returns:
- possible object is
Integer
-
setQueryTimeout
public void setQueryTimeout(Integer value)
Sets the value of the queryTimeout property.- Parameters:
value- allowed object isInteger
-
getMaxRows
public Integer getMaxRows()
The default JDBC maxRows property that should be applied to all jOOQ queries, for which no specific maxRows value was specified.- Returns:
- possible object is
Integer
-
setMaxRows
public void setMaxRows(Integer value)
Sets the value of the maxRows property.- Parameters:
value- allowed object isInteger
-
getFetchSize
public Integer getFetchSize()
The default JDBC fetchSize property that should be applied to all jOOQ queries, for which no specific fetchSize value was specified.- Returns:
- possible object is
Integer
-
setFetchSize
public void setFetchSize(Integer value)
Sets the value of the fetchSize property.- Parameters:
value- allowed object isInteger
-
isDebugInfoOnStackTrace
public Boolean isDebugInfoOnStackTrace()
[#5570] Whether exception stack traces should be enhanced with additional debug information.- Returns:
- possible object is
Boolean
-
setDebugInfoOnStackTrace
public void setDebugInfoOnStackTrace(Boolean value)
Sets the value of the debugInfoOnStackTrace property.- Parameters:
value- allowed object isBoolean
-
isInListPadding
public Boolean isInListPadding()
[#5600] Whether IN lists in IN predicates should be padded to powers of inListPadBase (default 2).- Returns:
- possible object is
Boolean
-
setInListPadding
public void setInListPadding(Boolean value)
Sets the value of the inListPadding property.- Parameters:
value- allowed object isBoolean
-
getInListPadBase
public Integer getInListPadBase()
[#7095] The base to use to calculate the powers of when applying in list padding.- Returns:
- possible object is
Integer
-
setInListPadBase
public void setInListPadBase(Integer value)
Sets the value of the inListPadBase property.- Parameters:
value- allowed object isInteger
-
getDelimiter
public String getDelimiter()
[#5826] The delimiter character to be used to delimit statements in batches.- Returns:
- possible object is
String
-
setDelimiter
public void setDelimiter(String value)
Sets the value of the delimiter property.- Parameters:
value- allowed object isString
-
isEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly
public 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
-
setEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly
public void setEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value)
Sets the value of the emulateOnDuplicateKeyUpdateOnPrimaryKeyOnly property.- Parameters:
value- allowed object isBoolean
-
getExecuteUpdateWithoutWhere
public 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.- Returns:
- possible object is
ExecuteWithoutWhere
-
setExecuteUpdateWithoutWhere
public void setExecuteUpdateWithoutWhere(ExecuteWithoutWhere value)
Sets the value of the executeUpdateWithoutWhere property.- Parameters:
value- allowed object isExecuteWithoutWhere
-
getExecuteDeleteWithoutWhere
public 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.- Returns:
- possible object is
ExecuteWithoutWhere
-
setExecuteDeleteWithoutWhere
public void setExecuteDeleteWithoutWhere(ExecuteWithoutWhere value)
Sets the value of the executeDeleteWithoutWhere property.- Parameters:
value- allowed object isExecuteWithoutWhere
-
getParseDialect
public SQLDialect getParseDialect()
[#7337] The input dialect that should be chosen to disambiguate ambiguous SQL syntax.- Returns:
- possible object is
String
-
setParseDialect
public void setParseDialect(SQLDialect value)
Sets the value of the parseDialect property.- Parameters:
value- allowed object isString
-
getParseWithMetaLookups
public ParseWithMetaLookups getParseWithMetaLookups()
[#7163] Whether the parser should perform meta lookups in the Configuration's MetaProvider.- Returns:
- possible object is
ParseWithMetaLookups
-
setParseWithMetaLookups
public void setParseWithMetaLookups(ParseWithMetaLookups value)
Sets the value of the parseWithMetaLookups property.- Parameters:
value- allowed object isParseWithMetaLookups
-
getParseUnsupportedSyntax
public ParseUnsupportedSyntax getParseUnsupportedSyntax()
[#5917] Whether the parser should accept unsupported (but known) syntax.- Returns:
- possible object is
ParseUnsupportedSyntax
-
setParseUnsupportedSyntax
public void setParseUnsupportedSyntax(ParseUnsupportedSyntax value)
Sets the value of the parseUnsupportedSyntax property.- Parameters:
value- allowed object isParseUnsupportedSyntax
-
getParseUnknownFunctions
public ParseUnknownFunctions getParseUnknownFunctions()
[#7344] Whether the parser should accept unknown functions.- Returns:
- possible object is
ParseUnknownFunctions
-
setParseUnknownFunctions
public void setParseUnknownFunctions(ParseUnknownFunctions value)
Sets the value of the parseUnknownFunctions property.- Parameters:
value- allowed object isParseUnknownFunctions
-
isParseIgnoreComments
public Boolean isParseIgnoreComments()
[#8325] Whether the parser should ignore content between ignore comment tokens.- Returns:
- possible object is
Boolean
-
setParseIgnoreComments
public void setParseIgnoreComments(Boolean value)
Sets the value of the parseIgnoreComments property.- Parameters:
value- allowed object isBoolean
-
getParseIgnoreCommentStart
public String getParseIgnoreCommentStart()
[#8325] The ignore comment start token- Returns:
- possible object is
String
-
setParseIgnoreCommentStart
public void setParseIgnoreCommentStart(String value)
Sets the value of the parseIgnoreCommentStart property.- Parameters:
value- allowed object isString
-
getParseIgnoreCommentStop
public String getParseIgnoreCommentStop()
[#8325] The ignore comment stop token- Returns:
- possible object is
String
-
setParseIgnoreCommentStop
public void setParseIgnoreCommentStop(String value)
Sets the value of the parseIgnoreCommentStop property.- Parameters:
value- allowed object isString
-
getParseSearchPath
public List<ParseSearchSchema> getParseSearchPath()
-
setParseSearchPath
public void setParseSearchPath(List<ParseSearchSchema> parseSearchPath)
-
withRenderMapping
public Settings withRenderMapping(RenderMapping value)
-
withRenderQuotedNames
public Settings withRenderQuotedNames(RenderQuotedNames value)
-
withRenderNameCase
public Settings withRenderNameCase(RenderNameCase value)
-
withRenderNameStyle
public Settings withRenderNameStyle(RenderNameStyle value)
-
withRenderKeywordCase
public Settings withRenderKeywordCase(RenderKeywordCase value)
-
withRenderKeywordStyle
public Settings withRenderKeywordStyle(RenderKeywordStyle value)
-
withRenderFormatting
public Settings withRenderFormatting(RenderFormatting value)
-
withRenderScalarSubqueriesForStoredFunctions
public Settings withRenderScalarSubqueriesForStoredFunctions(Boolean value)
-
withRenderOrderByRownumberForEmulatedPagination
public Settings withRenderOrderByRownumberForEmulatedPagination(Boolean value)
-
withRenderOutputForSQLServerReturningClause
public Settings withRenderOutputForSQLServerReturningClause(Boolean value)
-
withRenderParenthesisAroundSetOperationQueries
public Settings withRenderParenthesisAroundSetOperationQueries(Boolean value)
-
withFetchTriggerValuesAfterSQLServerOutput
public Settings withFetchTriggerValuesAfterSQLServerOutput(Boolean value)
-
withBackslashEscaping
public Settings withBackslashEscaping(BackslashEscaping value)
-
withParamCastMode
public Settings withParamCastMode(ParamCastMode value)
-
withStatementType
public Settings withStatementType(StatementType value)
-
withTransactionListenerStartInvocationOrder
public Settings withTransactionListenerStartInvocationOrder(InvocationOrder value)
-
withTransactionListenerEndInvocationOrder
public Settings withTransactionListenerEndInvocationOrder(InvocationOrder value)
-
withVisitListenerStartInvocationOrder
public Settings withVisitListenerStartInvocationOrder(InvocationOrder value)
-
withVisitListenerEndInvocationOrder
public Settings withVisitListenerEndInvocationOrder(InvocationOrder value)
-
withRecordListenerStartInvocationOrder
public Settings withRecordListenerStartInvocationOrder(InvocationOrder value)
-
withRecordListenerEndInvocationOrder
public Settings withRecordListenerEndInvocationOrder(InvocationOrder value)
-
withExecuteListenerStartInvocationOrder
public Settings withExecuteListenerStartInvocationOrder(InvocationOrder value)
-
withExecuteListenerEndInvocationOrder
public Settings withExecuteListenerEndInvocationOrder(InvocationOrder value)
-
withExecuteWithOptimisticLockingExcludeUnversioned
public Settings withExecuteWithOptimisticLockingExcludeUnversioned(Boolean value)
-
withThrowExceptions
public Settings withThrowExceptions(ThrowExceptions value)
-
withReturnIdentityOnUpdatableRecord
public Settings withReturnIdentityOnUpdatableRecord(Boolean value)
-
withMapConstructorParameterNamesInKotlin
public Settings withMapConstructorParameterNamesInKotlin(Boolean value)
-
withQueryPoolable
public Settings withQueryPoolable(QueryPoolable value)
-
withEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly
public Settings withEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value)
-
withExecuteUpdateWithoutWhere
public Settings withExecuteUpdateWithoutWhere(ExecuteWithoutWhere value)
-
withExecuteDeleteWithoutWhere
public Settings withExecuteDeleteWithoutWhere(ExecuteWithoutWhere value)
-
withParseDialect
public Settings withParseDialect(SQLDialect value)
-
withParseWithMetaLookups
public Settings withParseWithMetaLookups(ParseWithMetaLookups value)
-
withParseUnsupportedSyntax
public Settings withParseUnsupportedSyntax(ParseUnsupportedSyntax value)
-
withParseUnknownFunctions
public Settings withParseUnknownFunctions(ParseUnknownFunctions value)
-
withParseSearchPath
public Settings withParseSearchPath(ParseSearchSchema... values)
-
withParseSearchPath
public Settings withParseSearchPath(Collection<ParseSearchSchema> values)
-
withParseSearchPath
public Settings withParseSearchPath(List<ParseSearchSchema> parseSearchPath)
-
appendTo
public final void appendTo(XMLBuilder builder)
- Specified by:
appendToin interfaceXMLAppendable
-
-