Uses of Interface
org.jooq.DataType
Packages that use DataType
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of DataType in org.jooq
Modifier and TypeMethodDescriptionTyped.$dataType()Experimental query object model accessor method, see alsoQOM.DataType.array()A convenient short for formgetArrayDataType()for DSL usage<A extends ArrayRecord<?>>
@NotNull DataType<A> DataType.asArrayDataType(Class<A> arrayDataType) Retrieve the data type for an Oracle-style ARRAY of this data type.<A extends AssociativeArrayRecord<?,?>>
@NotNull DataType<A> DataType.asAssociativeArrayDataType(Class<A> arrayDataType) Retrieve the data type for an Oracle-style associative array of this data type.default <U> @NotNull DataType<U> DataType.asConvertedDataType(Class<U> toType) Convenience method for converting this type usingAutoConverter.default <U> @NotNull DataType<U> DataType.asConvertedDataType(Class<U> toType, Function<? super T, ? extends U> from, Function<? super U, ? extends T> to) Convenience method for converting this type usingConverter.of(Class, Class, Function, Function).<U> @NotNull DataType<U> DataType.asConvertedDataType(Binding<? super T, U> binding) Retrieve the data type for a given binding.<U> @NotNull DataType<U> DataType.asConvertedDataType(Converter<? super T, U> converter) Retrieve the data type for a given converter.default <U> @NotNull DataType<U> DataType.asConvertedDataTypeFrom(Class<U> toType, Function<? super T, ? extends U> from) Convenience method for converting this type to a read-only type usingConverter.from(Class, Class, Function).default <U> @NotNull DataType<U> DataType.asConvertedDataTypeFrom(Function<? super T, ? extends U> from) Convenience method for converting this type to a read-only type usingConverter.from(Class, Class, Function).default <U> @NotNull DataType<U> DataType.asConvertedDataTypeTo(Class<U> toType, Function<? super U, ? extends T> to) Convenience method for converting this type to a write-only type usingConverter.to(Class, Class, Function).default <U> @NotNull DataType<U> DataType.asConvertedDataTypeTo(Function<? super U, ? extends T> to) Convenience method for converting this type to a write-only type usingConverter.to(Class, Class, Function).DataType.asEnumDataType(Class<E> enumDataType) Retrieve the data type for a given enum data type.DataType.autoIncrement()Return a new data type like this, with theidentity(boolean)flag set totrue.DataType.characterSet(CharacterSet characterSet) Return a new data type like this, with a new character set.Return a new data type like this, with a new collation.@Nullable DataType<?> Fields.dataType(int index) Get the field data type for a given field index, ornullif no field is available at the index.@Nullable DataType<?> Get the field data type for a given qualified field name, ornullif no field is known to this type by this name.@Nullable DataType<?> Get the field data type for a given qualified field name, ornullif no field is known to this type by this name.@NotNull DataType<?> @NotNull []Fields.dataTypes()Get an array of field data types for this type.Specify an expression to be applied as theDEFAULTvalue for this data type.Specify an expression to be applied as theDEFAULTvalue for this data type.DataType.defaultValue(Field<T> defaultValue) Specify an expression to be applied as theDEFAULTvalue for this data type.DataType.defaultValue(T defaultValue) Specify an expression to be applied as theDEFAULTvalue for this data type.DataType.generatedAlwaysAs(Field<T> generatedAlwaysAsValue) Set the computed column expression of this data type to a constant expression.DataType.generatedAlwaysAs(Generator<?, ?, T> generatedAlwaysAsValue) Set the computed column expression of this data type to a dynamic expression.DataType.generatedAlwaysAs(T generatedAlwaysAsValue) Set the computed column expression of this data type to a constant value.DataType.generatedAlwaysAsIdentity()Return a new data type like this, with theidentityMode(GenerationMode)flag set toQOM.GenerationMode.ALWAYS.DataType.generatedByDefaultAsIdentity()Return a new data type like this, with theidentityMode(GenerationMode)flag set toQOM.GenerationMode.BY_DEFAULT.DataType.generationLocation(QOM.GenerationLocation generationOption) Set thegenerationLocation()of the computed column expression.DataType.generationOption(QOM.GenerationOption generationOption) Set thegenerationOption()of the computed column expression.@NotNull DataType<?> DataType.getArrayBaseDataType()Retrieve the Java component data type if this is an ARRAY type, orthis, otherwise.@Nullable DataType<?> DataType.getArrayComponentDataType()Retrieve the Java component data type if this is an ARRAY type, ornull, otherwise.DataType.getArrayDataType()Retrieve the data type for an ARRAY of this data type.DataType<?> ArrayOrAssociativeArrayRecord.getArrayType()Get the data type of the array.ArrayOrAssociativeArrayRecord.getDataType()Get the data type of the array's base type.DataType.getDataType(Configuration configuration) The dialect-specific data type representing this data type.RecordQualifier.getDataType()Typed.getDataType()The type of this object (might not be dialect-specific).Typed.getDataType(Configuration configuration) The dialect-specific type of this object.AssociativeArrayRecord.getIndexDataType()Get the data type of the array's index type.DataType.getSQLDataType()Get the standard SQL data type of this (dialect-specific) data type if available.DataType.hidden(boolean hidden) Return a new data type like this, with a new hidden attribute.DataType.identity(boolean identity) Deprecated, for removal: This API element is subject to removal in a future version.DataType.identityMode(QOM.GenerationMode identity) Return a new data type like this, with a new identityQOM.GenerationMode.DataType.length(int length) Return a new data type like this, with a new length value.DataType.notNull()Synonym fornullable(boolean), passingfalseas an argument.DataType.null_()Synonym fornullable(boolean), passingtrueas an argument.DataType.nullability(Nullability nullability) Return a new data type like this, with a new nullability.DataType.nullable(boolean nullable) Return a new data type like this, with a new nullability.@NotNull DataType<?> ParseContext.parseDataType()Parse aDataTypeexpression or fail if the current expression is not a data type.DataType.precision(int precision) Return a new data type like this, with a new precision value.DataType.precision(int precision, int scale) Return a new data type like this, with a new precision and scale value.DataType.readonly(boolean readonly) Return a new data type like this, with a new readonly attribute.DataType.redacted(boolean redacted) Return a new data type like this, with a new redacted attribute.DataType.scale(int scale) Return a new data type like this, with a new scale value.DataType.stored()Set thegenerationOption()of the computed column expression toQOM.GenerationOption.STORED.DataType<?> FormatterContext.type()TheDataTypethat is being formatted.DataType.virtual()Set thegenerationOption()of the computed column expression toQOM.GenerationOption.VIRTUAL.Modifier and TypeMethodDescription@NotNull AlterTableAddStepAdd anADD COLUMNclause to theALTER TABLEstatement.<T> @NotNull AlterTableAddStepAdd anADD COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableAddStepAdd anADD COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableAddStepAdd anADD COLUMNclause to theALTER TABLEstatement.<T> @NotNull AlterTableAddStepAdd anADD COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableAddStepAdd anADD COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableAddStepAlterTableStep.addColumnIfNotExists(String field, DataType<?> type) Add anADD COLUMN IF NOT EXISTSclause to theALTER TABLEstatement.<T> @NotNull AlterTableAddStepAlterTableStep.addColumnIfNotExists(Field<T> field, DataType<T> type) Add anADD COLUMN IF NOT EXISTSclause to theALTER TABLEstatement.@NotNull AlterTableAddStepAlterTableStep.addColumnIfNotExists(Name field, DataType<?> type) Add anADD COLUMN IF NOT EXISTSclause to theALTER TABLEstatement.@NotNull AlterTableAddStepAlterTableStep.addIfNotExists(String field, DataType<?> type) Add anADD COLUMN IF NOT EXISTSclause to theALTER TABLEstatement.<T> @NotNull AlterTableAddStepAlterTableStep.addIfNotExists(Field<T> field, DataType<T> type) Add anADD COLUMN IF NOT EXISTSclause to theALTER TABLEstatement.@NotNull AlterTableAddStepAlterTableStep.addIfNotExists(Name field, DataType<?> type) Add anADD COLUMN IF NOT EXISTSclause to theALTER TABLEstatement.<T> @NotNull CreateDomainDefaultStep<T> Add theASclause to theCREATE DOMAINstatement.<T extends Number>
@NotNull CreateSequenceFlagsStep<T> Add theASclause to theCREATE SEQUENCEstatement.<Z> @NotNull Field<Z> Cast this field to a dialect-specific data type.<Z> @NotNull Field<Z> Coerce this field to a dialect-specific data type.@NotNull CreateTableElementListStepAdd theCOLUMNclause to theCREATE TABLEstatement.@NotNull CreateTableElementListStepAdd theCOLUMNclause to theCREATE TABLEstatement.@NotNull CreateTableElementListStepAdd theCOLUMNclause to theCREATE TABLEstatement.@NotNull JSONTableColumnPathStepAdd a column to theCOLUMNSclause of theJSON_TABLEexpression.@NotNull JSONTableColumnPathStepAdd a column to theCOLUMNSclause of theJSON_TABLEexpression.@NotNull JSONTableColumnPathStepAdd a column to theCOLUMNSclause of theJSON_TABLEexpression.@NotNull XMLTableColumnPathStepAdd a column to theCOLUMNSclause of theXMLTABLEexpression.@NotNull XMLTableColumnPathStepAdd a column to theCOLUMNSclause of theXMLTABLEexpression.@NotNull XMLTableColumnPathStepAdd a column to theCOLUMNSclause of theXMLTABLEexpression.@NotNull CompletionStage<Result<Record>> DSLContext.fetchAsync(ResultSet rs, DataType<?>... types) Fetch results in a newCompletionStage.@NotNull CompletionStage<Result<Record>> DSLContext.fetchAsync(Executor executor, ResultSet rs, DataType<?>... types) Fetch results in a newCompletionStagethat is asynchronously completed by a task running in the given executor.@Nullable RecordDSLContext.fetchOptional(ResultSet rs, DataType<?>... types) <T> @NotNull Optional<T> DSLContext.fetchOptionalValue(ResultSet rs, DataType<T> type) Fetch a record from a JDBCResultSetand return the only contained value.@NotNull RecordDSLContext.fetchSingle(ResultSet rs, DataType<?>... types) DSLContext.fetchStream(ResultSet rs, DataType<?>... types) <T> TDSLContext.fetchValue(ResultSet rs, DataType<T> type) Fetch a record from a JDBCResultSetand return the only contained value.<T> @NotNull List<T> DSLContext.fetchValues(ResultSet rs, DataType<T> type) Fetch a result from a JDBCResultSetand return the only contained column's values.<T> @Nullable Field<T> Get a field known to this type by index coerced todataTypeusingField.coerce(DataType), ornullif no field is available at the index.<T> @Nullable Field<T> Get a field known to this type by unqualified name coerced todataTypeusingField.coerce(DataType), ornullif no field is known to this type by this name.<T> @Nullable Field<T> Get a field known to this type by qualified name coerced todataTypeusingField.coerce(DataType), ornullif no field is known to this type by this name.@NotNull AggregateFilterStep<T> Add aRETURNINGclause to theJSON_ARRAYAGGfunction.Add theRETURNINGclause to theJSON ARRAYfunction.Add theRETURNINGclause to theJSON ARRAYfunction.@NotNull AggregateFilterStep<T> Add aRETURNINGclause to theJSON_ARRAYAGGfunction.Add theRETURNINGclause to theJSON OBJECTfunction.Add theRETURNINGclause to theJSON QUERYfunction.Add theRETURNINGclause to theJSON VALUEfunction.@NotNull CreateFunctionCharacteristicsStepAdd theRETURNSclause to theCREATE FUNCTIONstatement.@NotNull AlterTableFinalStepSpecify a new column data type.@NotNull AlterTableFinalStepSpecify a new column data type. -
Uses of DataType in org.jooq.impl
Classes in org.jooq.impl that implement DataTypeModifier and TypeClassDescriptionclassAn internal marker subtype ofDefaultDataType, to be used only by built-in data types inSQLDataTypeand dialect specific data type classes.classA common base class for data types.Fields in org.jooq.impl declared as DataTypeModifier and TypeFieldDescriptionSQLDataType.BIGINTTheTypes.BIGINTtype.SQLDataType.BIGINTUNSIGNEDThe unsignedTypes.BIGINTtype.static final DataType<byte[]> SQLDataType.BINARYTheTypes.BINARYtype.SQLDataType.BITTheTypes.BITtype.static final DataType<byte[]> SQLDataType.BLOBTheTypes.BLOBtype.SQLDataType.BOOLEANTheTypes.BOOLEANtype.SQLDataType.CHARTheTypes.CHARtype.SQLDataType.CLOBTheTypes.CLOBtype.SQLDataType.DATETheTypes.DATEtype.SQLDataType.DECFLOATTheDecfloattype.static final DataType<BigDecimal> SQLDataType.DECIMALTheTypes.DECIMALtype.static final DataType<BigInteger> SQLDataType.DECIMAL_INTEGERThe zero-scaleTypes.DECIMALtype.SQLDataType.DOUBLETheTypes.DOUBLEtype.SQLDataType.FLOATTheTypes.FLOATtype.SQLDataType.GEOGRAPHYTheGeographytype.SQLDataType.GEOMETRYTheGeometrytype.SQLDataType.INSTANTATypes.TIMESTAMP_WITH_TIMEZONEtype that uses UTC as time zone.SQLDataType.INTEGERTheTypes.INTEGERtype.SQLDataType.INTEGERUNSIGNEDThe unsignedTypes.INTEGERtype.static final DataType<YearToSecond> SQLDataType.INTERVALA vendor specificINTERVAL YEAR TO SECONDdata type, which combinesSQLDataType.INTERVALYEARTOMONTHandSQLDataType.INTERVALDAYTOSECOND.static final DataType<DayToSecond> SQLDataType.INTERVALDAYTOSECONDThe SQL standardINTERVAL DAY TO SECONDdata type.static final DataType<YearToMonth> SQLDataType.INTERVALYEARTOMONTHThe SQL standardINTERVAL YEAR TO MONTHdata type.SQLDataType.JSONTheJSONtype.SQLDataType.JSONBTheJSONBtype.SQLDataType.LOCALDATETheTypes.DATEtype.static final DataType<LocalDateTime> SQLDataType.LOCALDATETIMETheTypes.TIMESTAMPtype.SQLDataType.LOCALTIMETheTypes.TIMEtype.SQLDataType.LONGNVARCHARTheTypes.LONGNVARCHARtype.static final DataType<byte[]> SQLDataType.LONGVARBINARYTheTypes.LONGVARBINARYtype.SQLDataType.LONGVARCHARTheTypes.LONGVARCHARtype.SQLDataType.NCHARTheTypes.NCHARtype.SQLDataType.NCLOBTheTypes.NCLOBtype.static final DataType<BigDecimal> SQLDataType.NUMERICTheTypes.NUMERICtype.SQLDataType.NVARCHARTheTypes.NVARCHARtype.static final DataType<OffsetDateTime> SQLDataType.OFFSETDATETIMETheTypes.TIMESTAMP_WITH_TIMEZONEtype.static final DataType<OffsetTime> SQLDataType.OFFSETTIMETheTypes.TIME_WITH_TIMEZONEtype.SQLDataType.OTHERTheTypes.OTHERtype.SQLDataType.REALTheTypes.REALtype.SQLDataType.RECORDTheTypes.STRUCTtype.SQLDataType.RESULTTheResultSettype.SQLDataType.ROWIDTheTypes.ROWIDtype.SQLDataType.SMALLINTTheTypes.SMALLINTtype.SQLDataType.SMALLINTUNSIGNEDThe unsignedTypes.SMALLINTtype.SQLDataType.TIMETheTypes.TIMEtype.SQLDataType.TIMESTAMPTheTypes.TIMESTAMPtype.static final DataType<OffsetDateTime> SQLDataType.TIMESTAMPWITHTIMEZONETheTypes.TIMESTAMP_WITH_TIMEZONEtype.static final DataType<OffsetTime> SQLDataType.TIMEWITHTIMEZONETheTypes.TIME_WITH_TIMEZONEtype.SQLDataType.TINYINTTheTypes.TINYINTtype.SQLDataType.TINYINTUNSIGNEDThe unsignedTypes.TINYINTtype.SQLDataType.UUIDTheUUIDtype.static final DataType<byte[]> SQLDataType.VARBINARYTheTypes.VARBINARYtype.SQLDataType.VARCHARTheTypes.VARCHARtype.SQLDataType.XMLTheXMLtype.SQLDataType.YEARATypes.SMALLINTtype that represents a year.Methods in org.jooq.impl that return DataTypeModifier and TypeMethodDescriptionQOM.Cast.$dataType()QOM.Coerce.$dataType()QOM.CreateDomain.$dataType()QOM.CreateSequence.$dataType()QOM.TryCast.$dataType()The data type to try to cast the value todefault @Nullable DataType<?> QOM.JSONArray.$returning()@Nullable DataType<?> QOM.JSONArrayAgg.$returning()default @Nullable DataType<?> QOM.JSONArrayQuery.$returning()default @Nullable DataType<?> QOM.JSONObject.$returning()@Nullable DataType<?> QOM.JSONObjectAgg.$returning()default @Nullable DataType<?> QOM.JSONQuery.$returning()default @Nullable DataType<?> QOM.JSONValue.$returning()@Nullable DataType<?> QOM.CreateFunction.$returns()QOM.JSONArray.$type()QOM.JSONArrayQuery.$type()QOM.JSONObject.$type()QOM.JSONQuery.$type()QOM.JSONValue.$type()QOM.XMLSerialize.$type()static final DataType<byte[]> SQLDataType.BINARY(int length) TheTypes.BINARYtype.static final DataType<byte[]> SQLDataType.BLOB(int length) TheTypes.BLOBtype.SQLDataType.CHAR(int length) TheTypes.CHARtype.SQLDataType.CLOB(int length) TheTypes.CLOBtype.SQLDataType.DECFLOAT(int precision) TheDecfloattype.static final DataType<BigDecimal> SQLDataType.DECIMAL(int precision) TheTypes.DECIMALtype.static final DataType<BigDecimal> SQLDataType.DECIMAL(int precision, int scale) TheTypes.DECIMALtype.static final DataType<BigInteger> SQLDataType.DECIMAL_INTEGER(int precision) The zero-scaleTypes.DECIMALtype.final DataType<?> ArrayRecordImpl.getArrayType()final DataType<?> AssociativeArrayRecordImpl.getArrayType()ArrayRecordImpl.getDataType()AssociativeArrayRecordImpl.getDataType()DefaultDataType.getDataType(Configuration configuration) static final DataType<?> DefaultDataType.getDataType(SQLDialect dialect, int sqlType) static final <T> DataType<T> DefaultDataType.getDataType(SQLDialect dialect, Class<T> type) static final <T> DataType<T> DefaultDataType.getDataType(SQLDialect dialect, Class<T> type, DataType<T> fallbackDataType) static final DataType<?> DefaultDataType.getDataType(SQLDialect dialect, String typeName) static final DataType<?> DefaultDataType.getDataType(SQLDialect dialect, String t, int p, int s) Convert a type name (using precision and scale) into a Java classstatic final DataType<?> DefaultDataType.getDataType(SQLDialect dialect, String t, int p, int s, boolean forceIntegerTypesOnZeroScaleDecimals) Convert a type name (using precision and scale) into a Java classstatic final DataType<?> DefaultDataType.getDataType(SQLDialect dialect, SQLType sqlType) UDTImpl.getDataType()DefaultDataType.getDefaultDataType(String typeName) DefaultDataType.getDefaultDataType(SQLDialect dialect, String typeName) AssociativeArrayRecordImpl.getIndexDataType()DefaultDataType.getSQLDataType()SQLDataType.INSTANT(int precision) ATypes.TIMESTAMP_WITH_TIMEZONEtype that uses UTC as time zone.static final DataType<LocalDateTime> SQLDataType.LOCALDATETIME(int precision) TheTypes.TIMESTAMPtype.SQLDataType.LOCALTIME(int precision) TheTypes.TIMEtype.SQLDataType.LONGNVARCHAR(int length) TheTypes.LONGNVARCHARtype.static final DataType<byte[]> SQLDataType.LONGVARBINARY(int length) TheTypes.LONGVARBINARYtype.SQLDataType.LONGVARCHAR(int length) TheTypes.LONGVARCHARtype.SQLDataType.NCHAR(int length) TheTypes.NCHARtype.SQLDataType.NCLOB(int length) TheTypes.NCLOBtype.BuiltInDataType.nullability(Nullability n) protected static <T> DataType<T> DSL.nullSafeDataType(Field<T> field) Deprecated, for removal: This API element is subject to removal in a future version.- [#11092] - 3.15.0 - This method will be removed without public replacement.static final DataType<BigDecimal> SQLDataType.NUMERIC(int precision) TheTypes.NUMERICtype.static final DataType<BigDecimal> SQLDataType.NUMERIC(int precision, int scale) TheTypes.NUMERICtype.SQLDataType.NVARCHAR(int length) TheTypes.NVARCHARtype.static final DataType<OffsetDateTime> SQLDataType.OFFSETDATETIME(int precision) TheTypes.TIMESTAMP_WITH_TIMEZONEtype.static final DataType<OffsetTime> SQLDataType.OFFSETTIME(int precision) TheTypes.TIME_WITH_TIMEZONEtype.SQLDataType.TIME(int precision) TheTypes.TIMEtype.SQLDataType.TIMESTAMP(int precision) TheTypes.TIMESTAMPtype.static final DataType<OffsetDateTime> SQLDataType.TIMESTAMPWITHTIMEZONE(int precision) TheTypes.TIMESTAMP_WITH_TIMEZONEtype.static final DataType<OffsetTime> SQLDataType.TIMEWITHTIMEZONE(int precision) TheTypes.TIME_WITH_TIMEZONEtype.static final DataType<byte[]> SQLDataType.VARBINARY(int length) TheTypes.VARBINARYtype.SQLDataType.VARCHAR(int length) TheTypes.VARCHARtype.Methods in org.jooq.impl with parameters of type DataTypeModifier and TypeMethodDescription<U> @NotNull QOM.Cast<U> <U> @NotNull QOM.Coerce<U> @NotNull QOM.CreateDomain<T> @NotNull QOM.CreateSequence<T> default @NotNull QOM.TryCast<T> The data type to try to cast the value todefault @NotNull QOM.JSONArray<T> QOM.JSONArray.$returning(DataType<?> newReturning) @NotNull QOM.JSONArrayAgg<J> QOM.JSONArrayAgg.$returning(DataType<?> returning) default @NotNull QOM.JSONArrayQuery<T> QOM.JSONArrayQuery.$returning(DataType<?> newReturning) default @NotNull QOM.JSONObject<T> QOM.JSONObject.$returning(DataType<?> newReturning) @NotNull QOM.JSONObjectAgg<J> QOM.JSONObjectAgg.$returning(DataType<?> returning) default @NotNull QOM.JSONQuery<T> QOM.JSONQuery.$returning(DataType<?> newReturning) default @NotNull QOM.JSONValue<T> QOM.JSONValue.$returning(DataType<?> newReturning) @NotNull QOM.CreateFunctiondefault @NotNull QOM.JSONArray<T> default @NotNull QOM.JSONArrayQuery<T> default @NotNull QOM.JSONObject<T> default @NotNull QOM.JSONQuery<T> default @NotNull QOM.JSONValue<T> default @NotNull QOM.XMLSerialize<T> static <T> @NotNull AggregateFunction<T> aggregate()can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction<T> aggregate()can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction<T> DSL.aggregateDistinct(String name, DataType<T> type, Field<?>... arguments) aggregateDistinct()can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction<T> DSL.aggregateDistinct(Name name, DataType<T> type, Field<?>... arguments) aggregateDistinct()can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static final <T> Binding<T, T> Get the internal default binding for aDataType.static <T> @NotNull Field<T> Cast a value to another type.static <T> @NotNull Field<T> Cast a field to another type.static <T> @NotNull Field<T> Cast null to a type.static <T> @NotNull Field<T> Coerce a field to another type.static <T> @NotNull Field<T> Coerce a field to another type.static <T,A extends ArrayRecord<T>>
@NotNull ArrayAggOrderByStep<A> Get thecollect()aggregate function.static <T,A extends ArrayRecord<T>>
@NotNull ArrayAggOrderByStep<A> DSL.collectDistinct(Field<T> field, DataType<A> type) Get thecollect()aggregate function.static <T> @NotNull Field<T> Convert a date time value to a string value using the SQL Server styleCONVERT()function.static <T> @NotNull Field<T> Convert a date time value to a string value using the SQL Server styleCONVERT()function.static final <T,U> @NotNull Domain <U> Internal.createDomain(Schema schema, Name name, Comment comment, DataType<T> type, Binding<T, U> binding, Check<?>... checks) Factory method for domain specifications.static final <T> Domain<T> Internal.createDomain(Schema schema, Name name, Comment comment, DataType<T> type, Check<?>... checks) Factory method for domain specifications.static final <T,U> @NotNull Domain <U> Internal.createDomain(Schema schema, Name name, Comment comment, DataType<T> type, Converter<T, U> converter, Check<?>... checks) Factory method for domain specifications.static final <T,X, U> @NotNull Domain <U> Internal.createDomain(Schema schema, Name name, Comment comment, DataType<T> type, Converter<X, U> converter, Binding<T, X> binding, Check<?>... checks) Factory method for domain specifications.static final <T,U> @NotNull Domain <U> Internal.createDomain(Schema schema, Name name, DataType<T> type, Binding<T, U> binding, Check<?>... checks) Deprecated.- 3.20.0 - [#15723] - Regenerate your code.static final <T> @NotNull Domain<T> Internal.createDomain(Schema schema, Name name, DataType<T> type, Check<?>... checks) Deprecated.- 3.20.0 - [#15723] - Regenerate your code.static final <T,U> @NotNull Domain <U> Internal.createDomain(Schema schema, Name name, DataType<T> type, Converter<T, U> converter, Check<?>... checks) Deprecated.- 3.20.0 - [#15723] - Regenerate your code.static final <T,X, U> @NotNull Domain <U> Internal.createDomain(Schema schema, Name name, DataType<T> type, Converter<X, U> converter, Binding<T, X> binding, Check<?>... checks) Deprecated.- 3.20.0 - [#15723] - Regenerate your code.UDTImpl.createField(String name, DataType<? extends T> type, UDT<R> udt) Deprecated.- 3.12.0 - [#8000] - UseUDTImpl.createField(Name, DataType, UDT)instead.UDTImpl.createField(String name, DataType<? extends T> type, UDT<R> udt, String comment) Deprecated.- 3.12.0 - [#8000] - UseUDTImpl.createField(Name, DataType, UDT, String)instead.UDTImpl.createField(String name, DataType<? extends T> type, UDT<R> udt, String comment, Binding<T, U> binding) Deprecated.- 3.12.0 - [#8000] - UseUDTImpl.createField(Name, DataType, UDT, String, Binding)instead.UDTImpl.createField(String name, DataType<? extends T> type, UDT<R> udt, String comment, Converter<T, U> converter) Deprecated.- 3.12.0 - [#8000] - UseUDTImpl.createField(Name, DataType, UDT, String, Converter)instead.UDTImpl.createField(String name, DataType<? extends T> type, UDT<R> udt, String comment, Converter<X, U> converter, Binding<T, X> binding) Deprecated.- 3.12.0 - [#8000] - UseUDTImpl.createField(Name, DataType, UDT, String, Converter, Binding)instead.UDTImpl.createField(Name name, DataType<? extends T> type, UDT<R> udt) Subclasses may call this method to createUDTFieldobjects that are linked to this table.UDTImpl.createField(Name name, DataType<? extends T> type, UDT<R> udt, String comment) Subclasses may call this method to createUDTFieldobjects that are linked to this table.UDTImpl.createField(Name name, DataType<? extends T> type, UDT<R> udt, String comment, Binding<T, U> binding) Subclasses may call this method to createUDTFieldobjects that are linked to this table.UDTImpl.createField(Name name, DataType<? extends T> type, UDT<R> udt, String comment, Converter<T, U> converter) Subclasses may call this method to createUDTFieldobjects that are linked to this table.UDTImpl.createField(Name name, DataType<? extends T> type, UDT<R> udt, String comment, Converter<X, U> converter, Binding<T, X> binding) Subclasses may call this method to createUDTFieldobjects that are linked to this table.protected static final <T> Parameter<T> AbstractRoutine.createParameter(String name, DataType<T> type) Deprecated.- Please, re-generate your routine code.protected static final <T> Parameter<T> AbstractRoutine.createParameter(String name, DataType<T> type, boolean isDefaulted) Deprecated.- Please, re-generate your routine code.protected static final <T> Parameter<T> AbstractRoutine.createParameter(String name, DataType<T> type, boolean isDefaulted, boolean isUnnamed) Deprecated.- Please, re-generate your routine code.protected static final <T,U> Parameter <U> AbstractRoutine.createParameter(String name, DataType<T> type, boolean isDefaulted, boolean isUnnamed, Binding<T, U> binding) Deprecated.- Please, re-generate your routine code.protected static final <T,U> Parameter <U> AbstractRoutine.createParameter(String name, DataType<T> type, boolean isDefaulted, boolean isUnnamed, Converter<T, U> converter) Deprecated.- Please, re-generate your routine code.protected static final <T,X, U> Parameter <U> AbstractRoutine.createParameter(String name, DataType<T> type, boolean isDefaulted, boolean isUnnamed, Converter<X, U> converter, Binding<T, X> binding) Deprecated.- Please, re-generate your routine code.protected static final <T,U> Parameter <U> AbstractRoutine.createParameter(String name, DataType<T> type, boolean isDefaulted, Binding<T, U> binding) Deprecated.- Please, re-generate your routine code.protected static final <T,U> Parameter <U> AbstractRoutine.createParameter(String name, DataType<T> type, boolean isDefaulted, Converter<T, U> converter) Deprecated.- Please, re-generate your routine code.protected static final <T,X, U> Parameter <U> AbstractRoutine.createParameter(String name, DataType<T> type, boolean isDefaulted, Converter<X, U> converter, Binding<T, X> binding) Deprecated.- Please, re-generate your routine code.static final <T> @NotNull Parameter<T> Internal.createParameter(String name, DataType<? extends T> type, boolean isUnnamed) Factory method for parameters.static final <T> @NotNull Parameter<T> Internal.createParameter(String name, DataType<? extends T> type, boolean isDefaulted, boolean isUnnamed) Deprecated, for removal: This API element is subject to removal in a future version.- 3.21.0 - [#19044] - UseInternal.createParameter(String, DataType, boolean)instead.static final <T,U> @NotNull Parameter <U> Internal.createParameter(String name, DataType<? extends T> type, boolean isDefaulted, boolean isUnnamed, Binding<T, U> binding) Deprecated, for removal: This API element is subject to removal in a future version.- 3.21.0 - [#19044] - UseInternal.createParameter(String, DataType, boolean, Binding)instead.static final <T,U> @NotNull Parameter <U> Internal.createParameter(String name, DataType<? extends T> type, boolean isDefaulted, boolean isUnnamed, Converter<T, U> converter) Deprecated, for removal: This API element is subject to removal in a future version.- 3.21.0 - [#19044] - UseInternal.createParameter(String, DataType, boolean, Converter)instead.static final <T,X, U> @NotNull Parameter <U> Internal.createParameter(String name, DataType<? extends T> type, boolean isDefaulted, boolean isUnnamed, Converter<X, U> converter, Binding<T, X> binding) Deprecated, for removal: This API element is subject to removal in a future version.- 3.21.0 - [#19044] - UseInternal.createParameter(String, DataType, boolean, Converter, Binding)instead.static final <T,U> @NotNull Parameter <U> Internal.createParameter(String name, DataType<? extends T> type, boolean isUnnamed, Binding<T, U> binding) Factory method for parameters.static final <T,U> @NotNull Parameter <U> Internal.createParameter(String name, DataType<? extends T> type, boolean isUnnamed, Converter<T, U> converter) Factory method for parameters.static final <T,X, U> @NotNull Parameter <U> Internal.createParameter(String name, DataType<? extends T> type, boolean isUnnamed, Converter<X, U> converter, Binding<T, X> binding) Factory method for parameters.Internal.createSequence(String name, Schema schema, Comment comment, DataType<T> type) Factory method for sequences.Internal.createSequence(String name, Schema schema, Comment comment, DataType<T> type, Number startWith, Number incrementBy, Number minvalue, Number maxvalue, boolean cycle, Number cache) Factory method for sequences.Internal.createSequence(String name, Schema schema, DataType<T> type) Deprecated.- 3.20.0 - [#15723] - Regenerate your code.Internal.createSequence(String name, Schema schema, DataType<T> type, Number startWith, Number incrementBy, Number minvalue, Number maxvalue, boolean cycle, Number cache) Deprecated.- 3.20.0 - [#15723] - Regenerate your code.static final <T,P extends UDTField<?, T>>
PInternal.createUDTPathField(Name name, DataType<? extends T> type, UDTPathField<?, ?, ?> qualifier, Class<P> returnType) static final <T,P extends UDTField<?, T>>
PInternal.createUDTPathField(Name name, DataType<? extends T> type, UDTPathField<?, ?, ?> qualifier, String comment, Class<P> returnType) static final <T,U, P extends UDTField<?, U>>
PInternal.createUDTPathField(Name name, DataType<? extends T> type, UDTPathField<?, ?, ?> qualifier, String comment, Class<P> returnType, Binding<T, U> binding) static final <T,U, P extends UDTField<?, U>>
PInternal.createUDTPathField(Name name, DataType<? extends T> type, UDTPathField<?, ?, ?> qualifier, String comment, Class<P> returnType, Converter<T, U> converter) static final <T,X, U, P extends UDTField<?, U>>
PInternal.createUDTPathField(Name name, DataType<? extends T> type, UDTPathField<?, ?, ?> qualifier, String comment, Class<P> returnType, Converter<X, U> converter, Binding<T, X> binding) static final <R extends Record,T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, Class<P> returnType) static final <R extends Record,T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType) static final <R extends Record,T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType, Binding<T, U> binding) static final <R extends Record,T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType, Converter<T, U> converter) static final <R extends Record,T, X, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, Table<R> table, String comment, Class<P> returnType, Converter<X, U> converter, Binding<T, X> binding) static final <R extends Record,TR extends Table<R>, T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Binding<T, U> binding, Generator<R, TR, U> generator) static final <R extends Record,TR extends Table<R>, T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Converter<T, U> converter, Generator<R, TR, U> generator) static final <R extends Record,TR extends Table<R>, T, X, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Converter<X, U> converter, Binding<T, X> binding, Generator<R, TR, U> generator) static final <R extends Record,TR extends Table<R>, T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField(Name name, DataType<? extends T> type, TR table, String comment, Class<P> returnType, Generator<R, TR, T> generator) static <T> @NotNull Field<T> Create aDEFAULTkeyword for use withINSERT,UPDATE, orMERGEstatements.static <T> @NotNull Field<T> DSL.defaultValue(DataType<T> type) Create aDEFAULTkeyword for use withINSERT,UPDATE, orMERGEstatements.static <T> @NotNull Domain<T> Create aDOMAINreference.static <T> @NotNull Domain<T> Create aDOMAINreference.Get the extract(field, datePart) function.Get the extract(field, datePart) function.Get the extract(field, datePart) function.DefaultDSLContext.fetchAsync(ResultSet rs, DataType<?>... types) DefaultDSLContext.fetchAsync(Executor executor, ResultSet rs, DataType<?>... types) DefaultDSLContext.fetchOptional(ResultSet rs, DataType<?>... types) <T> Optional<T> DefaultDSLContext.fetchOptionalValue(ResultSet rs, DataType<T> type) DefaultDSLContext.fetchSingle(ResultSet rs, DataType<?>... types) DefaultDSLContext.fetchStream(ResultSet rs, DataType<?>... types) <T> TDefaultDSLContext.fetchValue(ResultSet rs, DataType<T> type) <T> List<T> DefaultDSLContext.fetchValues(ResultSet rs, DataType<T> type) static <T> @NotNull Field<T> Create a "plain SQL" field.static <T> @NotNull Field<T> Create a "plain SQL" field.static <T> @NotNull Field<T> Create a "plain SQL" field.static <T> @NotNull Field<T> Create a qualified field, given its (qualified) field name.static <T> @NotNull Field<T> Create a qualified field, given its (qualified) field name.static <T> @NotNull Field<T> Create a "plain SQL" field.<T> Field<T> <T> Field<T> static <T> @NotNull Field<T> DSL.function(String name, DataType<T> type, Collection<? extends Field<?>> arguments) function()can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull Field<T> function()can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull Field<T> DSL.function(Name name, DataType<T> type, Collection<? extends Field<?>> arguments) function()can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull Field<T> function()can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static final <T> DataType<T> DefaultDataType.getDataType(SQLDialect dialect, Class<T> type, DataType<T> fallbackDataType) static <T> @NotNull Parameter<T> Create anINparameter.static <T> @NotNull Parameter<T> Create anINparameter.static <T> @NotNull Param<T> Create a bind value, that is always inlined.static <T> @NotNull Parameter<T> Create anIN OUTparameter.static <T> @NotNull Parameter<T> Create anIN OUTparameter.static <T> @NotNull Field<T> Return aFieldthat behaves like no field being present.static <T> @NotNull JSONEntry<T> DSL.noJsonEntry(DataType<T> type) Return aJSONEntrythat behaves like no JSON entry being present.protected static Field<?>[]Deprecated, for removal: This API element is subject to removal in a future version.- [#11092] - 3.15.0 - This method will be removed without public replacement.protected static <T> Field<T> Deprecated, for removal: This API element is subject to removal in a future version.- [#11092] - 3.15.0 - This method will be removed without public replacement.DSL.nullSafeList(Field<?>[] fields, DataType<?> type) Deprecated, for removal: This API element is subject to removal in a future version.- [#11092] - 3.15.0 - This method will be removed without public replacement.static final <T> CustomField<T> Create aCustomFieldfrom a lambda expression.static final <T> CustomField<T> Create aCustomFieldfrom a lambda expression.static <T> @NotNull Parameter<T> Create anOUTparameter.static <T> @NotNull Parameter<T> Create anOUTparameter.static <T> @NotNull Param<T> Create a named parameter with a defined type and no initial value.static <T> @NotNull Param<T> Create an unnamed parameter with a defined type and no initial value.static <T> @NotNull Period<T> Create a namedPeriodreference.Create a qualified sequence, given its sequence name.static <T> @NotNull Period<T> DSL.systemTime(DataType<T> type) Create aSYSTEM_TIMEPeriodreference.static <T> @NotNull Field<T> TheTRY_CASTfunction.static <T> @NotNull Field<T> TheTRY_CASTfunction.static <T> @NotNull Type<T> Create a qualified type, given its type name.static <T> @NotNull Type<T> Create a qualified type, given its type name.static <T> @NotNull Param<T> Get a bind value with an associated type.static <T> @NotNull Param<T> A synonym forDSL.val(Object, DataType)to be used in Scala and Groovy, wherevalis a reserved keyword.static <T> @NotNull Field<T> Create theVALUEpseudo field for usage withDOMAINspecifications.static <T> @NotNull Variable<T> Create a local variable reference for use in procedural code.static <T> @NotNull Variable<T> Create a local variable reference for use in procedural code.static <T> @NotNull Variable<T> A synonym forDSL.var(Name, DataType)to be used in Scala and Groovy, wherevaris a reserved keyword.static <T> @NotNull Variable<T> A synonym forDSL.var(Name, DataType)to be used in Scala and Groovy, wherevaris a reserved keyword.static <T> @NotNull Field<T> DSL.xmlserializeContent(Field<XML> value, DataType<T> type) TheXMLSERIALIZE_CONTENTfunction.static <T> @NotNull Field<T> DSL.xmlserializeContent(XML value, DataType<T> type) TheXMLSERIALIZE_CONTENTfunction.static <T> @NotNull Field<T> DSL.xmlserializeDocument(Field<XML> value, DataType<T> type) TheXMLSERIALIZEfunction.static <T> @NotNull Field<T> DSL.xmlserializeDocument(XML value, DataType<T> type) TheXMLSERIALIZEfunction.Constructors in org.jooq.impl with parameters of type DataTypeModifierConstructorDescriptionprotectedprotectedAbstractRoutine(String name, Schema schema, Comment comment, DataType<X> type, Binding<X, T> binding) protectedAbstractRoutine(String name, Schema schema, Comment comment, DataType<X> type, Converter<X, T> converter) protectedAbstractRoutine(String name, Schema schema, Comment comment, DataType<X> type, Converter<Y, T> converter, Binding<X, Y> binding) protectedAbstractRoutine(String name, Schema schema, DataType<? extends T> type) Deprecated.- 3.20.0 - [#15723] - Re-generate your code.protectedDeprecated.- 3.20.0 - [#15723] - Re-generate your code.protectedDeprecated.- 3.20.0 - [#15723] - Re-generate your code.protectedAbstractRoutine(String name, Schema schema, DataType<X> type, Converter<Y, T> converter, Binding<X, Y> binding) Deprecated.- 3.20.0 - [#15723] - Re-generate your code.protectedAbstractRoutine(String name, Schema schema, Package pkg, Comment comment, DataType<? extends T> type) protectedAbstractRoutine(String name, Schema schema, Package pkg, Comment comment, DataType<X> type, Binding<X, T> binding) protectedAbstractRoutine(String name, Schema schema, Package pkg, Comment comment, DataType<X> type, Converter<X, T> converter) protectedAbstractRoutine(String name, Schema schema, Package pkg, Comment comment, DataType<X> type, Converter<Y, T> converter, Binding<X, Y> binding) protectedDeprecated.- 3.20.0 - [#15723] - Re-generate your code.protectedDeprecated.- 3.20.0 - [#15723] - Re-generate your code.protectedAbstractRoutine(String name, Schema schema, Package pkg, DataType<X> type, Converter<X, T> converter) Deprecated.- 3.20.0 - [#15723] - Re-generate your code.protectedAbstractRoutine(String name, Schema schema, Package pkg, DataType<X> type, Converter<Y, T> converter, Binding<X, Y> binding) Deprecated.- 3.20.0 - [#15723] - Re-generate your code.protectedArrayRecordImpl(Schema schema, String name, DataType<? extends T> type) Create an empty array recordprotectedArrayRecordImpl(Schema schema, String name, DataType<X> type, Binding<X, Y> binding) Create an empty array recordprotectedCreate an empty array recordprotectedArrayRecordImpl(Schema schema, String name, DataType<X> type, Converter<Y, T> converter, Binding<X, Y> binding) Create an empty array recordprotectedCreate an empty array recordprotectedCreate an empty array recordprotectedArrayRecordImpl(Schema schema, Package pkg, String name, DataType<X> type, Converter<X, T> converter) Create an empty array recordprotectedArrayRecordImpl(Schema schema, Package pkg, String name, DataType<X> type, Converter<Y, T> converter, Binding<X, Y> binding) Create an empty array recordprotectedCreate an empty array recordprotectedAssociativeArrayRecordImpl(Schema schema, String name, DataType<X> type, DataType<K> indexDataType, Binding<X, Y> binding) Create an empty array recordprotectedAssociativeArrayRecordImpl(Schema schema, String name, DataType<X> type, DataType<K> indexDataType, Converter<X, V> converter) Create an empty array recordprotectedAssociativeArrayRecordImpl(Schema schema, String name, DataType<X> type, DataType<K> indexDataType, Converter<Y, V> converter, Binding<X, Y> binding) Create an empty array recordprotectedAssociativeArrayRecordImpl(Schema schema, Package pkg, String name, DataType<V> type, DataType<K> indexDataType) Create an empty array recordprotectedAssociativeArrayRecordImpl(Schema schema, Package pkg, String name, DataType<X> type, DataType<K> indexDataType, Binding<X, Y> binding) Create an empty array recordprotectedAssociativeArrayRecordImpl(Schema schema, Package pkg, String name, DataType<X> type, DataType<K> indexDataType, Converter<X, V> converter) Create an empty array recordprotectedAssociativeArrayRecordImpl(Schema schema, Package pkg, String name, DataType<X> type, DataType<K> indexDataType, Converter<Y, V> converter, Binding<X, Y> binding) Create an empty array recordBuiltInDataType(SQLDialect dialect, DataType<T> sqlDataType, String typeName) Constructor for dialect specific data types.BuiltInDataType(SQLDialect dialect, DataType<T> sqlDataType, String typeName, String castTypeName) Constructor for dialect specific data types.BuiltInDataType(SQLDialect dialect, DataType<T> sqlDataType, String typeName, String castTypeName, String ddlTypeName) Constructor for dialect specific data types.protectedCustomField(String name, DataType<T> type) protectedCustomField(Name name, DataType<T> type) DefaultDataType(SQLDialect dialect, DataType<T> sqlDataType, String typeName) DefaultDataType(SQLDialect dialect, DataType<T> sqlDataType, String typeName, String castTypeName) DefaultDataType(SQLDialect dialect, DataType<T> sqlDataType, String typeName, String castTypeName, String ddlTypeName) UDTPathTableFieldImpl(Name name, DataType<T> type, RecordQualifier<R> qualifier, UDT<U> udt, Comment comment, Binding<?, T> binding)
identityMode(GenerationMode)instead.