Uses of Class
org.jooq.JSON
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
This package contains classes related to the
SQLDialect.ACCESS
dialect family.This package contains classes related to the
SQLDialect.ASE
dialect family.This package contains classes related to the
SQLDialect.COCKROACHDB
dialect family.This package contains classes related to the
SQLDialect.DB2
dialect family.This package contains classes related to the
SQLDialect.DERBY
dialect family.This package contains classes related to the
SQLDialect.EXASOL
dialect family.This package contains classes related to the
SQLDialect.FIREBIRD
dialect family.This package contains classes related to the
SQLDialect.H2
dialect family.This package contains classes related to the
SQLDialect.HANA
dialect family.This package contains classes related to the
SQLDialect.HSQLDB
dialect family.This package contains classes related to the
SQLDialect.INFORMIX
dialect family.This package contains classes related to the
SQLDialect.INGRES
dialect family.This package contains classes related to the
SQLDialect.MARIADB
dialect family.This package contains classes related to the
SQLDialect.MEMSQL
dialect family.This package contains classes related to the
SQLDialect.MYSQL
dialect family.This package contains classes related to the
SQLDialect.ORACLE
dialect family.This package contains classes related to the
SQLDialect.POSTGRES
dialect family.This package contains classes related to the
SQLDialect.SNOWFLAKE
dialect family.This package contains classes related to the
SQLDialect.SQLITE
dialect family.This package contains classes related to the
SQLDialect.SYBASE
dialect family.This package contains classes related to the
SQLDialect.TERADATA
dialect family.This package contains classes related to the
SQLDialect.VERTICA
dialect family.This package contains classes related to the
SQLDialect.YUGABYTEDB
dialect family.-
Uses of JSON in org.jooq
Modifier and TypeMethodDescriptionstatic final @NotNull JSON
Create a newJSON
instance from string data input.static final @Nullable JSON
JSON.jsonOrNull
(String data) static final @NotNull JSON
Create a newJSON
instance from string data input.Modifier and TypeMethodDescription@NotNull SelectForJSONStep
<Record1<JSON>> SelectForStep.forJSON()
Add a SQL Server-styleFOR JSON
clause. -
Uses of JSON in org.jooq.impl
Modifier and TypeMethodDescriptionQOM.JSONArrayLength.$field()
QOM.JSONGetAttribute.$field()
The JSON documentQOM.JSONGetAttributeAsText.$field()
The JSON documentQOM.JSONGetElement.$field()
The JSON documentQOM.JSONGetElementAsText.$field()
The JSON documentQOM.JSONInsert.$field()
QOM.JSONKeys.$field()
QOM.JSONRemove.$field()
QOM.JSONReplace.$field()
QOM.JSONSet.$field()
QOM.JSONKeyExists.$json()
The JSON objectCreate a bind value that is always inlined.static @NotNull JSONArrayNullStep
<JSON> DSL.jsonArray
(Collection<? extends Field<?>> fields) TheJSON_ARRAY
function.static @NotNull JSONArrayNullStep
<JSON> TheJSON_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.DSL.jsonGetAttribute
(Field<JSON> field, String attribute) TheJSON_GET_ATTRIBUTE
function.DSL.jsonGetAttribute
(Field<JSON> field, Field<String> attribute) TheJSON_GET_ATTRIBUTE
function.DSL.jsonGetAttribute
(JSON field, String attribute) TheJSON_GET_ATTRIBUTE
function.DSL.jsonGetAttribute
(JSON field, Field<String> attribute) TheJSON_GET_ATTRIBUTE
function.DSL.jsonGetElement
(Field<JSON> field, int index) TheJSON_GET_ELEMENT
function.DSL.jsonGetElement
(Field<JSON> field, Field<Integer> index) TheJSON_GET_ELEMENT
function.DSL.jsonGetElement
(JSON field, int index) TheJSON_GET_ELEMENT
function.DSL.jsonGetElement
(JSON field, Field<Integer> index) TheJSON_GET_ELEMENT
function.DSL.jsonInsert
(Field<JSON> field, String path, Object value) TheJSON_INSERT
function.DSL.jsonInsert
(Field<JSON> field, String path, Field<?> value) TheJSON_INSERT
function.TheJSON_INSERT
function.TheJSON_INSERT
function.TheJSON_KEYS
function.TheJSON_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) TheJSON_OBJECT
function.static @NotNull JSONObjectNullStep
<JSON> DSL.jsonObject
(Field<?>... entries) Deprecated, for removal: This API element is subject to removal in a future version.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) TheJSON_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.DSL.jsonRemove
(Field<JSON> field, String path) TheJSON_REMOVE
function.DSL.jsonRemove
(Field<JSON> field, Field<String> path) TheJSON_REMOVE
function.DSL.jsonReplace
(Field<JSON> field, String path, Object value) TheJSON_REPLACE
function.DSL.jsonReplace
(Field<JSON> field, String path, Field<?> value) TheJSON_REPLACE
function.TheJSON_REPLACE
function.TheJSON_REPLACE
function.TheJSON_SET
function.TheJSON_SET
function.TheJSON_SET
function.TheJSON_SET
function.static @NotNull JSONValueOnStep
<JSON> The JSON value extractor function.static @NotNull JSONValueOnStep
<JSON> The JSON value extractor function.Get a bind value.A synonym forDSL.val(JSON)
to be used in Scala and Groovy, whereval
is a reserved keyword.Modifier and TypeMethodDescriptionCreate a bind value that is always inlined.DSL.jsonArrayLength
(JSON field) TheJSON_ARRAY_LENGTH
function.DSL.jsonGetAttribute
(JSON field, String attribute) TheJSON_GET_ATTRIBUTE
function.DSL.jsonGetAttribute
(JSON field, Field<String> attribute) TheJSON_GET_ATTRIBUTE
function.DSL.jsonGetAttributeAsText
(JSON field, String attribute) TheJSON_GET_ATTRIBUTE_AS_TEXT
function.DSL.jsonGetAttributeAsText
(JSON field, Field<String> attribute) TheJSON_GET_ATTRIBUTE_AS_TEXT
function.DSL.jsonGetElement
(JSON field, int index) TheJSON_GET_ELEMENT
function.DSL.jsonGetElement
(JSON field, Field<Integer> index) TheJSON_GET_ELEMENT
function.DSL.jsonGetElementAsText
(JSON field, int index) TheJSON_GET_ELEMENT_AS_TEXT
function.DSL.jsonGetElementAsText
(JSON field, Field<Integer> index) TheJSON_GET_ELEMENT_AS_TEXT
function.static @NotNull Condition
DSL.jsonKeyExists
(JSON json, String key) TheJSON_KEY_EXISTS
function.static @NotNull Condition
DSL.jsonKeyExists
(JSON json, Field<String> key) TheJSON_KEY_EXISTS
function.TheJSON_KEYS
function.static @NotNull JSONTableColumnsFirstStep
The JSON table function.Get a bind value.A synonym forDSL.val(JSON)
to be used in Scala and Groovy, whereval
is a reserved keyword.Modifier and TypeMethodDescriptiondefault @NotNull QOM.JSONArrayLength
default @NotNull QOM.JSONGetAttribute
The JSON documentdefault @NotNull QOM.JSONGetAttributeAsText
The JSON documentdefault @NotNull QOM.JSONGetElement
The JSON documentdefault @NotNull QOM.JSONGetElementAsText
The JSON documentdefault @NotNull QOM.JSONInsert
default @NotNull QOM.JSONKeys
default @NotNull QOM.JSONRemove
default @NotNull QOM.JSONReplace
default @NotNull QOM.JSONSet
default @NotNull QOM.JSONKeyExists
The JSON objectDSL.jsonArrayLength
(Field<JSON> field) TheJSON_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.DSL.jsonGetAttribute
(Field<JSON> field, String attribute) TheJSON_GET_ATTRIBUTE
function.DSL.jsonGetAttribute
(Field<JSON> field, Field<String> attribute) TheJSON_GET_ATTRIBUTE
function.DSL.jsonGetAttributeAsText
(Field<JSON> field, String attribute) TheJSON_GET_ATTRIBUTE_AS_TEXT
function.DSL.jsonGetAttributeAsText
(Field<JSON> field, Field<String> attribute) TheJSON_GET_ATTRIBUTE_AS_TEXT
function.DSL.jsonGetElement
(Field<JSON> field, int index) TheJSON_GET_ELEMENT
function.DSL.jsonGetElement
(Field<JSON> field, Field<Integer> index) TheJSON_GET_ELEMENT
function.DSL.jsonGetElementAsText
(Field<JSON> field, int index) TheJSON_GET_ELEMENT_AS_TEXT
function.DSL.jsonGetElementAsText
(Field<JSON> field, Field<Integer> index) TheJSON_GET_ELEMENT_AS_TEXT
function.DSL.jsonInsert
(Field<JSON> field, String path, Object value) TheJSON_INSERT
function.DSL.jsonInsert
(Field<JSON> field, String path, Field<?> value) TheJSON_INSERT
function.TheJSON_INSERT
function.TheJSON_INSERT
function.static @NotNull Condition
DSL.jsonKeyExists
(Field<JSON> json, String key) TheJSON_KEY_EXISTS
function.static @NotNull Condition
DSL.jsonKeyExists
(Field<JSON> json, Field<String> key) TheJSON_KEY_EXISTS
function.TheJSON_KEYS
function.DSL.jsonRemove
(Field<JSON> field, String path) TheJSON_REMOVE
function.DSL.jsonRemove
(Field<JSON> field, Field<String> path) TheJSON_REMOVE
function.DSL.jsonReplace
(Field<JSON> field, String path, Object value) TheJSON_REPLACE
function.DSL.jsonReplace
(Field<JSON> field, String path, Field<?> value) TheJSON_REPLACE
function.TheJSON_REPLACE
function.TheJSON_REPLACE
function.TheJSON_SET
function.TheJSON_SET
function.TheJSON_SET
function.TheJSON_SET
function.static @NotNull JSONTableColumnsFirstStep
The JSON table function.static @NotNull JSONValueOnStep
<JSON> The JSON value extractor function.static @NotNull JSONValueOnStep
<JSON> The JSON value extractor function. -
Uses of JSON in org.jooq.util.access
-
Uses of JSON in org.jooq.util.ase
-
Uses of JSON in org.jooq.util.cockroachdb
-
Uses of JSON in org.jooq.util.db2
-
Uses of JSON in org.jooq.util.derby
-
Uses of JSON in org.jooq.util.exasol
-
Uses of JSON in org.jooq.util.firebird
-
Uses of JSON in org.jooq.util.h2
-
Uses of JSON in org.jooq.util.hana
-
Uses of JSON in org.jooq.util.hsqldb
-
Uses of JSON in org.jooq.util.informix
-
Uses of JSON in org.jooq.util.ingres
-
Uses of JSON in org.jooq.util.mariadb
-
Uses of JSON in org.jooq.util.memsql
-
Uses of JSON in org.jooq.util.mysql
-
Uses of JSON in org.jooq.util.oracle
-
Uses of JSON in org.jooq.util.postgres
-
Uses of JSON in org.jooq.util.snowflake
Modifier and TypeFieldDescriptionSnowflakeDataType.ARRAY
Deprecated, for removal: This API element is subject to removal in a future version.SnowflakeDataType.OBJECT
Deprecated, for removal: This API element is subject to removal in a future version.SnowflakeDataType.VARIANT
Deprecated, for removal: This API element is subject to removal in a future version. -
Uses of JSON in org.jooq.util.sqlite
-
Uses of JSON in org.jooq.util.sybase
-
Uses of JSON in org.jooq.util.teradata
-
Uses of JSON in org.jooq.util.vertica
-
Uses of JSON in org.jooq.util.yugabytedb
Field
arguments in this method is inconsistent with that of other overloads, such asDSL.jsonbObject(Field, Field)
, which can lead to subtle bugs.