Uses of Class
org.jooq.JSONB
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.BIGQUERY
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 JSONB in org.jooq
Modifier and TypeMethodDescriptionstatic final @NotNull JSONB
Create a newJSONB
instance from string data input.static final @Nullable JSONB
JSONB.jsonbOrNull
(String data) static final @NotNull JSONB
Create a newJSONB
instance from string data input.Modifier and TypeMethodDescription@NotNull SelectForJSONStep
<Record1<JSONB>> SelectForStep.forJSONB()
Add a SQL Server-styleFOR JSON
clause. -
Uses of JSONB in org.jooq.impl
Modifier and TypeMethodDescriptionQOM.JSONBArrayLength.$field()
QOM.JSONBGetAttribute.$field()
The JSONB documentQOM.JSONBGetAttributeAsText.$field()
The JSONB documentQOM.JSONBGetElement.$field()
The JSONB documentQOM.JSONBGetElementAsText.$field()
The JSONB documentQOM.JSONBInsert.$field()
QOM.JSONBKeys.$field()
QOM.JSONBRemove.$field()
QOM.JSONBReplace.$field()
QOM.JSONBSet.$field()
QOM.JSONBKeyExists.$json()
The JSONB objectCreate a bind value that is always inlined.static @NotNull JSONArrayNullStep
<JSONB> DSL.jsonbArray
(Collection<? extends Field<?>> fields) TheJSONB_ARRAY
function.static @NotNull JSONArrayNullStep
<JSONB> DSL.jsonbArray
(Field<?>... fields) TheJSONB_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.DSL.jsonbGetAttribute
(Field<JSONB> field, String attribute) TheJSONB_GET_ATTRIBUTE
function.DSL.jsonbGetAttribute
(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE
function.DSL.jsonbGetAttribute
(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTE
function.DSL.jsonbGetAttribute
(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE
function.DSL.jsonbGetElement
(Field<JSONB> field, int index) TheJSONB_GET_ELEMENT
function.DSL.jsonbGetElement
(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENT
function.DSL.jsonbGetElement
(JSONB field, int index) TheJSONB_GET_ELEMENT
function.DSL.jsonbGetElement
(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENT
function.DSL.jsonbInsert
(Field<JSONB> field, String path, Object value) TheJSONB_INSERT
function.DSL.jsonbInsert
(Field<JSONB> field, String path, Field<?> value) TheJSONB_INSERT
function.TheJSONB_INSERT
function.TheJSONB_INSERT
function.TheJSONB_KEYS
function.TheJSONB_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) TheJSONB_OBJECT
function.static @NotNull JSONObjectNullStep
<JSONB> DSL.jsonbObject
(Field<?>... entries) Deprecated, for removal: This API element is subject to removal in a future version.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) TheJSONB_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.DSL.jsonbRemove
(Field<JSONB> field, String path) TheJSONB_REMOVE
function.DSL.jsonbRemove
(Field<JSONB> field, Field<String> path) TheJSONB_REMOVE
function.DSL.jsonbReplace
(Field<JSONB> field, String path, Object value) TheJSONB_REPLACE
function.DSL.jsonbReplace
(Field<JSONB> field, String path, Field<?> value) TheJSONB_REPLACE
function.TheJSONB_REPLACE
function.TheJSONB_REPLACE
function.TheJSONB_SET
function.TheJSONB_SET
function.TheJSONB_SET
function.TheJSONB_SET
function.static @NotNull JSONValueOnStep
<JSONB> DSL.jsonbValue
(Field<JSONB> json, String path) The JSON value extractor function.static @NotNull JSONValueOnStep
<JSONB> DSL.jsonbValue
(Field<JSONB> json, Field<String> path) The JSON value extractor function.Get a bind value.A synonym forDSL.val(JSONB)
to be used in Scala and Groovy, whereval
is a reserved keyword.Modifier and TypeMethodDescriptionCreate a bind value that is always inlined.DSL.jsonbArrayLength
(JSONB field) TheJSONB_ARRAY_LENGTH
function.DSL.jsonbGetAttribute
(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTE
function.DSL.jsonbGetAttribute
(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE
function.DSL.jsonbGetAttributeAsText
(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXT
function.DSL.jsonbGetAttributeAsText
(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXT
function.DSL.jsonbGetElement
(JSONB field, int index) TheJSONB_GET_ELEMENT
function.DSL.jsonbGetElement
(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENT
function.DSL.jsonbGetElementAsText
(JSONB field, int index) TheJSONB_GET_ELEMENT_AS_TEXT
function.DSL.jsonbGetElementAsText
(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENT_AS_TEXT
function.static @NotNull Condition
DSL.jsonbKeyExists
(JSONB json, String key) TheJSONB_KEY_EXISTS
function.static @NotNull Condition
DSL.jsonbKeyExists
(JSONB json, Field<String> key) TheJSONB_KEY_EXISTS
function.TheJSONB_KEYS
function.static @NotNull JSONTableColumnsFirstStep
DSL.jsonbTable
(JSONB json, String path) The JSON table function.Get a bind value.A synonym forDSL.val(JSONB)
to be used in Scala and Groovy, whereval
is a reserved keyword.Modifier and TypeMethodDescriptiondefault @NotNull QOM.JSONBArrayLength
default @NotNull QOM.JSONBGetAttribute
The JSONB documentdefault @NotNull QOM.JSONBGetAttributeAsText
The JSONB documentdefault @NotNull QOM.JSONBGetElement
The JSONB documentdefault @NotNull QOM.JSONBGetElementAsText
The JSONB documentdefault @NotNull QOM.JSONBInsert
default @NotNull QOM.JSONBKeys
default @NotNull QOM.JSONBRemove
default @NotNull QOM.JSONBReplace
default @NotNull QOM.JSONBSet
default @NotNull QOM.JSONBKeyExists
The JSONB objectDSL.jsonbArrayLength
(Field<JSONB> field) TheJSONB_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.DSL.jsonbGetAttribute
(Field<JSONB> field, String attribute) TheJSONB_GET_ATTRIBUTE
function.DSL.jsonbGetAttribute
(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE
function.DSL.jsonbGetAttributeAsText
(Field<JSONB> field, String attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXT
function.DSL.jsonbGetAttributeAsText
(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXT
function.DSL.jsonbGetElement
(Field<JSONB> field, int index) TheJSONB_GET_ELEMENT
function.DSL.jsonbGetElement
(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENT
function.DSL.jsonbGetElementAsText
(Field<JSONB> field, int index) TheJSONB_GET_ELEMENT_AS_TEXT
function.DSL.jsonbGetElementAsText
(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENT_AS_TEXT
function.DSL.jsonbInsert
(Field<JSONB> field, String path, Object value) TheJSONB_INSERT
function.DSL.jsonbInsert
(Field<JSONB> field, String path, Field<?> value) TheJSONB_INSERT
function.TheJSONB_INSERT
function.TheJSONB_INSERT
function.static @NotNull Condition
DSL.jsonbKeyExists
(Field<JSONB> json, String key) TheJSONB_KEY_EXISTS
function.static @NotNull Condition
DSL.jsonbKeyExists
(Field<JSONB> json, Field<String> key) TheJSONB_KEY_EXISTS
function.TheJSONB_KEYS
function.DSL.jsonbRemove
(Field<JSONB> field, String path) TheJSONB_REMOVE
function.DSL.jsonbRemove
(Field<JSONB> field, Field<String> path) TheJSONB_REMOVE
function.DSL.jsonbReplace
(Field<JSONB> field, String path, Object value) TheJSONB_REPLACE
function.DSL.jsonbReplace
(Field<JSONB> field, String path, Field<?> value) TheJSONB_REPLACE
function.TheJSONB_REPLACE
function.TheJSONB_REPLACE
function.TheJSONB_SET
function.TheJSONB_SET
function.TheJSONB_SET
function.TheJSONB_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 JSON value extractor function.static @NotNull JSONValueOnStep
<JSONB> DSL.jsonbValue
(Field<JSONB> json, Field<String> path) The JSON value extractor function. -
Uses of JSONB in org.jooq.util.access
-
Uses of JSONB in org.jooq.util.ase
-
Uses of JSONB in org.jooq.util.bigquery
-
Uses of JSONB in org.jooq.util.cockroachdb
-
Uses of JSONB in org.jooq.util.db2
-
Uses of JSONB in org.jooq.util.derby
-
Uses of JSONB in org.jooq.util.exasol
-
Uses of JSONB in org.jooq.util.firebird
-
Uses of JSONB in org.jooq.util.h2
-
Uses of JSONB in org.jooq.util.hana
-
Uses of JSONB in org.jooq.util.hsqldb
-
Uses of JSONB in org.jooq.util.informix
-
Uses of JSONB in org.jooq.util.ingres
-
Uses of JSONB in org.jooq.util.mariadb
-
Uses of JSONB in org.jooq.util.memsql
-
Uses of JSONB in org.jooq.util.mysql
-
Uses of JSONB in org.jooq.util.oracle
-
Uses of JSONB in org.jooq.util.postgres
-
Uses of JSONB in org.jooq.util.snowflake
-
Uses of JSONB in org.jooq.util.sqlite
-
Uses of JSONB in org.jooq.util.sybase
-
Uses of JSONB in org.jooq.util.teradata
-
Uses of JSONB in org.jooq.util.vertica
-
Uses of JSONB 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.