Uses of Interface
org.jooq.Result

Packages that use Result

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API.
org.jooq.impl	The org.jooq.impl package contains jOOQ's implementation classes.
org.jooq.tools.jdbc	The org.jooq.tools.jdbc package contains compatibility classes to bridge between JDBC 4.0 and JDBC 4.1.
org.jooq.util.h2	The org.jooq.util.ase package contains classes related to the SQLDialect.H2 dialect.
org.jooq.util.hsqldb	The org.jooq.util.ase package contains classes related to the SQLDialect.HSQLDB dialect.
org.jooq.util.oracle	The org.jooq.util.ase package contains classes related to the SQLDialect.ORACLE dialect.
org.jooq.util.postgres	The org.jooq.util.ase package contains classes related to the SQLDialect.POSTGRES dialect.

Uses of Result in org.jooq

Methods in org.jooq that return Result

Modifier and Type	Method and Description
Result<R>	UpdateResultStep.fetch() The result holding returned values as specified by the UpdateReturningStep This currently only works well for DB2, HSQLDB, MySQL, and Postgres
Result<R>	ResultQuery.fetch() Execute the query and return the generated result.
Result<R>	InsertResultStep.fetch() The result holding returned values as specified by the InsertReturningStep This currently only works well for DB2, HSQLDB, MySQL, and Postgres
Result<R>	Cursor.fetch() Fetch all remaining records as a result.
Result<R>	Cursor.fetch(int number) Fetch the next couple of records from the cursor.
<R extends Record> Result<R>	DSLContext.fetch(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return results.
Result<Record>	DSLContext.fetch(ResultSet rs) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Result<Record>	DSLContext.fetch(ResultSet rs, Class<?>... types) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Result<Record>	DSLContext.fetch(ResultSet rs, DataType<?>... types) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Result<Record>	DSLContext.fetch(ResultSet rs, Field<?>... fields) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Result<Record>	DSLContext.fetch(String sql) Execute a new query holding plain SQL.
Result<Record>	DSLContext.fetch(String sql, Object... bindings) Execute a new query holding plain SQL.
Result<Record>	DSLContext.fetch(String sql, QueryPart... parts) Execute a new query holding plain SQL.
<R extends Record> Result<R>	DSLContext.fetch(Table<R> table) Execute and return all records for SELECT * FROM [table].
<R extends Record> Result<R>	DSLContext.fetch(Table<R> table, Condition condition) Execute and return all records for SELECT * FROM [table] WHERE [condition] .
Result<R>	ForeignKey.fetchChildren(Collection<? extends O> records) Fetch child records of a given set of records through this foreign key This returns childs record referencing any record in a given set of records through this foreign key
<O extends TableRecord<O>> Result<O>	UpdatableRecord.fetchChildren(ForeignKey<O,R> key) Fetch child records of this record, given a foreign key This returns childs record referencing this record through a given foreign key.
Result<R>	ForeignKey.fetchChildren(O... records) Fetch child records of a given set of records through this foreign key This returns childs record referencing any record in a given set of records through this foreign key
Result<R>	ForeignKey.fetchChildren(O record) Fetch child records of a given record through this foreign key This returns childs record referencing a given record through this foreign key
Result<Record>	DSLContext.fetchFromCSV(String string) Fetch all data from a CSV string.
Result<Record>	DSLContext.fetchFromCSV(String string, char delimiter) Fetch all data from a CSV string.
Result<Record>	DSLContext.fetchFromJSON(String string) Fetch all data from a JSON string.
Result<Record>	DSLContext.fetchFromStringData(List<String[]> data) Fetch all data from a list of strings.
Result<Record>	DSLContext.fetchFromStringData(String[]... data) Fetch all data from a list of strings.
Result<Record>	DSLContext.fetchFromTXT(String string) Fetch all data from a formatted string.
Result<Record>	DSLContext.fetchFromTXT(String string, String nullLiteral) Fetch all data from a formatted string.
<Z extends Record> Result<Z>	ResultQuery.fetchInto(Table<Z> table) Map resulting records onto a custom record.
<Z extends Record> Result<Z>	Cursor.fetchInto(Table<Z> table) Map resulting records onto a custom record.
Result<O>	ForeignKey.fetchParents(Collection<? extends R> records) Fetch parent records of a given set of record through this foreign key This returns parent records referenced by any record in a given set of records through this foreign key.
Result<O>	ForeignKey.fetchParents(R... records) Fetch parent records of a given set of record through this foreign key This returns parent records referenced by any record in a given set of records through this foreign key.
Result<R>	ResultQuery.getResult() Return the result generated by a previous call to execute().
Result<R>	UpdateQuery.getReturnedRecords() The records holding returned values as specified by any of the StoreQuery.setReturning() methods.
Result<R>	StoreQuery.getReturnedRecords() The records holding returned values as specified by any of the StoreQuery.setReturning() methods.
Result<R>	InsertQuery.getReturnedRecords() The records holding returned values as specified by any of the StoreQuery.setReturning() methods.
Result<R>	Result.intern(Field<?>... fields) Specify a set of fields whose values should be interned.
Result<R>	Result.intern(int... fieldIndexes) Specify a set of field indexes whose values should be interned.
Result<R>	Result.intern(String... fieldNames) Specify a set of field names whose values should be interned.
<Z extends Record> Result<Z>	Result.into(Table<Z> table) Map resulting records onto a custom record.
<R extends Record> Result<R>	DSLContext.newResult(Table<R> table) Create a new empty Result.
Result<?>	ExecuteContext.result() The last result that was fetched from the result set, or null if no result has been fetched.
Result<R>	Result.sortAsc(Comparator<? super R> comparator) Sort this result using a comparator that can compare records.
<T extends Comparable<? super T>> Result<R>	Result.sortAsc(Field<T> field) Sort this result by one of its contained fields.
<T> Result<R>	Result.sortAsc(Field<T> field, Comparator<? super T> comparator) Sort this result by one of its contained fields using a comparator.
Result<R>	Result.sortAsc(int fieldIndex) Sort this result by one of its contained fields.
Result<R>	Result.sortAsc(int fieldIndex, Comparator<?> comparator) Sort this result by one of its contained fields using a comparator.
Result<R>	Result.sortAsc(String fieldName) Sort this result by one of its contained fields.
Result<R>	Result.sortAsc(String fieldName, Comparator<?> comparator) Sort this result by one of its contained fields using a comparator.
Result<R>	Result.sortDesc(Comparator<? super R> comparator) Reverse-sort this result using a comparator that can compare records.
<T extends Comparable<? super T>> Result<R>	Result.sortDesc(Field<T> field) Reverse-sort this result by one of its contained fields.
<T> Result<R>	Result.sortDesc(Field<T> field, Comparator<? super T> comparator) Reverse-sort this result by one of its contained fields using a comparator.
Result<R>	Result.sortDesc(int fieldIndex) Reverse-sort this result by one of its contained fields.
Result<R>	Result.sortDesc(int fieldIndex, Comparator<?> comparator) Reverse-sort this result by one of its contained fields using a comparator.
Result<R>	Result.sortDesc(String fieldName) Reverse-sort this result by one of its contained fields.
Result<R>	Result.sortDesc(String fieldName, Comparator<?> comparator) Reverse-sort this result by one of its contained fields using a comparator.

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

Modifier and Type	Method and Description
Map<Record,Result<R>>	ResultQuery.fetchGroups(Field<?>[] keys) Execute the query and return a Map with the result grouped by the given keys.
<K> Map<K,Result<R>>	ResultQuery.fetchGroups(Field<K> key) Execute the query and return a Map with one of the result's columns as key and a list of corresponding records as value.
List<Result<Record>>	ResultQuery.fetchMany() Execute a query, possibly returning several result sets.
<R extends Record> List<Result<Record>>	DSLContext.fetchMany(ResultQuery<R> query) Execute a ResultQuery in the context of this DSLContext and return a cursor.
List<Result<Record>>	DSLContext.fetchMany(String sql) Execute a new query holding plain SQL, possibly returning several result sets.
List<Result<Record>>	DSLContext.fetchMany(String sql, Object... bindings) Execute a new query holding plain SQL, possibly returning several result sets.
List<Result<Record>>	DSLContext.fetchMany(String sql, QueryPart... parts) Execute a new query holding plain SQL, possibly returning several result sets.
Map<Record,Result<R>>	Result.intoGroups(Field<?>[] keys) Return a Map with the result grouped by the given keys.
<K> Map<K,Result<R>>	Result.intoGroups(Field<K> key) Return a Map with one of the result's columns as key and a list of corresponding records as value.

Methods in org.jooq with parameters of type Result

Modifier and Type	Method and Description
void	ExecuteContext.result(Result<?> result) Calling this has no effect.

Uses of Result in org.jooq.impl

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

Modifier and Type	Field and Description
static DataType<Result<Record>>	SQLDataType.RESULT The ResultSet type.

Methods in org.jooq.impl that return Result

Modifier and Type	Method and Description
<R extends Record> Result<R>	DefaultDSLContext.fetch(ResultQuery<R> query)
Result<Record>	DefaultDSLContext.fetch(ResultSet rs)
Result<Record>	DefaultDSLContext.fetch(ResultSet rs, Class<?>... types)
Result<Record>	DefaultDSLContext.fetch(ResultSet rs, DataType<?>... types)
Result<Record>	DefaultDSLContext.fetch(ResultSet rs, Field<?>... fields)
Result<Record>	DefaultDSLContext.fetch(String sql)
Result<Record>	DefaultDSLContext.fetch(String sql, Object... bindings)
Result<Record>	DefaultDSLContext.fetch(String sql, QueryPart... parts)
<R extends Record> Result<R>	DefaultDSLContext.fetch(Table<R> table)
<R extends Record> Result<R>	DefaultDSLContext.fetch(Table<R> table, Condition condition)
<O extends TableRecord<O>> Result<O>	UpdatableRecordImpl.fetchChildren(ForeignKey<O,R> key)
Result<Record>	DefaultDSLContext.fetchFromCSV(String string)
Result<Record>	DefaultDSLContext.fetchFromCSV(String string, char delimiter)
Result<Record>	DefaultDSLContext.fetchFromJSON(String string)
Result<Record>	DefaultDSLContext.fetchFromStringData(List<String[]> data)
Result<Record>	DefaultDSLContext.fetchFromStringData(String[]... data)
Result<Record>	DefaultDSLContext.fetchFromTXT(String string)
Result<Record>	DefaultDSLContext.fetchFromTXT(String string, String nullLiteral)
<R extends Record> Result<R>	DefaultDSLContext.newResult(Table<R> table)

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

Modifier and Type	Method and Description
<R extends Record> List<Result<Record>>	DefaultDSLContext.fetchMany(ResultQuery<R> query)
List<Result<Record>>	DefaultDSLContext.fetchMany(String sql)
List<Result<Record>>	DefaultDSLContext.fetchMany(String sql, Object... bindings)
List<Result<Record>>	DefaultDSLContext.fetchMany(String sql, QueryPart... parts)

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

Modifier and Type	Method and Description
static <R extends Record> Table<R>	DSL.table(Result<R> result) Use a previously obtained result as a new Table that can be used in SQL statements through DSL.values(RowN...).

Uses of Result in org.jooq.tools.jdbc

Fields in org.jooq.tools.jdbc declared as Result

Modifier and Type	Field and Description
Result<?>	MockResult.data The result data associated with this execution result.

Constructors in org.jooq.tools.jdbc with parameters of type Result

Constructor and Description
MockResult(int rows, Result<?> data) Create a new MockResult.
MockResultSet(Result<?> result)
MockResultSet(Result<?> result, int maxRows)

Uses of Result in org.jooq.util.h2

Fields in org.jooq.util.h2 with type parameters of type Result

Modifier and Type	Field and Description
protected static DataType<Result<Record>>	H2DataType.__RESULT

Uses of Result in org.jooq.util.hsqldb

Fields in org.jooq.util.hsqldb with type parameters of type Result

Modifier and Type	Field and Description
static DataType<Result<Record>>	HSQLDBDataType.ROW

Uses of Result in org.jooq.util.oracle

Fields in org.jooq.util.oracle with type parameters of type Result

Modifier and Type	Field and Description
static DataType<Result<Record>>	OracleDataType.REF_CURSOR

Uses of Result in org.jooq.util.postgres

Fields in org.jooq.util.postgres with type parameters of type Result

Modifier and Type	Field and Description
static DataType<Result<Record>>	PostgresDataType.REFCURSOR