Uses of Class
org.jooq.JSON

Packages that use JSON

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

Uses of JSON in org.jooq

Methods in org.jooq that return JSON

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

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

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

Uses of JSON in org.jooq.impl

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

Modifier and Type	Interface	Description
static interface	QOM.JSONArrayLength	The JSON ARRAY LENGTH function.
static interface	QOM.JSONGetAttribute	The JSON GET ATTRIBUTE function.
static interface	QOM.JSONGetAttribute	The JSON GET ATTRIBUTE function.
static interface	QOM.JSONGetAttributeAsText	The JSON GET ATTRIBUTE AS TEXT function.
static interface	QOM.JSONGetElement	The JSON GET ELEMENT function.
static interface	QOM.JSONGetElement	The JSON GET ELEMENT function.
static interface	QOM.JSONGetElementAsText	The JSON GET ELEMENT AS TEXT function.
static interface	QOM.JSONInsert	The JSON INSERT function.
static interface	QOM.JSONInsert	The JSON INSERT function.
static interface	QOM.JSONKeyExists	The JSON KEY EXISTS function.
static interface	QOM.JSONKeys	The JSON KEYS function.
static interface	QOM.JSONKeys	The JSON KEYS function.
static interface	QOM.JSONRemove	The JSON REMOVE function.
static interface	QOM.JSONRemove	The JSON REMOVE function.
static interface	QOM.JSONReplace	The JSON REPLACE function.
static interface	QOM.JSONReplace	The JSON REPLACE function.
static interface	QOM.JSONSet	The JSON SET function.
static interface	QOM.JSONSet	The JSON SET function.

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

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

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

