Top Description Methods
org.jooq

public Interface CloseableDSLContext

extends DSLContext, AutoCloseable
Known Direct Implementers
org.jooq.impl.DefaultCloseableDSLContext
Imports
java.sql.Connection, java.util.Properties, org.jooq.exception.DataAccessException, org.jooq.impl.DSL

A resourceful DSLContext that should be closed in a try-with-resources statement.

Method Summary

Modifier and TypeMethod and Description
public void
close()

Redeclares java.lang.AutoCloseable.close.

Close the underlying resources, if any resources have been allocated when constructing this DSLContext.
Inherited from org.jooq.DSLContext:
alterDatabasealterDatabasealterDatabasealterDatabaseIfExistsalterDatabaseIfExistsalterDatabaseIfExistsalterDomainalterDomainalterDomainalterDomainIfExistsalterDomainIfExistsalterDomainIfExistsalterIndexalterIndexalterIndexalterIndexIfExistsalterIndexIfExistsalterIndexIfExistsalterSchemaalterSchemaalterSchemaalterSchemaIfExistsalterSchemaIfExistsalterSchemaIfExistsalterSequencealterSequencealterSequencealterSequenceIfExistsalterSequenceIfExistsalterSequenceIfExistsalterTablealterTablealterTablealterTableIfExistsalterTableIfExistsalterTableIfExistsalterTypealterTypealterViewalterViewalterViewalterViewalterViewalterViewIfExistsalterViewIfExistsalterViewIfExistsattachattachbatchbatchbatchbatchbatchbatchbatchbatchbatchDeletebatchDeletebatchedbatchedResultbatchInsertbatchInsertbatchMergebatchMergebatchStorebatchStorebatchUpdatebatchUpdatebeginbeginbindContextcommentOnColumncommentOnColumncommentOnColumncommentOnTablecommentOnTablecommentOnTablecommentOnViewcommentOnViewcommentOnViewcommitconnectionconnectionResultcreateDatabasecreateDatabasecreateDatabasecreateDatabaseIfNotExistscreateDatabaseIfNotExistscreateDatabaseIfNotExistscreateDomaincreateDomaincreateDomaincreateDomainIfNotExistscreateDomainIfNotExistscreateDomainIfNotExistscreateGlobalTemporaryTablecreateGlobalTemporaryTablecreateGlobalTemporaryTablecreateGlobalTemporaryTableIfNotExistscreateGlobalTemporaryTableIfNotExistscreateGlobalTemporaryTableIfNotExistscreateIndexcreateIndexcreateIndexcreateIndexcreateIndexIfNotExistscreateIndexIfNotExistscreateIndexIfNotExistscreateIndexIfNotExistscreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateSchemacreateSchemacreateSchemacreateSchemaIfNotExistscreateSchemaIfNotExistscreateSchemaIfNotExistscreateSequencecreateSequencecreateSequencecreateSequenceIfNotExistscreateSequenceIfNotExistscreateSequenceIfNotExistscreateTablecreateTablecreateTablecreateTableIfNotExistscreateTableIfNotExistscreateTableIfNotExistscreateTemporaryTablecreateTemporaryTablecreateTemporaryTablecreateTemporaryTableIfNotExistscreateTemporaryTableIfNotExistscreateTemporaryTableIfNotExistscreateTypecreateTypecreateUniqueIndexcreateUniqueIndexcreateUniqueIndexcreateUniqueIndexcreateUniqueIndexIfNotExistscreateUniqueIndexIfNotExistscreateUniqueIndexIfNotExistscreateUniqueIndexIfNotExistscreateViewcreateViewcreateViewcreateViewcreateViewcreateViewcreateViewcreateViewcreateViewcreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscurrvalcurrvalcurrvalddlddlddlddlddlddlddlddlddlddlddlddlddlddlddldeletedeleteFromdeleteQuerydiagnosticsConnectiondiagnosticsDataSourcedropDatabasedropDatabasedropDatabasedropDatabaseIfExistsdropDatabaseIfExistsdropDatabaseIfExistsdropDomaindropDomaindropDomaindropDomainIfExistsdropDomainIfExistsdropDomainIfExistsdropIndexdropIndexdropIndexdropIndexIfExistsdropIndexIfExistsdropIndexIfExistsdropSchemadropSchemadropSchemadropSchemaIfExistsdropSchemaIfExistsdropSchemaIfExistsdropSequencedropSequencedropSequencedropSequenceIfExistsdropSequenceIfExistsdropSequenceIfExistsdropTabledropTabledropTabledropTableIfExistsdropTableIfExistsdropTableIfExistsdropTemporaryTabledropTemporaryTabledropTemporaryTabledropTemporaryTableIfExistsdropTemporaryTableIfExistsdropTemporaryTableIfExistsdropTypedropTypedropTypedropTypedropTypedropTypeIfExistsdropTypeIfExistsdropTypeIfExistsdropTypeIfExistsdropTypeIfExistsdropViewdropViewdropViewdropViewIfExistsdropViewIfExistsdropViewIfExistsexecuteexecuteexecuteexecuteexecuteexecuteDeleteexecuteDeleteexecuteInsertexecuteUpdateexecuteUpdateexplainextractBindValuesextractParamextractParamsfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchfetchAnyfetchAnyfetchAnyfetchAnyfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchAsyncfetchByExamplefetchCountfetchCountfetchCountfetchCountfetchCountfetchExistsfetchExistsfetchExistsfetchExistsfetchExistsfetchFromCSVfetchFromCSVfetchFromCSVfetchFromCSVfetchFromHTMLfetchFromJSONfetchFromStringDatafetchFromStringDatafetchFromStringDatafetchFromTXTfetchFromTXTfetchFromXMLfetchGroupsfetchLazyfetchLazyfetchLazyfetchLazyfetchLazyfetchLazyfetchLazyfetchLazyfetchLazyfetchLazyfetchLazyfetchLazyfetchLazyfetchManyfetchManyfetchManyfetchManyfetchManyfetchMapfetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOnefetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalfetchOptionalValuefetchOptionalValuefetchOptionalValuefetchOptionalValuefetchOptionalValuefetchOptionalValuefetchOptionalValuefetchOptionalValuefetchOptionalValuefetchOptionalValuefetchOptionalValuefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchSinglefetchStreamfetchStreamfetchStreamfetchStreamfetchStreamfetchStreamfetchStreamfetchStreamfetchStreamfetchStreamfetchStreamfetchStreamfetchStreamfetchValuefetchValuefetchValuefetchValuefetchValuefetchValuefetchValuefetchValuefetchValuefetchValuefetchValuefetchValuefetchValuefetchValuesfetchValuesfetchValuesfetchValuesfetchValuesfetchValuesfetchValuesfetchValuesfetchValuesfetchValuesfetchValuesfetchValuesgrantgrantgrantinformationSchemainformationSchemainformationSchemainformationSchemainformationSchemainformationSchemainsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertQuerylastIDloadIntomapmapmergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntometametametametametametametametametamigrationsmockmockResultnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewRecordnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnewResultnextvalnextvalnextvalnextvalsparserparsingConnectionparsingConnectionFactoryparsingDataSourcequeriesqueriesqueryqueryqueryqueryreleaseSavepointreleaseSavepointrenderrenderContextrenderInlinedrenderNamedOrInlinedParamsrenderNamedParamsresultQueryresultQueryresultQueryresultQueryrevokerevokerevokerevokeGrantOptionForrevokeGrantOptionForrevokeGrantOptionForrollbacksavepointsavepointselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectCountselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectFromselectFromselectFromselectFromselectFromselectFromselectOneselectQueryselectQueryselectZerosetsetsetCatalogsetCatalogsetCatalogsetLocalsetLocalsetSchemasetSchemasetSchemastartTransactiontransactiontransactiontransactionAsynctransactionAsynctransactionPublishertransactionResulttransactionResulttransactionResultAsynctransactionResultAsynctruncatetruncatetruncatetruncateTabletruncateTabletruncateTableupdateupdateQuerywithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursive

Method Detail

closeback to summary
public void close() throws DataAccessException

Redeclares java.lang.AutoCloseable.close.

Close the underlying resources, if any resources have been allocated when constructing this DSLContext.

Some DSLContext constructors, such as DSL#using(String), DSL#using(String, Properties), or DSL#using(String, String, String) allocate a Connection resource, which is inaccessible to the outside of the DSLContext implementation. Proper resource management must thus be done via this close() method.

Annotations
@Override
Exceptions
DataAccessException:
When something went wrong closing the underlying resources.