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 JSONBCreate a newJSONBinstance from string data input.static final @Nullable JSONBJSONB.jsonbOrNull(String data) static final @NotNull JSONBCreate a newJSONBinstance from string data input.Modifier and TypeMethodDescription@NotNull SelectForJSONStep<Record1<JSONB>> SelectForStep.forJSONB()Add a SQL Server-styleFOR JSONclause. -
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.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_ARRAYfunction.static @NotNull JSONArrayNullStep<JSONB> DSL.jsonbArray(Field<?>... fields) TheJSONB_ARRAYfunction.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_ATTRIBUTEfunction.DSL.jsonbGetAttribute(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttribute(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttribute(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetElement(Field<JSONB> field, int index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElement(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElement(JSONB field, int index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElement(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbInsert(Field<JSONB> field, String path, Object value) TheJSONB_INSERTfunction.DSL.jsonbInsert(Field<JSONB> field, String path, Field<?> value) TheJSONB_INSERTfunction.TheJSONB_INSERTfunction.TheJSONB_INSERTfunction.TheJSONB_KEYSfunction.TheJSONB_KEYSfunction.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_OBJECTfunction.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_OBJECTfunction.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_REMOVEfunction.DSL.jsonbRemove(Field<JSONB> field, Field<String> path) TheJSONB_REMOVEfunction.DSL.jsonbReplace(Field<JSONB> field, String path, Object value) TheJSONB_REPLACEfunction.DSL.jsonbReplace(Field<JSONB> field, String path, Field<?> value) TheJSONB_REPLACEfunction.TheJSONB_REPLACEfunction.TheJSONB_REPLACEfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.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, wherevalis a reserved keyword.Methods in org.jooq.impl with parameters of type JSONBModifier and TypeMethodDescriptionCreate a bind value that is always inlined.DSL.jsonbArrayLength(JSONB field) TheJSONB_ARRAY_LENGTHfunction.DSL.jsonbGetAttribute(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttribute(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttributeAsText(JSONB field, String attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXTfunction.DSL.jsonbGetAttributeAsText(JSONB field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXTfunction.DSL.jsonbGetElement(JSONB field, int index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElement(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElementAsText(JSONB field, int index) TheJSONB_GET_ELEMENT_AS_TEXTfunction.DSL.jsonbGetElementAsText(JSONB field, Field<Integer> index) TheJSONB_GET_ELEMENT_AS_TEXTfunction.static @NotNull ConditionDSL.jsonbKeyExists(JSONB json, String key) TheJSONB_KEY_EXISTSfunction.static @NotNull ConditionDSL.jsonbKeyExists(JSONB json, Field<String> key) TheJSONB_KEY_EXISTSfunction.TheJSONB_KEYSfunction.static @NotNull JSONTableColumnsFirstStepDSL.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, wherevalis a reserved keyword.Method parameters in org.jooq.impl with type arguments of type JSONBModifier and TypeMethodDescriptiondefault @NotNull QOM.JSONBArrayLengthdefault @NotNull QOM.JSONBGetAttributeThe JSONB documentdefault @NotNull QOM.JSONBGetAttributeAsTextThe JSONB documentdefault @NotNull QOM.JSONBGetElementThe JSONB documentdefault @NotNull QOM.JSONBGetElementAsTextThe JSONB documentdefault @NotNull QOM.JSONBInsertdefault @NotNull QOM.JSONBKeysdefault @NotNull QOM.JSONBRemovedefault @NotNull QOM.JSONBReplacedefault @NotNull QOM.JSONBSetdefault @NotNull QOM.JSONBKeyExistsThe JSONB objectDSL.jsonbArrayLength(Field<JSONB> field) TheJSONB_ARRAY_LENGTHfunction.static @NotNull JSONExistsOnStepDSL.jsonbExists(Field<JSONB> field, String path) The JSONB exists predicate.static @NotNull JSONExistsOnStepDSL.jsonbExists(Field<JSONB> field, Field<String> path) The JSONB exists predicate.DSL.jsonbGetAttribute(Field<JSONB> field, String attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttribute(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTEfunction.DSL.jsonbGetAttributeAsText(Field<JSONB> field, String attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXTfunction.DSL.jsonbGetAttributeAsText(Field<JSONB> field, Field<String> attribute) TheJSONB_GET_ATTRIBUTE_AS_TEXTfunction.DSL.jsonbGetElement(Field<JSONB> field, int index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElement(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENTfunction.DSL.jsonbGetElementAsText(Field<JSONB> field, int index) TheJSONB_GET_ELEMENT_AS_TEXTfunction.DSL.jsonbGetElementAsText(Field<JSONB> field, Field<Integer> index) TheJSONB_GET_ELEMENT_AS_TEXTfunction.DSL.jsonbInsert(Field<JSONB> field, String path, Object value) TheJSONB_INSERTfunction.DSL.jsonbInsert(Field<JSONB> field, String path, Field<?> value) TheJSONB_INSERTfunction.TheJSONB_INSERTfunction.TheJSONB_INSERTfunction.static @NotNull ConditionDSL.jsonbKeyExists(Field<JSONB> json, String key) TheJSONB_KEY_EXISTSfunction.static @NotNull ConditionDSL.jsonbKeyExists(Field<JSONB> json, Field<String> key) TheJSONB_KEY_EXISTSfunction.TheJSONB_KEYSfunction.DSL.jsonbRemove(Field<JSONB> field, String path) TheJSONB_REMOVEfunction.DSL.jsonbRemove(Field<JSONB> field, Field<String> path) TheJSONB_REMOVEfunction.DSL.jsonbReplace(Field<JSONB> field, String path, Object value) TheJSONB_REPLACEfunction.DSL.jsonbReplace(Field<JSONB> field, String path, Field<?> value) TheJSONB_REPLACEfunction.TheJSONB_REPLACEfunction.TheJSONB_REPLACEfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.TheJSONB_SETfunction.static @NotNull JSONTableColumnsFirstStepDSL.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
Fieldarguments in this method is inconsistent with that of other overloads, such asDSL.jsonbObject(Field, Field), which can lead to subtle bugs.