Modifier and Type	Method	Description
default @NotNull Field<JSON>	QOM.JSONArrayLength.$field()
default @NotNull Field<JSON>	QOM.JSONGetAttribute.$field()	The JSON document
default @NotNull Field<JSON>	QOM.JSONGetAttributeAsText.$field()	The JSON document
default @NotNull Field<JSON>	QOM.JSONGetElement.$field()	The JSON document
default @NotNull Field<JSON>	QOM.JSONGetElementAsText.$field()	The JSON document
default @NotNull Field<JSON>	QOM.JSONInsert.$field()
default @NotNull Field<JSON>	QOM.JSONKeys.$field()
default @NotNull Field<JSON>	QOM.JSONRemove.$field()
default @NotNull Field<JSON>	QOM.JSONReplace.$field()
default @NotNull Field<JSON>	QOM.JSONSet.$field()
default @NotNull Field<JSON>	QOM.JSONKeyExists.$json()	The JSON object
static @NotNull Param<JSON>	DSL.inline(JSON value)	Create a bind value that is always inlined.
static @NotNull JSONArrayNullStep<JSON>	DSL.jsonArray(Collection<? extends Field<?>> fields)	The JSON_ARRAY function.
static @NotNull JSONArrayNullStep<JSON>	DSL.jsonArray(Field<?>... fields)	The JSON_ARRAY function.
static <T> @NotNull JSONArrayQueryNullStep<JSON>	DSL.jsonArray(Select<? extends Record1<?>> select)	The JSON_ARRAY function.
static @NotNull JSONArrayAggOrderByStep<JSON>	DSL.jsonArrayAgg(Field<?> value)	The JSON array aggregate function.
static @NotNull JSONArrayAggOrderByStep<JSON>	DSL.jsonArrayAggDistinct(Field<?> value)	The JSON array aggregate function.
static @NotNull Field<JSON>	DSL.jsonGetAttribute(Field<JSON> field, String attribute)	The JSON_GET_ATTRIBUTE function.
static @NotNull Field<JSON>	DSL.jsonGetAttribute(Field<JSON> field, Field<String> attribute)	The JSON_GET_ATTRIBUTE function.
static @NotNull Field<JSON>	DSL.jsonGetAttribute(JSON field, String attribute)	The JSON_GET_ATTRIBUTE function.
static @NotNull Field<JSON>	DSL.jsonGetAttribute(JSON field, Field<String> attribute)	The JSON_GET_ATTRIBUTE function.
static @NotNull Field<JSON>	DSL.jsonGetElement(Field<JSON> field, int index)	The JSON_GET_ELEMENT function.
static @NotNull Field<JSON>	DSL.jsonGetElement(Field<JSON> field, Field<Integer> index)	The JSON_GET_ELEMENT function.
static @NotNull Field<JSON>	DSL.jsonGetElement(JSON field, int index)	The JSON_GET_ELEMENT function.
static @NotNull Field<JSON>	DSL.jsonGetElement(JSON field, Field<Integer> index)	The JSON_GET_ELEMENT function.
static @NotNull Field<JSON>	DSL.jsonInsert(Field<JSON> field, String path, Object value)	The JSON_INSERT function.
static @NotNull Field<JSON>	DSL.jsonInsert(Field<JSON> field, String path, Field<?> value)	The JSON_INSERT function.
static @NotNull Field<JSON>	DSL.jsonInsert(Field<JSON> field, Field<String> path, Object value)	The JSON_INSERT function.
static @NotNull Field<JSON>	DSL.jsonInsert(Field<JSON> field, Field<String> path, Field<?> value)	The JSON_INSERT function.
static @NotNull Field<JSON>	DSL.jsonKeys(Field<JSON> field)	The JSON_KEYS function.
static @NotNull Field<JSON>	DSL.jsonKeys(JSON field)	The JSON_KEYS function.
static @NotNull JSONObjectNullStep<JSON>	DSL.jsonObject()	The JSON object constructor.
static @NotNull JSONObjectNullStep<JSON>	DSL.jsonObject(String key, Field<?> value)	The JSON object constructor.
static @NotNull JSONObjectNullStep<JSON>	DSL.jsonObject(Collection<? extends JSONEntry<?>> entries)	The JSON_OBJECT function.
static @NotNull JSONObjectNullStep<JSON>	DSL.jsonObject(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<JSON>	DSL.jsonObject(Field<String> key, Field<?> value)	The JSON object constructor.
static @NotNull JSONObjectNullStep<JSON>	DSL.jsonObject(Field<String> key, Select<? extends Record1<?>> value)	The JSON object constructor.
static @NotNull JSONObjectNullStep<JSON>	DSL.jsonObject(JSONEntry<?>... entries)	The JSON_OBJECT function.
static @NotNull JSONObjectAggNullStep<JSON>	DSL.jsonObjectAgg(String key, Field<?> value)	The JSON object aggregate function.
static @NotNull JSONObjectAggNullStep<JSON>	DSL.jsonObjectAgg(Field<?> value)	The JSON object aggregate function.
static @NotNull JSONObjectAggNullStep<JSON>	DSL.jsonObjectAgg(Field<String> key, Field<?> value)	The JSON object aggregate function.
static @NotNull JSONObjectAggNullStep<JSON>	DSL.jsonObjectAgg(JSONEntry<?> entry)	The JSON object aggregate function.
static @NotNull JSONQueryOnStep<JSON>	DSL.jsonQuery(Field<JSON> json, String path)	The JSON_QUERY function.
static @NotNull JSONQueryOnStep<JSON>	DSL.jsonQuery(Field<JSON> json, Field<String> path)	The JSON_QUERY function.
static @NotNull Field<JSON>	DSL.jsonRemove(Field<JSON> field, String path)	The JSON_REMOVE function.
static @NotNull Field<JSON>	DSL.jsonRemove(Field<JSON> field, Field<String> path)	The JSON_REMOVE function.
static @NotNull Field<JSON>	DSL.jsonReplace(Field<JSON> field, String path, Object value)	The JSON_REPLACE function.
static @NotNull Field<JSON>	DSL.jsonReplace(Field<JSON> field, String path, Field<?> value)	The JSON_REPLACE function.
static @NotNull Field<JSON>	DSL.jsonReplace(Field<JSON> field, Field<String> path, Object value)	The JSON_REPLACE function.
static @NotNull Field<JSON>	DSL.jsonReplace(Field<JSON> field, Field<String> path, Field<?> value)	The JSON_REPLACE function.
static @NotNull Field<JSON>	DSL.jsonSet(Field<JSON> field, String path, Object value)	The JSON_SET function.
static @NotNull Field<JSON>	DSL.jsonSet(Field<JSON> field, String path, Field<?> value)	The JSON_SET function.
static @NotNull Field<JSON>	DSL.jsonSet(Field<JSON> field, Field<String> path, Object value)	The JSON_SET function.
static @NotNull Field<JSON>	DSL.jsonSet(Field<JSON> field, Field<String> path, Field<?> value)	The JSON_SET function.
static @NotNull JSONValueOnStep<JSON>	DSL.jsonValue(Field<JSON> json, String path)	The JSON_VALUE function.
static @NotNull JSONValueOnStep<JSON>	DSL.jsonValue(Field<JSON> json, Field<String> path)	The JSON_VALUE function.
static @NotNull Param<JSON>	DSL.val(JSON value)	Get a bind value.
static @NotNull Param<JSON>	DSL.value(JSON value)	A synonym for DSL.val(JSON) to be used in Scala and Groovy, where val is a reserved keyword.

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

Modifier and Type	Method	Description
static @NotNull Param<JSON>	DSL.inline(JSON value)	Create a bind value that is always inlined.
static @NotNull Field<Integer>	DSL.jsonArrayLength(JSON field)	The JSON_ARRAY_LENGTH function.
static @NotNull Field<JSON>	DSL.jsonGetAttribute(JSON field, String attribute)	The JSON_GET_ATTRIBUTE function.
static @NotNull Field<JSON>	DSL.jsonGetAttribute(JSON field, Field<String> attribute)	The JSON_GET_ATTRIBUTE function.
static @NotNull Field<String>	DSL.jsonGetAttributeAsText(JSON field, String attribute)	The JSON_GET_ATTRIBUTE_AS_TEXT function.
static @NotNull Field<String>	DSL.jsonGetAttributeAsText(JSON field, Field<String> attribute)	The JSON_GET_ATTRIBUTE_AS_TEXT function.
static @NotNull Field<JSON>	DSL.jsonGetElement(JSON field, int index)	The JSON_GET_ELEMENT function.
static @NotNull Field<JSON>	DSL.jsonGetElement(JSON field, Field<Integer> index)	The JSON_GET_ELEMENT function.
static @NotNull Field<String>	DSL.jsonGetElementAsText(JSON field, int index)	The JSON_GET_ELEMENT_AS_TEXT function.
static @NotNull Field<String>	DSL.jsonGetElementAsText(JSON field, Field<Integer> index)	The JSON_GET_ELEMENT_AS_TEXT function.
static @NotNull Condition	DSL.jsonKeyExists(JSON json, String key)	The JSON_KEY_EXISTS function.
static @NotNull Condition	DSL.jsonKeyExists(JSON json, Field<String> key)	The JSON_KEY_EXISTS function.
static @NotNull Field<JSON>	DSL.jsonKeys(JSON field)	The JSON_KEYS function.
static @NotNull JSONTableColumnsFirstStep	DSL.jsonTable(JSON json, String path)	The JSON table function.
static @NotNull Param<JSON>	DSL.val(JSON value)	Get a bind value.
static @NotNull Param<JSON>	DSL.value(JSON value)	A synonym for DSL.val(JSON) to be used in Scala and Groovy, where val is a reserved keyword.

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

Modifier and Type	Method	Description
default @NotNull QOM.JSONArrayLength	QOM.JSONArrayLength.$field(Field<JSON> newField)
default @NotNull QOM.JSONGetAttribute	QOM.JSONGetAttribute.$field(Field<JSON> newField)	The JSON document
default @NotNull QOM.JSONGetAttributeAsText	QOM.JSONGetAttributeAsText.$field(Field<JSON> newField)	The JSON document
default @NotNull QOM.JSONGetElement	QOM.JSONGetElement.$field(Field<JSON> newField)	The JSON document
default @NotNull QOM.JSONGetElementAsText	QOM.JSONGetElementAsText.$field(Field<JSON> newField)	The JSON document
default @NotNull QOM.JSONInsert	QOM.JSONInsert.$field(Field<JSON> newField)
default @NotNull QOM.JSONKeys	QOM.JSONKeys.$field(Field<JSON> newField)
default @NotNull QOM.JSONRemove	QOM.JSONRemove.$field(Field<JSON> newField)
default @NotNull QOM.JSONReplace	QOM.JSONReplace.$field(Field<JSON> newField)
default @NotNull QOM.JSONSet	QOM.JSONSet.$field(Field<JSON> newField)
default @NotNull QOM.JSONKeyExists	QOM.JSONKeyExists.$json(Field<JSON> newJson)	The JSON object
static @NotNull Field<Integer>	DSL.jsonArrayLength(Field<JSON> field)	The JSON_ARRAY_LENGTH function.
static @NotNull JSONExistsOnStep	DSL.jsonExists(Field<JSON> field, String path)	The JSON exists predicate.
static @NotNull JSONExistsOnStep	DSL.jsonExists(Field<JSON> field, Field<String> path)	The JSON exists predicate.
static @NotNull Field<JSON>	DSL.jsonGetAttribute(Field<JSON> field, String attribute)	The JSON_GET_ATTRIBUTE function.
static @NotNull Field<JSON>	DSL.jsonGetAttribute(Field<JSON> field, Field<String> attribute)	The JSON_GET_ATTRIBUTE function.
static @NotNull Field<String>	DSL.jsonGetAttributeAsText(Field<JSON> field, String attribute)	The JSON_GET_ATTRIBUTE_AS_TEXT function.
static @NotNull Field<String>	DSL.jsonGetAttributeAsText(Field<JSON> field, Field<String> attribute)	The JSON_GET_ATTRIBUTE_AS_TEXT function.
static @NotNull Field<JSON>	DSL.jsonGetElement(Field<JSON> field, int index)	The JSON_GET_ELEMENT function.
static @NotNull Field<JSON>	DSL.jsonGetElement(Field<JSON> field, Field<Integer> index)	The JSON_GET_ELEMENT function.
static @NotNull Field<String>	DSL.jsonGetElementAsText(Field<JSON> field, int index)	The JSON_GET_ELEMENT_AS_TEXT function.
static @NotNull Field<String>	DSL.jsonGetElementAsText(Field<JSON> field, Field<Integer> index)	The JSON_GET_ELEMENT_AS_TEXT function.
static @NotNull Field<JSON>	DSL.jsonInsert(Field<JSON> field, String path, Object value)	The JSON_INSERT function.
static @NotNull Field<JSON>	DSL.jsonInsert(Field<JSON> field, String path, Field<?> value)	The JSON_INSERT function.
static @NotNull Field<JSON>	DSL.jsonInsert(Field<JSON> field, Field<String> path, Object value)	The JSON_INSERT function.
static @NotNull Field<JSON>	DSL.jsonInsert(Field<JSON> field, Field<String> path, Field<?> value)	The JSON_INSERT function.
static @NotNull Condition	DSL.jsonKeyExists(Field<JSON> json, String key)	The JSON_KEY_EXISTS function.
static @NotNull Condition	DSL.jsonKeyExists(Field<JSON> json, Field<String> key)	The JSON_KEY_EXISTS function.
static @NotNull Field<JSON>	DSL.jsonKeys(Field<JSON> field)	The JSON_KEYS function.
static @NotNull JSONQueryOnStep<JSON>	DSL.jsonQuery(Field<JSON> json, String path)	The JSON_QUERY function.
static @NotNull JSONQueryOnStep<JSON>	DSL.jsonQuery(Field<JSON> json, Field<String> path)	The JSON_QUERY function.
static @NotNull Field<JSON>	DSL.jsonRemove(Field<JSON> field, String path)	The JSON_REMOVE function.
static @NotNull Field<JSON>	DSL.jsonRemove(Field<JSON> field, Field<String> path)	The JSON_REMOVE function.
static @NotNull Field<JSON>	DSL.jsonReplace(Field<JSON> field, String path, Object value)	The JSON_REPLACE function.
static @NotNull Field<JSON>	DSL.jsonReplace(Field<JSON> field, String path, Field<?> value)	The JSON_REPLACE function.
static @NotNull Field<JSON>	DSL.jsonReplace(Field<JSON> field, Field<String> path, Object value)	The JSON_REPLACE function.
static @NotNull Field<JSON>	DSL.jsonReplace(Field<JSON> field, Field<String> path, Field<?> value)	The JSON_REPLACE function.
static @NotNull Field<JSON>	DSL.jsonSet(Field<JSON> field, String path, Object value)	The JSON_SET function.
static @NotNull Field<JSON>	DSL.jsonSet(Field<JSON> field, String path, Field<?> value)	The JSON_SET function.
static @NotNull Field<JSON>	DSL.jsonSet(Field<JSON> field, Field<String> path, Object value)	The JSON_SET function.
static @NotNull Field<JSON>	DSL.jsonSet(Field<JSON> field, Field<String> path, Field<?> value)	The JSON_SET function.
static @NotNull JSONTableColumnsFirstStep	DSL.jsonTable(Field<JSON> json, Field<String> path)	The JSON table function.
static @NotNull JSONValueOnStep<JSON>	DSL.jsonValue(Field<JSON> json, String path)	The JSON_VALUE function.
static @NotNull JSONValueOnStep<JSON>	DSL.jsonValue(Field<JSON> json, Field<String> path)	The JSON_VALUE function.