Uses of Class
org.jooq.JSONB
Packages that use 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
Fields in org.jooq.impl with type parameters of type JSONBMethods in org.jooq.impl that return types with arguments of type JSONBModifier and TypeMethodDescriptionQOM.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()
Create 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.Methods in org.jooq.impl with parameters of type JSONBModifier and TypeMethodDescriptionCreate a bind value that is always inlined.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.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.Method parameters in org.jooq.impl with type arguments of type JSONBModifier and TypeMethodDescriptiondefault @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
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.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
Fields in org.jooq.util.access with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.ase
Fields in org.jooq.util.ase with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.bigquery
Fields in org.jooq.util.bigquery with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.cockroachdb
Fields in org.jooq.util.cockroachdb with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.db2
Fields in org.jooq.util.db2 with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.derby
Fields in org.jooq.util.derby with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.exasol
Fields in org.jooq.util.exasol with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.firebird
Fields in org.jooq.util.firebird with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.h2
Fields in org.jooq.util.h2 with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.hana
Fields in org.jooq.util.hana with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.hsqldb
Fields in org.jooq.util.hsqldb with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.informix
Fields in org.jooq.util.informix with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.ingres
Fields in org.jooq.util.ingres with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.mariadb
Fields in org.jooq.util.mariadb with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.memsql
Fields in org.jooq.util.memsql with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.mysql
Fields in org.jooq.util.mysql with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.oracle
Fields in org.jooq.util.oracle with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.postgres
Fields in org.jooq.util.postgres with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.snowflake
Fields in org.jooq.util.snowflake with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.sqlite
Fields in org.jooq.util.sqlite with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.sybase
Fields in org.jooq.util.sybase with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.teradata
Fields in org.jooq.util.teradata with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.vertica
Fields in org.jooq.util.vertica with type parameters of type JSONB -
Uses of JSONB in org.jooq.util.yugabytedb
Fields in org.jooq.util.yugabytedb with type parameters of type JSONB
Field
arguments in this method is inconsistent with that of other overloads, such asDSL.jsonbObject(Field, Field)
, which can lead to subtle bugs.