Module org.jooq
Package org.jooq.impl
package org.jooq.impl
This package contains jOOQ's implementation classes.
This package provides implementations for the jOOQ API from
org.jooq
, whose interfaces are constructed mostly through the
DSL
and DSLContext
classes, which hide
implementation facts from the public API.
-
ClassDescriptionAbstractBinding<T,
U> A convenient base implementation for custom bindings, simplifies the implementation.A base implementation forConfiguration
classes, implementing the usual convenience API.AbstractConverter<T,U> Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codeA common base class for stored proceduresAn SPI that can be used to providejakarta.persistence
style annotations to theDefaultRecordMapper
.A common base class for Oracle ARRAY typesA common base class for Oracle associative array typesAGenerator
that can be used for audit columns, whose values are defined byConfiguration.auditProvider()
.AutoConverter<T,U> A base class for automatic conversion usingConfiguration.converterProvider()
.A binding that takes binary values but binds them asBlob
to at the JDBC level.An internal marker subtype ofDefaultDataType
, to be used only by built-in data types inSQLDataType
and dialect specific data type classes, such as e.g.The set of internal cache types.AnExecuteListener
that allows for functional composition.AFormattingProvider
that allows for functional composition.AParseListener
that allows for functional composition.ARecordListener
that allows for functional composition.ATransactionListener
that allows for functional composition.AVisitListener
that allows for functional composition.A common base class for database catalogsAMetaProvider
that provides its meta data based on (possibly generated) catalogs.A binding that takes binary values but binds them asClob
to at the JDBC level.A base class for customCondition
implementations in client code.CustomField<T>A base class for customField
implementations in client code.A base class for customQueryPart
implementations in client code.CustomRecord<R extends TableRecord<R>>A base class for customTableRecord
implementations in client code.A base class for customStatement
implementations in client code.CustomTable<R extends TableRecord<R>>A base class for customTable
implementations in client code.A common base implementation for generatedDAO
.A default implementation for a pooledDataSource
-orientedConnectionProvider
A binding that implements the date-as-timestamp semantics of the jOOQ code generator.Deprecated.- 3.15.0 - [#11505] - UseConverter.ofNullable(Class, Class, Function, Function)
instead, e.g.DefaultBinding<T,U> An extension ofDefaultDSLContext
that implements also theCloseableDSLContext
contract.A default implementation of theCommitProvider
SPI, which provides a materialisation of the currently available database version graph.A default implementation for configurations within aDSLContext
, if no custom configuration was supplied toDSL.using(Configuration)
.A default implementation forConnectionProvider
.A default converter provider offering the functionality ofConvert
.A common base class for data types.Deprecated.- 3.17.0 - [#13542] - This class is no longer needed.A default implementation forDiagnosticsListenerProvider
.A default implementation forDSLContext
.Deprecated.- 3.17.0 - [#13542] - This class is no longer needed.A default implementation forExecuteListenerProvider
.A defaultExecutor
implementation.A defaultExecutorProvider
implementation, providing aDefaultExecutor
instance.A default implementation for theFormattingProvider
.A default implementation of theMetaProvider
SPI, which provides meta data information based on the JDBCDatabaseMetaData
API.Deprecated.- 3.17.0 - [#13542] - This class is no longer needed.A default implementation forMigrationListenerProvider
.Deprecated.- 3.17.0 - [#13542] - This class is no longer needed.A default implementation forParseListenerProvider
.A default implementation of thePolicyProvider
SPI, offering a way to construct aPolicyProvider
.Deprecated.- 3.17.0 - [#13542] - This class is no longer needed.A default implementation forRecordListenerProvider
.This is the default implementation forRecordMapper
types, which applies toRecord.into(Class)
,Result.into(Class)
, and similar calls.A defaultRecordMapperProvider
implementation, providing aDefaultRecordMapper
instance.DefaultRecordUnmapper<E,R extends Record> A default implementation for unmapping a custom type to aRecord
.A defaultRecordUnmapperProvider
implementation, providing aDefaultRecordUnmapper
instance.Deprecated.- 3.17.0 - [#13542] - This class is no longer needed.A default implementation forTransactionListenerProvider
.A default implementation for theTransactionProvider
SPI.Deprecated.- 3.17.0 - [#13542] - This class is no longer needed.A default implementation forVisitListenerProvider
.DelegatingConverter<T,U> A DSL "entry point" providing implementations to theorg.jooq
interfaces.EmbeddableRecordImpl<R extends EmbeddableRecord<R>>A record implementation for a record originating from a single tableEnumConverter<T,U extends Enum<U>> A base class for enum conversion.This class is generated by jOOQ.This class is generated by jOOQ.A converter that doesn't convert anything.AMetaProvider
that provides its meta data based on JAXB-annotatedInformationSchema
meta information.A utility class that grants access to internal API, to be used only by generated code.A schema that references a lazy initialisableCatalog
singleton, for use in generated code.A schema that references a lazy initialisableSchema
singleton, for use in generated code.LazySupplier<T>A lazy supplierA binding that implements the date-as-timestamp semantics of the jOOQ code generator.A default implementation of aDiagnosticsListener
that logs diagnostics.A binding that takes binary values but binds them asNClob
to at the JDBC level.An "empty" implementation that is never connected.An "empty" implementation that is never transactional.A default implementation for packages (containers of stored procedures and functions)An exception that arises while parsing SQL throughDSLContext.parser()
.A draft of the new query object model API.TheABS
function.TheACOS
function.TheACOSH
function.TheACOTH
function.QOM.Add<T>TheADD
operator.QOM.Aliasable<Q extends QueryPart>TheALTER DATABASE
statement.TheALTER DOMAIN
statement.TheALTER INDEX
statement.TheALTER SCHEMA
statement.QOM.AlterSequence<T extends Number>TheALTER SEQUENCE
statement.TheALTER TYPE
statement.TheALTER VIEW
statement.TheAND
operator.QOM.AnyValue<T>TheANY VALUE
function.QOM.Array<T>QOM.ArrayAgg<T>TheARRAY ALL MATCH
function.TheARRAY ANY MATCH
function.TheARRAY APPEND
function.TheARRAY CONCAT
function.TheARRAY FILTER
function.QOM.ArrayGet<T>TheARRAY GET
function.QOM.ArrayMap<T,U> TheARRAY MAP
function.TheARRAY NONE MATCH
function.TheARRAY OVERLAP
function.TheARRAY PREPEND
function.TheARRAY REMOVE
function.TheARRAY REPLACE
function.TheARRAY TO STRING
function.TheASCII
function.TheASIN
function.TheASINH
function.TheATAN
function.TheATAN2
function.TheATANH
function.TheAVG
function.QOM.Between<T>TheBETWEEN
predicate.TheBINARY BIT LENGTH
function.TheBINARY CONCAT
function.TheBINARY LENGTH
function.TheBINARY LIKE
operator.TheBINARY LIKE
operator.TheBINARY LTRIM
function.TheBINARY MD5
function.TheBINARY OCTET LENGTH
function.TheBINARY OVERLAY
function.TheBINARY POSITION
function.TheBINARY RTRIM
function.TheBINARY SUBSTRING
function.TheBINARY TRIM
function.TheBIN TO UUID
function.QOM.BitAnd<T extends Number>TheBIT AND
operator.QOM.BitAndAgg<T extends Number>TheBIT AND AGG
function.TheBIT COUNT
function.QOM.BitGet<T extends Number>TheBIT GET
function.TheBIT LENGTH
function.QOM.BitNand<T extends Number>TheBIT NAND
operator.QOM.BitNandAgg<T extends Number>TheBIT NAND AGG
function.QOM.BitNor<T extends Number>TheBIT NOR
operator.QOM.BitNorAgg<T extends Number>TheBIT NOR AGG
function.QOM.BitNot<T extends Number>TheBIT NOT
operator.TheBIT OR
operator.QOM.BitOrAgg<T extends Number>TheBIT OR AGG
function.QOM.BitSet<T extends Number>TheBIT SET
function.QOM.BitXNor<T extends Number>TheBIT X NOR
operator.QOM.BitXNorAgg<T extends Number>TheBIT X NOR AGG
function.QOM.BitXor<T extends Number>TheBIT XOR
operator.QOM.BitXorAgg<T extends Number>TheBIT XOR AGG
function.TheBOOL AND
function.TheBOOL OR
function.TheCALL
statement.TheCARDINALITY
function.TheCascade
type.QOM.CaseSimple<V,T> QOM.Cast<T>TheCBRT
function.TheCEIL
function.TheCHAR LENGTH
function.ACHECK
constraint.QOM.Choose<T>TheCHR
function.QOM.Coalesce<T>QOM.Coerce<T>QOM.Collect<T,A extends ArrayRecord<T>> QOM.CombinedCondition<R extends QOM.CombinedCondition<R>>TheCOMMENT ON TABLE
statement.TheCOMMIT
statement.QOM.CompareCondition<T,R extends QOM.CompareCondition<T, R>> TheFIELD
function.TheCONNECT BY ISCYCLE
function.TheCONNECT BY ISLEAF
function.TheCONNECT BY ROOT
function.QOM.Contains<T>TheCONTAINS
operator.TheCONTAINS IGNORE CASE
operator.QOM.Convert<T>TheCORR
function.TheCOS
function.TheCOSH
function.TheCOT
function.TheCOTH
function.TheCOUNT
function.TheCOVAR POP
function.TheCOVAR SAMP
function.TheCREATE DATABASE
statement.TheCREATE DOMAIN
statement.TheCREATE FUNCTION
statement.TheCREATE INDEX
statement.TheCREATE PROCEDURE
statement.TheCREATE SCHEMA
statement.QOM.CreateSequence<T extends Number>TheCREATE SEQUENCE
statement.TheCREATE SYNONYM
statement.TheCREATE TABLE
statement.TheCREATE TRIGGER
statement.TheCREATE TYPE
statement.QOM.CreateView<R extends Record>TheCREATE VIEW
statement.QOM.CrossApply<R extends Record>QOM.CrossJoin<R extends Record>TheCUME DIST
function.TheCURRENT CATALOG
function.TheCURRENT SCHEMA
function.TheCURRENT USER
function.TheCycleOption
type.QOM.DataChangeDeltaTable<R extends Record>QOM.DateAdd<T>TheDATE ADD
function.QOM.Decode<V,T> QOM.Default<T>TheDEGREES
function.QOM.Delete<R extends Record>TheDELETE
statement.QOM.DeleteReturning<R extends Record>AnDELETE
statement with aRETURNING
clause.TheDELETING
function.TheDENSE RANK
function.QOM.DerivedTable<R extends Record>TheDeterministic
type.TheDIGITS
function.QOM.Div<T>TheDIV
operator.TheDocumentOrContent
type.TheDROP DATABASE
statement.TheDROP DOMAIN
statement.TheDROP FUNCTION
statement.TheDROP INDEX
statement.TheDROP PROCEDURE
statement.TheDROP SCHEMA
statement.TheDROP SEQUENCE
statement.TheDROP SYNONYM
statement.TheDROP TABLE
statement.TheDROP TRIGGER
statement.TheDROP TYPE
statement.TheDROP VIEW
statement.QOM.EndsWith<T>TheENDS WITH
operator.TheENDS WITH IGNORE CASE
operator.QOM.Eq<T>TheEQ
operator.TheEQ
operator.TheE
function.QOM.Excluded<T>TheEXCLUDED
function.TheEXECUTE
function.TheEXISTS
function.TheEXP
function.ACondition
that is alwaysFALSE
.TheCONDITION
function.TheFLOOR
function.AFOREIGN KEY
constraint.TheForeignKeyRule
type.TheFrameExclude
type.TheFrameUnits
type.TheFromFirstOrLast
type.QOM.FullJoin<R extends Record>QOM.Function<T>QOM.Ge<T>TheGE
operator.TheGenerationLocation
type.TheGenerationOption
type.TheGE
operator.TheGOTO
function.TheGRANT
statement.QOM.Greatest<T>QOM.Gt<T>TheGT
operator.TheGT
operator.QOM.HintedTable<R extends Record>A table with a MySQL style index access hint.TheIdentityRestartOption
type.QOM.Iif<T>QOM.In<T>TheIN
operator.QOM.InList<T>TheIN
predicate accepting a list of values.QOM.Insert<R extends Record>TheINSERT
statement.TheINSERTING
function.QOM.InsertReturning<R extends Record>AnINSERT
statement with aRETURNING
clause.TheIS DISTINCT FROM
operator.TheIS DOCUMENT
operator.TheIS JSON
operator.TheIS NOT DISTINCT FROM
operator.TheIS NOT DOCUMENT
operator.TheIS NOT JSON
operator.TheIS NOT NULL
operator.TheIS NULL
operator.TheJoinHint
type.TheJSON ARRAY
function.TheJSON ARRAY LENGTH
function.TheJSONB ARRAY LENGTH
function.TheJSONB GET ATTRIBUTE
function.TheJSONB GET ATTRIBUTE AS TEXT
function.TheJSONB GET ELEMENT
function.TheJSONB GET ELEMENT AS TEXT
function.TheJSONB INSERT
function.TheJSONB KEY EXISTS
function.TheJSONB KEYS
function.TheJSONB REMOVE
function.TheJSONB REPLACE
function.TheJSONB SET
function.TheJSON GET ATTRIBUTE
function.TheJSON GET ATTRIBUTE AS TEXT
function.TheJSON GET ELEMENT
function.TheJSON GET ELEMENT AS TEXT
function.TheJSON INSERT
function.TheJSON KEY EXISTS
function.TheJSON KEYS
function.TheJSON OBJECT
function.TheJSONOnNull
type.TheJSON REMOVE
function.TheJSON REPLACE
function.TheJSON SET
function.QOM.Lag<T>QOM.Lateral<R extends Record>QOM.Le<T>TheLE
operator.QOM.Lead<T>QOM.Least<T>TheLEFT
function.QOM.LeftAntiJoin<R extends Record>QOM.LeftJoin<R extends Record>QOM.LeftSemiJoin<R extends Record>TheLE
operator.TheLEVEL
function.TheLIKE
operator.TheLIKE IGNORE CASE
operator.TheLIKE
operator.QOM.LinkedTable<R extends Record>A table with a database link.TheLN
function.TheLOG
function.TheLOG10
function.TheLOWER
function.TheLPAD
function.QOM.Lt<T>TheLT
operator.TheLT
operator.TheLTRIM
function.TheMaterialized
type.QOM.Max<T>TheMAX
function.QOM.MaxBy<T>TheMAX BY
function.TheMD5
function.TheMEDIAN
function.QOM.Min<T>TheMIN
function.QOM.MinBy<T>TheMIN BY
function.TheMOD
operator.QOM.Mode<T>QOM.Mul<T>TheMUL
operator.QOM.Multiset<R extends Record>QOM.MultisetAgg<R extends Record>QOM.NaturalFullJoin<R extends Record>QOM.NaturalJoin<R extends Record>QOM.NaturalLeftJoin<R extends Record>QOM.NaturalRightJoin<R extends Record>QOM.Ne<T>TheNE
operator.QOM.Neg<T>TheNE
operator.TheNOT
operator.TheNOT BINARY LIKE
operator.TheNOT BINARY LIKE
operator.TheNOT
operator.QOM.NotIn<T>TheNOT IN
operator.TheNOT IN
predicate accepting a list of values.TheNOT LIKE
operator.TheNOT LIKE IGNORE CASE
operator.TheNOT LIKE
operator.TheNOT SIMILAR TO
operator.TheNOT SIMILAR TO
operator.Deprecated, for removal: This API element is subject to removal in a future version.- [#12425] - 3.16.0 - Missing implementations should be added as soon as possible!QOM.NthValue<T>ACondition
that is alwaysNULL
.TheNullCallClause
type.QOM.Nullif<T>TheNULLIF
function.TheNullOrdering
type.TheNullTreatment
type.QOM.Nvl<T>TheNVL
function.QOM.Nvl2<T>TheOCTET LENGTH
function.TheOR
operator.QOM.OuterApply<R extends Record>TheOVERLAY
function.ThePERCENTILE CONT
function.ThePERCENTILE DISC
function.ThePERCENT RANK
function.ThePI
function.QOM.PlusJoin<T>ThePLUS
operator.ThePOSITION
function.ThePOWER
operator.APRIMARY KEY
constraint.QOM.Prior<T>ThePRIOR
function.ThePRODUCT
function.TheROWID
operator.QOM.QuantifiedSelect<R extends Record>TheQuantifier
type.TheRADIANS
function.TheRAND
function.TheRANK
function.TheREGR AVGX
function.TheREGR AVGY
function.TheREGR COUNT
function.TheREGR INTERCEPT
function.TheREGR R2
function.TheREGR SLOPE
function.TheREGR SXX
function.TheREGR SXY
function.TheREGR SYY
function.TheRELEASE SAVEPOINT
statement.TheREPEAT
function.TheREPLACE
function.TheResultOption
type.TheRETURN_
function.TheREVERSE
function.TheREVOKE
statement.TheRIGHT
function.QOM.RightJoin<R extends Record>TheROLLBACK
statement.TheROOT
function.TheROUND
function.QOM.RowAsField<R extends Record>TheROW EQ
operator.TheROW GE
operator.TheROW GT
operator.TheROW LE
operator.TheROW LT
operator.TheROW NE
operator.TheROWNUM
function.TheRPAD
function.TheRTRIM
function.TheSAVEPOINT
statement.TheSET CATALOG
statement.TheSET
statement.TheSET SCHEMA
statement.TheSHL
operator.TheSHR
operator.TheSIGN
function.TheSIGNAL SQL STATE
function.TheSIMILAR TO
operator.TheSIMILAR TO
operator.TheSIN
function.TheSINH
function.TheSPACE
function.TheSPLIT PART
function.TheSQLDataAccess
type.TheSQRT
function.QOM.Square<T extends Number>TheSQUARE
function.TheST AREA
function.TheSTARTS WITH
operator.TheSTARTS WITH IGNORE CASE
operator.TheSTART TRANSACTION
statement.TheST ASBINARY
function.TheST ASTEXT
function.QOM.StBoundary<T extends Spatial>TheST BOUNDARY
function.TheST CENTROID
function.QOM.StContains<T extends Spatial>TheST CONTAINS
function.QOM.StCoveredBy<T extends Spatial>TheST COVEREDBY
function.QOM.StCovers<T extends Spatial>TheST COVERS
function.TheST CROSSES
function.TheSTDDEV POP
function.TheSTDDEV SAMP
function.QOM.StDifference<T extends Spatial>TheST DIFFERENCE
function.TheST DIMENSION
function.QOM.StDisjoint<T extends Spatial>TheST DISJOINT
function.QOM.StDistance<T extends Spatial>TheST DISTANCE
function.QOM.StEndPoint<T extends Spatial>TheST ENDPOINT
function.QOM.StEquals<T extends Spatial>TheST EQUALS
function.TheST EXTERIORRING
function.QOM.StGeometryN<T extends Spatial>TheST GEOMETRYN
function.TheST GEOMETRYTYPE
function.TheST GEOMFROMTEXT
function.TheST GEOMFROMWKB
function.TheST INTERIORRINGN
function.QOM.StIntersection<T extends Spatial>TheST INTERSECTION
function.QOM.StIntersects<T extends Spatial>TheST INTERSECTS
function.TheST ISCLOSED
function.TheST ISEMPTY
function.TheST ISRING
function.TheST ISSIMPLE
function.TheST ISVALID
function.TheST LENGTH
function.TheST NUMGEOMETRIES
function.TheST NUMINTERIORRING
function.TheST NUMPOINTS
function.QOM.StOverlaps<T extends Spatial>TheST OVERLAPS
function.QOM.StPerimeter<T extends Spatial>TheST PERIMETER
function.QOM.StPointN<T extends Spatial>TheST POINTN
function.QOM.StraightJoin<R extends Record>TheSTRING TO ARRAY
function.TheST SRID
function.QOM.StStartPoint<T extends Spatial>TheST STARTPOINT
function.QOM.StTouches<T extends Spatial>TheST TOUCHES
function.QOM.StTransform<T extends Spatial>TheST TRANSFORM
function.QOM.StUnion<T extends Spatial>TheST UNION
function.QOM.StWithin<T extends Spatial>TheST WITHIN
function.TheST X
function.TheST XMAX
function.TheST XMIN
function.TheST Y
function.TheST YMAX
function.TheST YMIN
function.TheST Z
function.TheST ZMAX
function.TheST ZMIN
function.QOM.Sub<T>TheSUB
operator.TheSUBSTRING
function.TheSUBSTRING INDEX
function.TheSUM
function.TheSYS CONNECT BY PATH
function.QOM.TableAlias<R extends Record>QOM.TableAsField<R extends Record>TheTableCommitAction
type.QOM.TableEq<R extends Record>TheEQ
operator.QOM.TableNe<R extends Record>TheNE
operator.TheTAN
function.TheTANH
function.TheTAU
function.TheTO CHAR
function.TheTO DATE
function.TheTO HEX
function.TheTO TIMESTAMP
function.TheTRANSLATE
function.TheTRIM
function.ACondition
that is alwaysTRUE
.TheTRUNC
function.QOM.Truncate<R extends Record>TheTRUNCATE
statement.QOM.TryCast<T>TheTRY CAST
function.A generic tuple of degree 2 for use inQOM
types.TheUNIQUE
function.AUNIQUE
constraint.QOM.UnmodifiableCollection<Q extends QueryPart>An unmodifiableCollection
ofQueryPart
elements.QOM.UnmodifiableList<Q extends QueryPart>QOM.Update<R extends Record>TheUPDATE
statement.QOM.UpdateReturning<R extends Record>AnUPDATE
statement with aRETURNING
clause.TheUPDATING
function.TheUPPER
function.TheUUID
function.TheUUID TO BIN
function.QOM.Values<R extends Record>TheVAR POP
function.TheVAR SAMP
function.QOM.WidthBucket<T extends Number>TheWIDTH BUCKET
function.QOM.WithOrdinalityTable<R extends Record>A collection derived table or table valued function with aWITH ORDINALITY
clause.TheWithOrWithoutData
type.QOM.WithTable<R extends Record>A table with a T-SQL styleWITH
hint.TheXMLCOMMENT
function.TheXMLCONCAT
function.TheXMLDOCUMENT
function.TheXMLFOREST
function.TheXMLPassingMechanism
type.TheXMLPI
function.TheXMLSERIALIZE
function.TheXOR
operator.A common base class for database schemataAMetaProvider
that provides its meta data based on (possibly generated) schemas.SequenceImpl<T extends Number>A common base class for sequencesThe SQL standard data types, as described inTypes
.A common base type for tablesAMetaProvider
that provides its meta data based on (possibly generated) schemas.TableRecordImpl<R extends TableRecord<R>>A record implementation for a record originating from a single tableATransactionProvider
that implements thread-bound transaction semantics.Deprecated.- 3.15.0 - [#11505] - UseConverter.ofNullable(Class, Class, Function, Function)
instead, e.g.Deprecated.- 3.15.0 - [#11505] - UseConverter.ofNullable(Class, Class, Function, Function)
instead, e.g.A common base type for UDT'sA common base type for UDT path fields.A common base type for table fields that are alsoUDTPathField
.UDTRecordImpl<R extends UDTRecord<R>>A record implementation for a record originating from a single UDTUpdatableRecordImpl<R extends UpdatableRecord<R>>A record implementation for a record holding a primary keyA base class forXML
to JAXB POJO conversion.