Uses of Class
org.jooq.JSONB

Packages that use JSONB

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.

Uses of JSONB in org.jooq

Methods in org.jooq that return JSONB

Modifier and Type	Method	Description
static final @NotNull JSONB	JSONB.jsonb(String data)	Create a new JSONB instance from string data input.
static final @Nullable JSONB	JSONB.jsonbOrNull(String data)	Create a new JSONB instance from string data input, or null if the input is null.
static final @NotNull JSONB	JSONB.valueOf(String data)	Create a new JSONB instance from string data input.

Methods in org.jooq that return types with arguments of type JSONB

Modifier and Type	Method	Description
@NotNull SelectForJSONStep<Record1<JSONB>>	SelectForStep.forJSONB()	Add a SQL Server-style FOR JSON clause.

Uses of JSONB in org.jooq.impl

Subinterfaces with type arguments of type JSONB in org.jooq.impl

Modifier and Type	Interface	Description
static interface	QOM.JSONBArrayLength	The JSONB ARRAY LENGTH function.
static interface	QOM.JSONBGetAttribute	The JSONB GET ATTRIBUTE function.
static interface	QOM.JSONBGetAttribute	The JSONB GET ATTRIBUTE function.
static interface	QOM.JSONBGetAttributeAsText	The JSONB GET ATTRIBUTE AS TEXT function.
static interface	QOM.JSONBGetElement	The JSONB GET ELEMENT function.
static interface	QOM.JSONBGetElement	The JSONB GET ELEMENT function.
static interface	QOM.JSONBGetElementAsText	The JSONB GET ELEMENT AS TEXT function.
static interface	QOM.JSONBInsert	The JSONB INSERT function.
static interface	QOM.JSONBInsert	The JSONB INSERT function.
static interface	QOM.JSONBKeyExists	The JSONB KEY EXISTS function.
static interface	QOM.JSONBKeys	The JSONB KEYS function.
static interface	QOM.JSONBKeys	The JSONB KEYS function.
static interface	QOM.JSONBRemove	The JSONB REMOVE function.
static interface	QOM.JSONBRemove	The JSONB REMOVE function.
static interface	QOM.JSONBReplace	The JSONB REPLACE function.
static interface	QOM.JSONBReplace	The JSONB REPLACE function.
static interface	QOM.JSONBSet	The JSONB SET function.
static interface	QOM.JSONBSet	The JSONB SET function.

Fields in org.jooq.impl with type parameters of type JSONB

Modifier and Type	Field	Description
static final DataType<JSONB>	SQLDataType.JSONB	The JSONB type.

Methods in org.jooq.impl that return types with arguments of type JSONB

