Settings (jOOQ 3.11.12 API)

java.lang.Object
- org.jooq.conf.Settings

All Implemented Interfaces:

Serializable, Cloneable
```
public class Settings
extends Object
implements Serializable, Cloneable
```
Settings that influence the way jOOQ renders SQL code.

See Also:

Serialized Form

Field Summary

Fields
Modifier and Type	Field and Description
`protected Boolean`	`attachRecords`
`protected BackslashEscaping`	`backslashEscaping`
`protected Boolean`	`cacheRecordMappers`
`protected Boolean`	`debugInfoOnStackTrace`
`protected String`	`delimiter`
`protected Boolean`	`emulateOnDuplicateKeyUpdateOnPrimaryKeyOnly`
`protected ExecuteWithoutWhere`	`executeDeleteWithoutWhere`
`protected Boolean`	`executeLogging`
`protected ExecuteWithoutWhere`	`executeUpdateWithoutWhere`
`protected Boolean`	`executeWithOptimisticLocking`
`protected Boolean`	`executeWithOptimisticLockingExcludeUnversioned`
`protected Integer`	`fetchServerOutputSize`
`protected Integer`	`fetchSize`
`protected Boolean`	`fetchWarnings`
`protected Integer`	`inListPadBase`
`protected Boolean`	`inListPadding`
`protected Boolean`	`mapConstructorParameterNames`
`protected Boolean`	`mapJPAAnnotations`
`protected Integer`	`maxRows`
`protected ParamCastMode`	`paramCastMode`
`protected ParamType`	`paramType`
`protected ParseUnknownFunctions`	`parseUnknownFunctions`
`protected ParseUnsupportedSyntax`	`parseUnsupportedSyntax`
`protected ParseWithMetaLookups`	`parseWithMetaLookups`
`protected Integer`	`queryTimeout`
`protected Boolean`	`reflectionCaching`
`protected Boolean`	`renderCatalog`
`protected Boolean`	`renderFormatted`
`protected RenderFormatting`	`renderFormatting`
`protected RenderKeywordStyle`	`renderKeywordStyle`
`protected RenderMapping`	`renderMapping`
`protected RenderNameStyle`	`renderNameStyle`
`protected Boolean`	`renderOrderByRownumberForEmulatedPagination`
`protected Boolean`	`renderScalarSubqueriesForStoredFunctions`
`protected Boolean`	`renderSchema`
`protected Boolean`	`returnAllOnUpdatableRecord`
`protected Boolean`	`returnRecordToPojo`
`protected StatementType`	`statementType`
`protected ThrowExceptions`	`throwExceptions`
`protected Boolean`	`updatablePrimaryKeys`

Constructor Summary

Constructors
Constructor and Description

Settings()