Modifier and Type	Method	Description
default @NotNull Field<JSONB>	QOM.JSONBArrayLength.$field()
default @NotNull Field<JSONB>	QOM.JSONBGetAttribute.$field()	The JSONB document
default @NotNull Field<JSONB>	QOM.JSONBGetAttributeAsText.$field()	The JSONB document
default @NotNull Field<JSONB>	QOM.JSONBGetElement.$field()	The JSONB document
default @NotNull Field<JSONB>	QOM.JSONBGetElementAsText.$field()	The JSONB document
default @NotNull Field<JSONB>	QOM.JSONBInsert.$field()
default @NotNull Field<JSONB>	QOM.JSONBKeys.$field()
default @NotNull Field<JSONB>	QOM.JSONBRemove.$field()
default @NotNull Field<JSONB>	QOM.JSONBReplace.$field()
default @NotNull Field<JSONB>	QOM.JSONBSet.$field()
default @NotNull Field<JSONB>	QOM.JSONBKeyExists.$json()	The JSONB object
static @NotNull Param<JSONB>	DSL.inline(JSONB value)	Create a bind value that is always inlined.
static @NotNull JSONArrayNullStep<JSONB>	DSL.jsonbArray(Collection<? extends Field<?>> fields)	The JSONB_ARRAY function.
static @NotNull JSONArrayNullStep<JSONB>	DSL.jsonbArray(Field<?>... fields)	The JSONB_ARRAY function.
static <T> @NotNull JSONArrayQueryNullStep<JSONB>	DSL.jsonbArray(Select<? extends Record1<?>> select)	The JSONB_ARRAY function.
static @NotNull JSONArrayAggOrderByStep<JSONB>	DSL.jsonbArrayAgg(Field<?> value)	The JSON array aggregate function.
static @NotNull JSONArrayAggOrderByStep<JSONB>	DSL.jsonbArrayAggDistinct(Field<?> value)	The JSON array aggregate function.
static @NotNull Field<JSONB>	DSL.jsonbGetAttribute(Field<JSONB> field, String attribute)	The JSONB_GET_ATTRIBUTE function.
static @NotNull Field<JSONB>	DSL.jsonbGetAttribute(Field<JSONB> field, Field<String> attribute)	The JSONB_GET_ATTRIBUTE function.
static @NotNull Field<JSONB>	DSL.jsonbGetAttribute(JSONB field, String attribute)	The JSONB_GET_ATTRIBUTE function.
static @NotNull Field<JSONB>	DSL.jsonbGetAttribute(JSONB field, Field<String> attribute)	The JSONB_GET_ATTRIBUTE function.
static @NotNull Field<JSONB>	DSL.jsonbGetElement(Field<JSONB> field, int index)	The JSONB_GET_ELEMENT function.
static @NotNull Field<JSONB>	DSL.jsonbGetElement(Field<JSONB> field, Field<Integer> index)	The JSONB_GET_ELEMENT function.
static @NotNull Field<JSONB>	DSL.jsonbGetElement(JSONB field, int index)	The JSONB_GET_ELEMENT function.
static @NotNull Field<JSONB>	DSL.jsonbGetElement(JSONB field, Field<Integer> index)	The JSONB_GET_ELEMENT function.
static @NotNull Field<JSONB>	DSL.jsonbInsert(Field<JSONB> field, String path, Object value)	The JSONB_INSERT function.
static @NotNull Field<JSONB>	DSL.jsonbInsert(Field<JSONB> field, String path, Field<?> value)	The JSONB_INSERT function.
static @NotNull Field<JSONB>	DSL.jsonbInsert(Field<JSONB> field, Field<String> path, Object value)	The JSONB_INSERT function.
static @NotNull Field<JSONB>	DSL.jsonbInsert(Field<JSONB> field, Field<String> path, Field<?> value)	The JSONB_INSERT function.
static @NotNull Field<JSONB>	DSL.jsonbKeys(Field<JSONB> field)	The JSONB_KEYS function.
static @NotNull Field<JSONB>	DSL.jsonbKeys(JSONB field)	The JSONB_KEYS function.
static @NotNull JSONObjectNullStep<JSONB>	DSL.jsonbObject()	The JSON object constructor.
static @NotNull JSONObjectNullStep<JSONB>	DSL.jsonbObject(String key, Field<?> value)	The JSON object constructor.
static @NotNull JSONObjectNullStep<JSONB>	DSL.jsonbObject(Collection<? extends JSONEntry<?>> entries)	The JSONB_OBJECT function.
static @NotNull JSONObjectNullStep<JSONB>	DSL.jsonbObject(Field<?>... entries)	Deprecated, for removal: This API element is subject to removal in a future version. - [#15196] - 3.19.0 - The semantics of the Field arguments in this method is inconsistent with that of other overloads, such as DSL.jsonbObject(Field, Field), which can lead to subtle bugs.
static @NotNull JSONObjectNullStep<JSONB>	DSL.jsonbObject(Field<String> key, Field<?> value)	The JSON object constructor.
static @NotNull JSONObjectNullStep<JSONB>	DSL.jsonbObject(Field<String> key, Select<? extends Record1<?>> value)	The JSON object constructor.
static @NotNull JSONObjectNullStep<JSONB>	DSL.jsonbObject(JSONEntry<?>... entries)	The JSONB_OBJECT function.
static @NotNull JSONObjectAggNullStep<JSONB>	DSL.jsonbObjectAgg(String key, Field<?> value)	The JSONB object aggregate function.
static @NotNull JSONObjectAggNullStep<JSONB>	DSL.jsonbObjectAgg(Field<?> field)	The JSONB object aggregate function.
static @NotNull JSONObjectAggNullStep<JSONB>	DSL.jsonbObjectAgg(Field<String> key, Field<?> value)	The JSONB object aggregate function.
static @NotNull JSONObjectAggNullStep<JSONB>	DSL.jsonbObjectAgg(JSONEntry<?> entry)	The JSONB object aggregate function.
static @NotNull JSONQueryOnStep<JSONB>	DSL.jsonbQuery(Field<JSONB> json, String path)	The JSONB_QUERY function.
static @NotNull JSONQueryOnStep<JSONB>	DSL.jsonbQuery(Field<JSONB> json, Field<String> path)	The JSONB_QUERY function.
static @NotNull Field<JSONB>	DSL.jsonbRemove(Field<JSONB> field, String path)	The JSONB_REMOVE function.
static @NotNull Field<JSONB>	DSL.jsonbRemove(Field<JSONB> field, Field<String> path)	The JSONB_REMOVE function.
static @NotNull Field<JSONB>	DSL.jsonbReplace(Field<JSONB> field, String path, Object value)	The JSONB_REPLACE function.
static @NotNull Field<JSONB>	DSL.jsonbReplace(Field<JSONB> field, String path, Field<?> value)	The JSONB_REPLACE function.
static @NotNull Field<JSONB>	DSL.jsonbReplace(Field<JSONB> field, Field<String> path, Object value)	The JSONB_REPLACE function.
static @NotNull Field<JSONB>	DSL.jsonbReplace(Field<JSONB> field, Field<String> path, Field<?> value)	The JSONB_REPLACE function.
static @NotNull Field<JSONB>	DSL.jsonbSet(Field<JSONB> field, String path, Object value)	The JSONB_SET function.
static @NotNull Field<JSONB>	DSL.jsonbSet(Field<JSONB> field, String path, Field<?> value)	The JSONB_SET function.
static @NotNull Field<JSONB>	DSL.jsonbSet(Field<JSONB> field, Field<String> path, Object value)	The JSONB_SET function.
static @NotNull Field<JSONB>	DSL.jsonbSet(Field<JSONB> field, Field<String> path, Field<?> value)	The JSONB_SET function.
static @NotNull JSONValueOnStep<JSONB>	DSL.jsonbValue(Field<JSONB> json, String path)	The JSONB_VALUE function.
static @NotNull JSONValueOnStep<JSONB>	DSL.jsonbValue(Field<JSONB> json, Field<String> path)	The JSONB_VALUE function.
static @NotNull Param<JSONB>	DSL.val(JSONB value)	Get a bind value.
static @NotNull Param<JSONB>	DSL.value(JSONB value)	A synonym for DSL.val(JSONB) to be used in Scala and Groovy, where val is a reserved keyword.

Methods in org.jooq.impl with parameters of type JSONB

Modifier and Type	Method	Description
static @NotNull Param<JSONB>	DSL.inline(JSONB value)	Create a bind value that is always inlined.
static @NotNull Field<Integer>	DSL.jsonbArrayLength(JSONB field)	The JSONB_ARRAY_LENGTH function.
static @NotNull Field<JSONB>	DSL.jsonbGetAttribute(JSONB field, String attribute)	The JSONB_GET_ATTRIBUTE function.
static @NotNull Field<JSONB>	DSL.jsonbGetAttribute(JSONB field, Field<String> attribute)	The JSONB_GET_ATTRIBUTE function.
static @NotNull Field<String>	DSL.jsonbGetAttributeAsText(JSONB field, String attribute)	The JSONB_GET_ATTRIBUTE_AS_TEXT function.
static @NotNull Field<String>	DSL.jsonbGetAttributeAsText(JSONB field, Field<String> attribute)	The JSONB_GET_ATTRIBUTE_AS_TEXT function.
static @NotNull Field<JSONB>	DSL.jsonbGetElement(JSONB field, int index)	The JSONB_GET_ELEMENT function.
static @NotNull Field<JSONB>	DSL.jsonbGetElement(JSONB field, Field<Integer> index)	The JSONB_GET_ELEMENT function.
static @NotNull Field<String>	DSL.jsonbGetElementAsText(JSONB field, int index)	The JSONB_GET_ELEMENT_AS_TEXT function.
static @NotNull Field<String>	DSL.jsonbGetElementAsText(JSONB field, Field<Integer> index)	The JSONB_GET_ELEMENT_AS_TEXT function.
static @NotNull Condition	DSL.jsonbKeyExists(JSONB json, String key)	The JSONB_KEY_EXISTS function.
static @NotNull Condition	DSL.jsonbKeyExists(JSONB json, Field<String> key)	The JSONB_KEY_EXISTS function.
static @NotNull Field<JSONB>	DSL.jsonbKeys(JSONB field)	The JSONB_KEYS function.
static @NotNull JSONTableColumnsFirstStep	DSL.jsonbTable(JSONB json, String path)	The JSON table function.
static @NotNull Param<JSONB>	DSL.val(JSONB value)	Get a bind value.
static @NotNull Param<JSONB>	DSL.value(JSONB value)	A synonym for DSL.val(JSONB) to be used in Scala and Groovy, where val is a reserved keyword.

Method parameters in org.jooq.impl with type arguments of type JSONB

Modifier and Type	Method	Description
default @NotNull QOM.JSONBArrayLength	QOM.JSONBArrayLength.$field(Field<JSONB> newField)
default @NotNull QOM.JSONBGetAttribute	QOM.JSONBGetAttribute.$field(Field<JSONB> newField)	The JSONB document
default @NotNull QOM.JSONBGetAttributeAsText	QOM.JSONBGetAttributeAsText.$field(Field<JSONB> newField)	The JSONB document
default @NotNull QOM.JSONBGetElement	QOM.JSONBGetElement.$field(Field<JSONB> newField)	The JSONB document
default @NotNull QOM.JSONBGetElementAsText	QOM.JSONBGetElementAsText.$field(Field<JSONB> newField)	The JSONB document
default @NotNull QOM.JSONBInsert	QOM.JSONBInsert.$field(Field<JSONB> newField)
default @NotNull QOM.JSONBKeys	QOM.JSONBKeys.$field(Field<JSONB> newField)
default @NotNull QOM.JSONBRemove	QOM.JSONBRemove.$field(Field<JSONB> newField)
default @NotNull QOM.JSONBReplace	QOM.JSONBReplace.$field(Field<JSONB> newField)
default @NotNull QOM.JSONBSet	QOM.JSONBSet.$field(Field<JSONB> newField)
default @NotNull QOM.JSONBKeyExists	QOM.JSONBKeyExists.$json(Field<JSONB> newJson)	The JSONB object
static @NotNull Field<Integer>	DSL.jsonbArrayLength(Field<JSONB> field)	The JSONB_ARRAY_LENGTH function.
static @NotNull JSONExistsOnStep	DSL.jsonbExists(Field<JSONB> field, String path)	The JSONB exists predicate.
static @NotNull JSONExistsOnStep	DSL.jsonbExists(Field<JSONB> field, Field<String> path)	The JSONB exists predicate.
static @NotNull Field<JSONB>	DSL.jsonbGetAttribute(Field<JSONB> field, String attribute)	The JSONB_GET_ATTRIBUTE function.
static @NotNull Field<JSONB>	DSL.jsonbGetAttribute(Field<JSONB> field, Field<String> attribute)	The JSONB_GET_ATTRIBUTE function.
static @NotNull Field<String>	DSL.jsonbGetAttributeAsText(Field<JSONB> field, String attribute)	The JSONB_GET_ATTRIBUTE_AS_TEXT function.
static @NotNull Field<String>	DSL.jsonbGetAttributeAsText(Field<JSONB> field, Field<String> attribute)	The JSONB_GET_ATTRIBUTE_AS_TEXT function.
static @NotNull Field<JSONB>	DSL.jsonbGetElement(Field<JSONB> field, int index)	The JSONB_GET_ELEMENT function.
static @NotNull Field<JSONB>	DSL.jsonbGetElement(Field<JSONB> field, Field<Integer> index)	The JSONB_GET_ELEMENT function.
static @NotNull Field<String>	DSL.jsonbGetElementAsText(Field<JSONB> field, int index)	The JSONB_GET_ELEMENT_AS_TEXT function.
static @NotNull Field<String>	DSL.jsonbGetElementAsText(Field<JSONB> field, Field<Integer> index)	The JSONB_GET_ELEMENT_AS_TEXT function.
static @NotNull Field<JSONB>	DSL.jsonbInsert(Field<JSONB> field, String path, Object value)	The JSONB_INSERT function.
static @NotNull Field<JSONB>	DSL.jsonbInsert(Field<JSONB> field, String path, Field<?> value)	The JSONB_INSERT function.
static @NotNull Field<JSONB>	DSL.jsonbInsert(Field<JSONB> field, Field<String> path, Object value)	The JSONB_INSERT function.
static @NotNull Field<JSONB>	DSL.jsonbInsert(Field<JSONB> field, Field<String> path, Field<?> value)	The JSONB_INSERT function.
static @NotNull Condition	DSL.jsonbKeyExists(Field<JSONB> json, String key)	The JSONB_KEY_EXISTS function.
static @NotNull Condition	DSL.jsonbKeyExists(Field<JSONB> json, Field<String> key)	The JSONB_KEY_EXISTS function.
static @NotNull Field<JSONB>	DSL.jsonbKeys(Field<JSONB> field)	The JSONB_KEYS function.
static @NotNull JSONQueryOnStep<JSONB>	DSL.jsonbQuery(Field<JSONB> json, String path)	The JSONB_QUERY function.
static @NotNull JSONQueryOnStep<JSONB>	DSL.jsonbQuery(Field<JSONB> json, Field<String> path)	The JSONB_QUERY function.
static @NotNull Field<JSONB>	DSL.jsonbRemove(Field<JSONB> field, String path)	The JSONB_REMOVE function.
static @NotNull Field<JSONB>	DSL.jsonbRemove(Field<JSONB> field, Field<String> path)	The JSONB_REMOVE function.
static @NotNull Field<JSONB>	DSL.jsonbReplace(Field<JSONB> field, String path, Object value)	The JSONB_REPLACE function.
static @NotNull Field<JSONB>	DSL.jsonbReplace(Field<JSONB> field, String path, Field<?> value)	The JSONB_REPLACE function.
static @NotNull Field<JSONB>	DSL.jsonbReplace(Field<JSONB> field, Field<String> path, Object value)	The JSONB_REPLACE function.
static @NotNull Field<JSONB>	DSL.jsonbReplace(Field<JSONB> field, Field<String> path, Field<?> value)	The JSONB_REPLACE function.
static @NotNull Field<JSONB>	DSL.jsonbSet(Field<JSONB> field, String path, Object value)	The JSONB_SET function.
static @NotNull Field<JSONB>	DSL.jsonbSet(Field<JSONB> field, String path, Field<?> value)	The JSONB_SET function.
static @NotNull Field<JSONB>	DSL.jsonbSet(Field<JSONB> field, Field<String> path, Object value)	The JSONB_SET function.
static @NotNull Field<JSONB>	DSL.jsonbSet(Field<JSONB> field, Field<String> path, Field<?> value)	The JSONB_SET function.
static @NotNull JSONTableColumnsFirstStep	DSL.jsonbTable(Field<JSONB> json, Field<String> path)	The JSON table function.
static @NotNull JSONValueOnStep<JSONB>	DSL.jsonbValue(Field<JSONB> json, String path)	The JSONB_VALUE function.
static @NotNull JSONValueOnStep<JSONB>	DSL.jsonbValue(Field<JSONB> json, Field<String> path)	The JSONB_VALUE function.