Constructors
Constructor and Description
`Settings()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`Object`	`clone()`
`boolean`	`equals(Object that)`
`BackslashEscaping`	`getBackslashEscaping()` Whether string literals should be escaped with backslash.
`String`	`getDelimiter()` [#5826] The delimiter character to be used to delimit statements in batches.
`ExecuteWithoutWhere`	`getExecuteDeleteWithoutWhere()` [#6771] Specifies whether DELETE statements are allowed to be executed lacking a WHERE clause.
`ExecuteWithoutWhere`	`getExecuteUpdateWithoutWhere()` [#6771] Specifies whether UPDATE statements are allowed to be executed lacking a WHERE clause.
`Integer`	`getFetchServerOutputSize()` Whether server output should be fetched after each query execution.
`Integer`	`getFetchSize()` The default JDBC fetchSize property that should be applied to all jOOQ queries, for which no specific fetchSize value was specified.
`Integer`	`getInListPadBase()` [#7095] The base to use to calculate the powers of when applying in list padding.
`Integer`	`getMaxRows()` The default JDBC maxRows property that should be applied to all jOOQ queries, for which no specific maxRows value was specified.
`ParamCastMode`	`getParamCastMode()` Whether rendered bind values should be cast to their respective type.
`ParamType`	`getParamType()` Specify how bind variables are to be rendered.
`ParseUnknownFunctions`	`getParseUnknownFunctions()` [#7344] Whether the parser should accept unknown functions.
`ParseUnsupportedSyntax`	`getParseUnsupportedSyntax()` [#5917] Whether the parser should accept unsupported (but known) syntax.
`ParseWithMetaLookups`	`getParseWithMetaLookups()` [#7163] Whether the parser should perform meta lookups in the Configuration's MetaProvider.
`Integer`	`getQueryTimeout()` The default JDBC queryTimeout property that should be applied to all jOOQ queries, for which no specific queryTimeout was specified.
`RenderFormatting`	`getRenderFormatting()` All sorts of formatting flags / settings.
`RenderKeywordStyle`	`getRenderKeywordStyle()` Whether SQL keywords should be rendered with upper or lower case.
`RenderMapping`	`getRenderMapping()` Configure render mapping for runtime schema / table rewriting in generated SQL.
`RenderNameStyle`	`getRenderNameStyle()` Whether rendered schema, table, column names, etc should be quoted in rendered SQL, or transformed in any other way.
`StatementType`	`getStatementType()` The type of statement that is to be executed.
`ThrowExceptions`	`getThrowExceptions()` A strategy defining how exceptions from the database / JDBC driver should be propagated
`int`	`hashCode()`
`Boolean`	`isAttachRecords()` Whether fetched records should be attached to the fetching configuration.
`Boolean`	`isCacheRecordMappers()` Whether record mappers should be cached in the configuration.
`Boolean`	`isDebugInfoOnStackTrace()` [#5570] Whether exception stack traces should be enhanced with additional debug information.
`Boolean`	`isEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly()` [#6462] Use only the primary key to emulate MySQL's INSERT ..
`Boolean`	`isExecuteLogging()` When set to true, this will add jOOQ's default logging ExecuteListeners.
`Boolean`	`isExecuteWithOptimisticLocking()` Whether store() and delete() methods should be executed with optimistic locking.
`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.
`Boolean`	`isFetchWarnings()` Whether warnings should be fetched after each query execution.
`Boolean`	`isInListPadding()` [#5600] Whether IN lists in IN predicates should be padded to powers of inListPadBase (default 2).
`Boolean`	`isMapConstructorParameterNames()` Whether constructor parameter names obtained via reflection in Java 8+ should be considered by the DefaultRecordMapper.
`Boolean`	`isMapJPAAnnotations()` Whether JPA annotations should be considered by the DefaultRecordMapper.
`Boolean`	`isReflectionCaching()` Whether reflection information should be cached in the configuration.
`Boolean`	`isRenderCatalog()` Whether any catalog name should be rendered at all.
`Boolean`	`isRenderFormatted()` Whether rendered SQL should be pretty-printed.
`Boolean`	`isRenderOrderByRownumberForEmulatedPagination()` Whether an additional `ORDER BY rn` clause should be rendered on emulated paginated queries.
`Boolean`	`isRenderScalarSubqueriesForStoredFunctions()` Whether stored function calls should be wrapped in scalar subqueries.
`Boolean`	`isRenderSchema()` Whether any schema name should be rendered at all.
`Boolean`	`isReturnAllOnUpdatableRecord()` Whether calls to store(), insert() and update() should return all columns, not just identity columns.
`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 if is active, also other values.
`Boolean`	`isUpdatablePrimaryKeys()` Whether primary key values are deemed to be "updatable" in jOOQ.
`void`	`setAttachRecords(Boolean value)` Sets the value of the attachRecords property.
`void`	`setBackslashEscaping(BackslashEscaping value)` Sets the value of the backslashEscaping property.
`void`	`setCacheRecordMappers(Boolean value)` Sets the value of the cacheRecordMappers property.
`void`	`setDebugInfoOnStackTrace(Boolean value)` Sets the value of the debugInfoOnStackTrace property.
`void`	`setDelimiter(String value)` Sets the value of the delimiter property.
`void`	`setEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value)` Sets the value of the emulateOnDuplicateKeyUpdateOnPrimaryKeyOnly property.
`void`	`setExecuteDeleteWithoutWhere(ExecuteWithoutWhere value)` Sets the value of the executeDeleteWithoutWhere property.
`void`	`setExecuteLogging(Boolean value)` Sets the value of the executeLogging property.
`void`	`setExecuteUpdateWithoutWhere(ExecuteWithoutWhere value)` Sets the value of the executeUpdateWithoutWhere property.
`void`	`setExecuteWithOptimisticLocking(Boolean value)` Sets the value of the executeWithOptimisticLocking property.
`void`	`setExecuteWithOptimisticLockingExcludeUnversioned(Boolean value)` Sets the value of the executeWithOptimisticLockingExcludeUnversioned property.
`void`	`setFetchServerOutputSize(Integer value)` Sets the value of the fetchServerOutputSize property.
`void`	`setFetchSize(Integer value)` Sets the value of the fetchSize property.
`void`	`setFetchWarnings(Boolean value)` Sets the value of the fetchWarnings property.
`void`	`setInListPadBase(Integer value)` Sets the value of the inListPadBase property.
`void`	`setInListPadding(Boolean value)` Sets the value of the inListPadding property.
`void`	`setMapConstructorParameterNames(Boolean value)` Sets the value of the mapConstructorParameterNames property.
`void`	`setMapJPAAnnotations(Boolean value)` Sets the value of the mapJPAAnnotations property.
`void`	`setMaxRows(Integer value)` Sets the value of the maxRows property.
`void`	`setParamCastMode(ParamCastMode value)` Sets the value of the paramCastMode property.
`void`	`setParamType(ParamType value)` Sets the value of the paramType property.
`void`	`setParseUnknownFunctions(ParseUnknownFunctions value)` Sets the value of the parseUnknownFunctions property.
`void`	`setParseUnsupportedSyntax(ParseUnsupportedSyntax value)` Sets the value of the parseUnsupportedSyntax property.
`void`	`setParseWithMetaLookups(ParseWithMetaLookups value)` Sets the value of the parseWithMetaLookups property.
`void`	`setQueryTimeout(Integer value)` Sets the value of the queryTimeout property.
`void`	`setReflectionCaching(Boolean value)` Sets the value of the reflectionCaching property.
`void`	`setRenderCatalog(Boolean value)` Sets the value of the renderCatalog property.
`void`	`setRenderFormatted(Boolean value)` Sets the value of the renderFormatted property.
`void`	`setRenderFormatting(RenderFormatting value)` Sets the value of the renderFormatting property.
`void`	`setRenderKeywordStyle(RenderKeywordStyle value)` Sets the value of the renderKeywordStyle property.
`void`	`setRenderMapping(RenderMapping value)` Sets the value of the renderMapping property.
`void`	`setRenderNameStyle(RenderNameStyle value)` Sets the value of the renderNameStyle property.
`void`	`setRenderOrderByRownumberForEmulatedPagination(Boolean value)` Sets the value of the renderOrderByRownumberForEmulatedPagination property.
`void`	`setRenderScalarSubqueriesForStoredFunctions(Boolean value)` Sets the value of the renderScalarSubqueriesForStoredFunctions property.
`void`	`setRenderSchema(Boolean value)` Sets the value of the renderSchema property.
`void`	`setReturnAllOnUpdatableRecord(Boolean value)` Sets the value of the returnAllOnUpdatableRecord property.
`void`	`setReturnRecordToPojo(Boolean value)` Sets the value of the returnRecordToPojo property.
`void`	`setStatementType(StatementType value)` Sets the value of the statementType property.
`void`	`setThrowExceptions(ThrowExceptions value)` Sets the value of the throwExceptions property.
`void`	`setUpdatablePrimaryKeys(Boolean value)` Sets the value of the updatablePrimaryKeys property.
`String`	`toString()`
`Settings`	`withAttachRecords(Boolean value)`
`Settings`	`withBackslashEscaping(BackslashEscaping value)`
`Settings`	`withCacheRecordMappers(Boolean value)`
`Settings`	`withDebugInfoOnStackTrace(Boolean value)`
`Settings`	`withDelimiter(String value)`
`Settings`	`withEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value)`
`Settings`	`withExecuteDeleteWithoutWhere(ExecuteWithoutWhere value)`
`Settings`	`withExecuteLogging(Boolean value)`
`Settings`	`withExecuteUpdateWithoutWhere(ExecuteWithoutWhere value)`
`Settings`	`withExecuteWithOptimisticLocking(Boolean value)`
`Settings`	`withExecuteWithOptimisticLockingExcludeUnversioned(Boolean value)`
`Settings`	`withFetchServerOutputSize(Integer value)`
`Settings`	`withFetchSize(Integer value)`
`Settings`	`withFetchWarnings(Boolean value)`
`Settings`	`withInListPadBase(Integer value)`
`Settings`	`withInListPadding(Boolean value)`
`Settings`	`withMapConstructorParameterNames(Boolean value)`
`Settings`	`withMapJPAAnnotations(Boolean value)`
`Settings`	`withMaxRows(Integer value)`
`Settings`	`withParamCastMode(ParamCastMode value)`
`Settings`	`withParamType(ParamType value)`
`Settings`	`withParseUnknownFunctions(ParseUnknownFunctions value)`
`Settings`	`withParseUnsupportedSyntax(ParseUnsupportedSyntax value)`
`Settings`	`withParseWithMetaLookups(ParseWithMetaLookups value)`
`Settings`	`withQueryTimeout(Integer value)`
`Settings`	`withReflectionCaching(Boolean value)`
`Settings`	`withRenderCatalog(Boolean value)`
`Settings`	`withRenderFormatted(Boolean value)`
`Settings`	`withRenderFormatting(RenderFormatting value)`
`Settings`	`withRenderKeywordStyle(RenderKeywordStyle value)`
`Settings`	`withRenderMapping(RenderMapping value)`
`Settings`	`withRenderNameStyle(RenderNameStyle value)`
`Settings`	`withRenderOrderByRownumberForEmulatedPagination(Boolean value)`
`Settings`	`withRenderScalarSubqueriesForStoredFunctions(Boolean value)`
`Settings`	`withRenderSchema(Boolean value)`
`Settings`	`withReturnAllOnUpdatableRecord(Boolean value)`
`Settings`	`withReturnRecordToPojo(Boolean value)`
`Settings`	`withStatementType(StatementType value)`
`Settings`	`withThrowExceptions(ThrowExceptions value)`
`Settings`	`withUpdatablePrimaryKeys(Boolean value)`

Methods inherited from class java.lang.Object
finalize, getClass, notify, notifyAll, wait, wait, wait

- Field Detail
  - renderCatalog
```
protected Boolean renderCatalog
```
  - renderSchema
```
protected Boolean renderSchema
```
  - renderMapping
```
protected RenderMapping renderMapping
```
  - renderNameStyle
```
protected RenderNameStyle renderNameStyle
```
  - renderKeywordStyle
```
protected RenderKeywordStyle renderKeywordStyle
```
  - renderFormatted
```
protected Boolean renderFormatted
```
  - renderFormatting
```
protected RenderFormatting renderFormatting
```
  - renderScalarSubqueriesForStoredFunctions
```
protected Boolean renderScalarSubqueriesForStoredFunctions
```
  - renderOrderByRownumberForEmulatedPagination
```
protected Boolean renderOrderByRownumberForEmulatedPagination
```
  - backslashEscaping
```
protected BackslashEscaping backslashEscaping
```
  - paramType
```
protected ParamType paramType
```
  - paramCastMode
```
protected ParamCastMode paramCastMode
```
  - statementType
```
protected StatementType statementType
```
  - executeLogging
```
protected Boolean executeLogging
```
  - 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
```
  - returnAllOnUpdatableRecord
```
protected Boolean returnAllOnUpdatableRecord
```
  - returnRecordToPojo
```
protected Boolean returnRecordToPojo
```
  - mapJPAAnnotations
```
protected Boolean mapJPAAnnotations
```
  - mapConstructorParameterNames
```
protected Boolean mapConstructorParameterNames
```
  - 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
```
  - parseWithMetaLookups
```
protected ParseWithMetaLookups parseWithMetaLookups
```
  - parseUnsupportedSyntax
```
protected ParseUnsupportedSyntax parseUnsupportedSyntax
```
  - parseUnknownFunctions
```
protected ParseUnknownFunctions parseUnknownFunctions
```
- Constructor Detail
  - Settings
```
public Settings()
```
- 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 is Boolean
  - 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 is Boolean
  - 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 is RenderMapping
  - getRenderNameStyle
```
public RenderNameStyle getRenderNameStyle()
```
    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 is RenderNameStyle
  - getRenderKeywordStyle
```
public RenderKeywordStyle getRenderKeywordStyle()
```
    Whether SQL keywords should be rendered with upper or lower case.
    
    Returns:
    
    possible object is RenderKeywordStyle
  - setRenderKeywordStyle
```
public void setRenderKeywordStyle(RenderKeywordStyle value)
```
    Sets the value of the renderKeywordStyle property.
    
    Parameters:
    
    value - allowed object is RenderKeywordStyle
  - 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 is Boolean
  - 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 is RenderFormatting
  - 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 is Boolean
  - isRenderOrderByRownumberForEmulatedPagination
```
public Boolean isRenderOrderByRownumberForEmulatedPagination()
```
    Whether an additional ORDER BY rn clause 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) or ROW_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 excess ORDER BY clause may add some additional performance overhead. This setting forces jOOQ to not generate the additional ORDER BY clause.
    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 is Boolean
  - 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 is BackslashEscaping
  - 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 is ParamType
  - 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 is ParamCastMode
  - 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 is StatementType
  - 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 is Boolean
  - 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 is Boolean
  - 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 is Boolean
  - 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 is Boolean
  - 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 is Boolean
  - 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 is Boolean
  - 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 is Boolean
  - 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 is ThrowExceptions
  - 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 is Boolean
  - 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 is Integer
  - 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 is Boolean
  - 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 if is 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 is Boolean
  - 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 is Boolean
  - 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 is Boolean
  - 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 is Integer
  - 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 is Integer
  - 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 is Integer
  - 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 is Boolean
  - 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 is Boolean
  - 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 is Integer
  - 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 is String
  - 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 is Boolean
  - 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 is ExecuteWithoutWhere
  - 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 is ExecuteWithoutWhere
  - 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 is ParseWithMetaLookups
  - 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 is ParseUnsupportedSyntax
  - 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 is ParseUnknownFunctions
  - withRenderCatalog
```
public Settings withRenderCatalog(Boolean value)
```
  - withRenderSchema
```
public Settings withRenderSchema(Boolean value)
```
  - withRenderMapping
```
public Settings withRenderMapping(RenderMapping value)
```
  - withRenderNameStyle
```
public Settings withRenderNameStyle(RenderNameStyle value)
```
  - withRenderKeywordStyle
```
public Settings withRenderKeywordStyle(RenderKeywordStyle value)
```
  - withRenderFormatted
```
public Settings withRenderFormatted(Boolean value)
```
  - withRenderFormatting
```
public Settings withRenderFormatting(RenderFormatting value)
```
  - withRenderScalarSubqueriesForStoredFunctions
```
public Settings withRenderScalarSubqueriesForStoredFunctions(Boolean value)
```
  - withRenderOrderByRownumberForEmulatedPagination
```
public Settings withRenderOrderByRownumberForEmulatedPagination(Boolean value)
```
  - withBackslashEscaping
```
public Settings withBackslashEscaping(BackslashEscaping value)
```
  - withParamType
```
public Settings withParamType(ParamType value)
```
  - withParamCastMode
```
public Settings withParamCastMode(ParamCastMode value)
```
  - withStatementType
```
public Settings withStatementType(StatementType value)
```
  - withExecuteLogging
```
public Settings withExecuteLogging(Boolean value)
```
  - withExecuteWithOptimisticLocking
```
public Settings withExecuteWithOptimisticLocking(Boolean value)
```
  - withExecuteWithOptimisticLockingExcludeUnversioned
```
public Settings withExecuteWithOptimisticLockingExcludeUnversioned(Boolean value)
```
  - withAttachRecords
```
public Settings withAttachRecords(Boolean value)
```
  - withUpdatablePrimaryKeys
```
public Settings withUpdatablePrimaryKeys(Boolean value)
```
  - withReflectionCaching
```
public Settings withReflectionCaching(Boolean value)
```
  - withCacheRecordMappers
```
public Settings withCacheRecordMappers(Boolean value)
```
  - withThrowExceptions
```
public Settings withThrowExceptions(ThrowExceptions value)
```
  - withFetchWarnings
```
public Settings withFetchWarnings(Boolean value)
```
  - withFetchServerOutputSize
```
public Settings withFetchServerOutputSize(Integer value)
```
  - withReturnAllOnUpdatableRecord
```
public Settings withReturnAllOnUpdatableRecord(Boolean value)
```
  - withReturnRecordToPojo
```
public Settings withReturnRecordToPojo(Boolean value)
```
  - withMapJPAAnnotations
```
public Settings withMapJPAAnnotations(Boolean value)
```
  - withMapConstructorParameterNames
```
public Settings withMapConstructorParameterNames(Boolean value)
```
  - withQueryTimeout
```
public Settings withQueryTimeout(Integer value)
```
  - withMaxRows
```
public Settings withMaxRows(Integer value)
```
  - withFetchSize
```
public Settings withFetchSize(Integer value)
```
  - withDebugInfoOnStackTrace
```
public Settings withDebugInfoOnStackTrace(Boolean value)
```
  - withInListPadding
```
public Settings withInListPadding(Boolean value)
```
  - withInListPadBase
```
public Settings withInListPadBase(Integer value)
```
  - withDelimiter
```
public Settings withDelimiter(String value)
```
  - withEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly
```
public Settings withEmulateOnDuplicateKeyUpdateOnPrimaryKeyOnly(Boolean value)
```
  - withExecuteUpdateWithoutWhere
```
public Settings withExecuteUpdateWithoutWhere(ExecuteWithoutWhere value)
```
  - withExecuteDeleteWithoutWhere
```
public Settings withExecuteDeleteWithoutWhere(ExecuteWithoutWhere value)
```
  - withParseWithMetaLookups
```
public Settings withParseWithMetaLookups(ParseWithMetaLookups value)
```
  - withParseUnsupportedSyntax
```
public Settings withParseUnsupportedSyntax(ParseUnsupportedSyntax value)
```
  - withParseUnknownFunctions
```
public Settings withParseUnknownFunctions(ParseUnknownFunctions value)
```
  - toString
```
public String toString()
```
    Overrides:
    
    toString in class Object
  - equals
```
public boolean equals(Object that)
```
    Overrides:
    
    equals in class Object
  - hashCode
```
public int hashCode()
```
    Overrides:
    
    hashCode in class Object
  - clone
```
public Object clone()
```
    Overrides:
    
    clone in class Object

Class Settings

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

renderCatalog

renderSchema

renderMapping

renderNameStyle

renderKeywordStyle

renderFormatted

renderFormatting

renderScalarSubqueriesForStoredFunctions

renderOrderByRownumberForEmulatedPagination

backslashEscaping

paramType

paramCastMode

statementType

executeLogging

executeWithOptimisticLocking

executeWithOptimisticLockingExcludeUnversioned

attachRecords

updatablePrimaryKeys

reflectionCaching

cacheRecordMappers

throwExceptions

fetchWarnings

fetchServerOutputSize

returnAllOnUpdatableRecord

returnRecordToPojo

mapJPAAnnotations

mapConstructorParameterNames

queryTimeout

maxRows

fetchSize

debugInfoOnStackTrace

inListPadding

inListPadBase

delimiter

emulateOnDuplicateKeyUpdateOnPrimaryKeyOnly

executeUpdateWithoutWhere

executeDeleteWithoutWhere

parseWithMetaLookups

parseUnsupportedSyntax

parseUnknownFunctions

Constructor Detail

Settings

Method Detail

isRenderCatalog

setRenderCatalog

isRenderSchema

setRenderSchema

getRenderMapping

setRenderMapping

getRenderNameStyle

setRenderNameStyle

getRenderKeywordStyle

setRenderKeywordStyle

isRenderFormatted

setRenderFormatted

getRenderFormatting

setRenderFormatting

isRenderScalarSubqueriesForStoredFunctions

setRenderScalarSubqueriesForStoredFunctions

isRenderOrderByRownumberForEmulatedPagination

setRenderOrderByRownumberForEmulatedPagination

getBackslashEscaping

setBackslashEscaping

getParamType

setParamType

getParamCastMode

setParamCastMode

getStatementType

setStatementType

isExecuteLogging

setExecuteLogging

isExecuteWithOptimisticLocking

setExecuteWithOptimisticLocking

isExecuteWithOptimisticLockingExcludeUnversioned