Uses of Interface
org.jooq.Record

Packages that use Record

Package	Description
org.jooq	The org.jooq package contains jOOQ's public API This package mostly contains interfaces that are implemented by the org.jooq.impl package.
org.jooq.impl	The org.jooq.impl package contains jOOQ's implementation classes This package provides implementations for the jOOQ API from org.jooq, whose interfaces are constructed mostly through the Factory class, which hides implementation facts from the public API
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.MYSQL dialect
org.jooq.util.postgres	The org.jooq.util.ase package contains classes related to the SQLDialect.POSTGRES dialect

Uses of Record in org.jooq

Classes in org.jooq with type parameters of type Record

Modifier and Type	Interface and Description
interface	Cursor<R extends Record> Cursors allow for lazy, sequential access to an underlying JDBC ResultSet.
interface	Delete<R extends Record> A Query that can delete data in the database.
interface	DeleteConditionStep<R extends Record> This type is used for the Delete's DSL API.
interface	DeleteFinalStep<R extends Record> This type is used for the Delete's DSL API.
interface	DeleteQuery<R extends Record> A query used for deletion of data
interface	DeleteWhereStep<R extends Record> This type is used for the Delete's DSL API.
interface	ForeignKey<R extends Record,U extends Record> A ForeignKey is an object referencing a UniqueKey.
interface	ForeignKey<R extends Record,U extends Record> A ForeignKey is an object referencing a UniqueKey.
interface	FutureResult<R extends Record> Fetch results asynchronously.
interface	Identity<R extends Record,T> An Identity is an object representing an IDENTITY column as understood by the SQL:2003 standard.
interface	Insert<R extends Record> A Query that can insert data in the database.
interface	InsertFinalStep<R extends Record> This type is used for the Insert's DSL API.
interface	InsertOnDuplicateSetMoreStep<R extends Record> This type is used for the Insert's DSL API.
interface	InsertOnDuplicateSetStep<R extends Record> This type is used for the Insert's DSL API.
interface	InsertOnDuplicateStep<R extends Record> This type is used for the Insert's DSL API.
interface	InsertQuery<R extends Record> A query for data insertion
interface	InsertResultStep<R extends Record> This type is used for the Insert's DSL API.
interface	InsertReturningStep<R extends Record> This type is used for the Insert's DSL API.
interface	InsertSetMoreStep<R extends Record> This type is used for the Insert's alternative DSL API.
interface	InsertSetStep<R extends Record> This type is used for the Insert's alternative DSL API.
interface	InsertValuesStep<R extends Record> This type is used for the Insert's DSL API.
interface	Key<R extends Record> A Key is an object representing a UNIQUE KEY, a PRIMARY KEY, or a FOREIGN KEY.
interface	Merge<R extends Record> A Query that can merge data in the database.
interface	MergeFinalStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeKeyStep<R extends Record> This type is used for the H2-specific variant of the Merge's DSL API.
interface	MergeMatchedDeleteStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeMatchedSetMoreStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeMatchedSetStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeMatchedStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeMatchedWhereStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeNotMatchedSetMoreStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeNotMatchedSetStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeNotMatchedStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeNotMatchedValuesStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeNotMatchedWhereStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeOnConditionStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeOnStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeUsingStep<R extends Record> This type is used for the Merge's DSL API.
interface	MergeValuesStep<R extends Record> This type is used for the H2-specific variant of the Merge's DSL API.
interface	RecordHandler<R extends Record> A RecordHandler is a handler that can receive Record objects, when fetching data from the database.
interface	RecordMapper<R extends Record,E> A RecordMapper is a mapper that can receive Record objects, when fetching data from the database, transforming them into a custom type <E>
interface	Result<R extends Record> A wrapper for database results returned by SelectQuery
interface	ResultQuery<R extends Record> A query that can return results.
interface	Select<R extends Record> A Query that can provide a Result after execution
interface	SimpleSelectConditionStep<R extends Record> This type is used for the Select's DSL API when selecting specific Record types.
interface	SimpleSelectFinalStep<R extends Record> This type is used for the Select's DSL API when selecting specific Record types.
interface	SimpleSelectForUpdateOfStep<R extends Record> This type is used for the Select's DSL API when selecting specific Record types.
interface	SimpleSelectForUpdateStep<R extends Record> This type is used for the Select's DSL API when selecting specific Record types.
interface	SimpleSelectForUpdateWaitStep<R extends Record> This type is used for the Select's DSL API when selecting specific Record types.
interface	SimpleSelectLimitStep<R extends Record> This type is used for the Select's DSL API when selecting specific Record types.
interface	SimpleSelectOffsetStep<R extends Record> This type is used for the Select's DSL API when selecting specific Record types.
interface	SimpleSelectOrderByStep<R extends Record> This type is used for the Select's DSL API when selecting specific Record types.
interface	SimpleSelectQuery<R extends Record> A simple select query that provides Records from a single table, with no joins allowed.
interface	SimpleSelectWhereStep<R extends Record> This type is used for the Select's DSL API when selecting specific Record types.
interface	StoreQuery<R extends Record> A query storing objects to the database.
interface	Table<R extends Record> A table to be used in queries
interface	TableField<R extends Record,T> A field contained in a table
interface	TableLike<R extends Record> An object that can behave like a table (a table-like object)
interface	Truncate<R extends Record> A Query that can truncate a table in the database.
interface	Type<R extends Record> Deprecated. - 2.5.0 [#1579] - The org.jooq.TypeTable and UDT with a single interface
interface	UniqueKey<R extends Record> A UniqueKey is an object representing a UNIQUE KEY or a PRIMARY KEY.
interface	Updatable<R extends Record> A common interface for objects (tables, records) that can be updated or deleted using their primary keys.
interface	UpdatableTable<R extends Record> A common interface for tables whose records can be stored back to the database again.
interface	Update<R extends Record> A Query that can update data in the database.
interface	UpdateConditionStep<R extends Record> This type is used for the Update's DSL API.
interface	UpdateFinalStep<R extends Record> This type is used for the Update's DSL API.
interface	UpdateQuery<R extends Record> A query for data updating
interface	UpdateSetMoreStep<R extends Record> This type is used for the Update's DSL API.
interface	UpdateSetStep<R extends Record> This type is used for the Update's DSL API.
interface	UpdateWhereStep<R extends Record> This type is used for the Update's DSL API.

Subinterfaces of Record in org.jooq

Modifier and Type	Interface and Description
interface	TableRecord<R extends TableRecord<R>> A record originating from a single table
interface	UDTRecord<R extends UDTRecord<R>> An object holding data of a UDT
interface	UpdatableRecord<R extends UpdatableRecord<R>> A common interface for records that can be stored back to the database again.

Methods in org.jooq with type parameters of type Record

Modifier and Type	Method and Description
<R extends Record> DeleteWhereStep<R>	FactoryOperations.delete(Table<R> table) Create a new DSL delete statement.
<R extends Record> DeleteQuery<R>	FactoryOperations.deleteQuery(Table<R> table) Create a new DeleteQuery
<R extends Record> Result<R>	FactoryOperations.fetch(Table<R> table) Execute and return all records for SELECT * FROM [table] The result and its contained records are attached to this Configuration by default.
<R extends Record> Result<R>	FactoryOperations.fetch(Table<R> table, Condition condition) Execute and return all records for SELECT * FROM [table] WHERE [condition] The result and its contained records are attached to this Configuration by default.
<R extends Record> R	FactoryOperations.fetchAny(Table<R> table) Execute and return zero or one record for SELECT * FROM [table] LIMIT 1 The resulting record is attached to this Configuration by default.
<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.
<R extends Record> R	FactoryOperations.fetchOne(Table<R> table) Execute and return zero or one record for SELECT * FROM [table] The resulting record is attached to this Configuration by default.
<R extends Record> R	FactoryOperations.fetchOne(Table<R> table, Condition condition) Execute and return zero or one record for SELECT * FROM [table] WHERE [condition] The resulting record is attached to this Configuration by default.
<Z extends Record> Z	Cursor.fetchOneInto(Table<Z> table) Map the next resulting record onto a custom record.
<O extends Record> List<ForeignKey<O,R>>	UpdatableTable.getReferencesFrom(Table<O> other) Get a list of FOREIGN KEY's of a specific table, referencing a this table.
<O extends Record> List<ForeignKey<R,O>>	Table.getReferencesTo(Table<O> other) Get a list of FOREIGN KEY's of this table, referencing a specific table.
<R extends Record> InsertSetStep<R>	FactoryOperations.insertInto(Table<R> into) Create a new DSL insert statement.
<R extends Record> InsertValuesStep<R>	FactoryOperations.insertInto(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.
<R extends Record> InsertValuesStep<R>	FactoryOperations.insertInto(Table<R> into, Field<?>... fields) Create a new DSL insert statement.
<R extends Record> Insert<R>	FactoryOperations.insertInto(Table<R> into, Select<?> select) Deprecated. - 2.0.3 - Use any of these methods instead: FactoryOperations.insertInto(Table) and InsertSetStep.select(Select) FactoryOperations.insertInto(Table, Field...) and InsertValuesStep.select(Select) FactoryOperations.insertInto(Table, Collection) and InsertValuesStep.select(Select)
<R extends Record> InsertQuery<R>	FactoryOperations.insertQuery(Table<R> into) Create a new InsertQuery
<R extends Record> R	Record.into(Table<R> table) Map resulting records onto a custom record type.
<Z extends Record> Result<Z>	Result.into(Table<Z> table) Map resulting records onto a custom record.
<R extends Record> MergeUsingStep<R>	FactoryOperations.mergeInto(Table<R> table) Create a new DSL SQL standard MERGE statement.
<R extends Record> MergeKeyStep<R>	FactoryOperations.mergeInto(Table<R> table, Collection<? extends Field<?>> fields) Create a new DSL merge statement (H2-specific syntax)
<R extends Record> MergeKeyStep<R>	FactoryOperations.mergeInto(Table<R> table, Field<?>... fields) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record> SimpleSelectWhereStep<R>	FactoryOperations.selectFrom(Table<R> table) Create a new DSL select statement Example: SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
<R extends Record> SimpleSelectQuery<R>	FactoryOperations.selectQuery(TableLike<R> table) Create a new SelectQuery
<R extends Record> Truncate<R>	FactoryOperations.truncate(Table<R> table) Create a new DSL truncate statement.
<R extends Record> UpdateSetStep<R>	FactoryOperations.update(Table<R> table) Create a new DSL update statement.
<R extends Record> UpdateQuery<R>	FactoryOperations.updateQuery(Table<R> table) Create a new UpdateQuery

Methods in org.jooq that return Record

Modifier and Type	Method and Description
Record	FactoryOperations.fetchOne(String sql) Execute a new query holding plain SQL.
Record	FactoryOperations.fetchOne(String sql, Object... bindings) Execute a new query holding plain SQL.
Record	FactoryOperations.fetchOne(String sql, QueryPart... parts) Execute a new query holding plain SQL.
Record	Record.original() Get this record containing the original values as fetched from the database.
Record	ExecuteContext.record() The last record that was fetched from the result set, or null if no record has been fetched.

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

Modifier and Type	Method and Description
Table<Record>	Table.crossJoin(String sql) CROSS JOIN a table to this table.
Table<Record>	Table.crossJoin(String sql, Object... bindings) CROSS JOIN a table to this table.
Table<Record>	Table.crossJoin(String sql, QueryPart... parts) CROSS JOIN a table to this table.
Table<Record>	Table.crossJoin(TableLike<?> table) CROSS JOIN a table to this table.
Result<Record>	FactoryOperations.fetch(ResultSet rs) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Result<Record>	FactoryOperations.fetch(String sql) Execute a new query holding plain SQL.
Result<Record>	FactoryOperations.fetch(String sql, Object... bindings) Execute a new query holding plain SQL.
Result<Record>	FactoryOperations.fetch(String sql, QueryPart... parts) Execute a new query holding plain SQL.
Result<Record>	FactoryOperations.fetchFromCSV(String string) Fetch all data from a CSV string.
Result<Record>	FactoryOperations.fetchFromCSV(String string, char delimiter) Fetch all data from a CSV string.
Map<Record,Result<R>>	ResultQuery.fetchGroups(Field<?>[] keys) Execute the query and return a Map with the result grouped by the given keys.
<E> Map<Record,List<E>>	ResultQuery.fetchGroups(Field<?>[] keys, Class<? extends E> type) Execute the query and return a Map with results grouped by the given keys and mapped into the given entity type.
Cursor<Record>	FactoryOperations.fetchLazy(ResultSet rs) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Cursor<Record>	FactoryOperations.fetchLazy(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.
Cursor<Record>	FactoryOperations.fetchLazy(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.
Cursor<Record>	FactoryOperations.fetchLazy(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.
List<Result<Record>>	ResultQuery.fetchMany() Execute a query, possibly returning several result sets.
List<Result<Record>>	FactoryOperations.fetchMany(String sql) Execute a new query holding plain SQL, possibly returning several result sets Example (Sybase ASE): String sql = "sp_help 'my_table'"; NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
List<Result<Record>>	FactoryOperations.fetchMany(String sql, Object... bindings) Execute a new query holding plain SQL, possibly returning several result sets.
List<Result<Record>>	FactoryOperations.fetchMany(String sql, QueryPart... parts) Execute a new query holding plain SQL, possibly returning several result sets.
Map<Record,R>	ResultQuery.fetchMap(Field<?>[] keys) Execute the query and return a Map with keys as a map key and the corresponding record as value.
Table<Record>	PivotInStep.in(Collection<? extends Field<T>> fields) Specify the acceptable values for pivoting This clause is generally only supported by SQLDialect.ORACLE.
Table<Record>	PivotInStep.in(Field<?>... fields) Specify the acceptable values for pivoting This clause is generally only supported by SQLDialect.ORACLE.
Table<Record>	PivotInStep.in(T... values) Specify the acceptable values for pivoting
Map<Record,Result<R>>	Result.intoGroups(Field<?>[] keys) Return a Map with the result grouped by the given keys.
<E> Map<Record,List<E>>	Result.intoGroups(Field<?>[] keys, Class<? extends E> type) Return a Map with results grouped by the given keys and mapped into the given entity type.
Map<Record,R>	Result.intoMap(Field<?>[] keys) Return a Map with the given keys as a map key and the corresponding record as value.
Table<Record>	Table.naturalJoin(String sql) NATURAL JOIN a table to this table.
Table<Record>	Table.naturalJoin(String sql, Object... bindings) NATURAL JOIN a table to this table.
Table<Record>	Table.naturalJoin(String sql, QueryPart... parts) NATURAL JOIN a table to this table.
Table<Record>	Table.naturalJoin(TableLike<?> table) NATURAL JOIN a table to this table.
Table<Record>	Table.naturalLeftOuterJoin(String sql) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	Table.naturalLeftOuterJoin(String sql, Object... bindings) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	Table.naturalLeftOuterJoin(String sql, QueryPart... parts) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	Table.naturalLeftOuterJoin(TableLike<?> table) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	Table.naturalRightOuterJoin(String sql) NATURAL RIGHT OUTER JOIN a table to this table.
Table<Record>	Table.naturalRightOuterJoin(String sql, Object... bindings) NATURAL RIGHT OUTER JOIN a table to this table.
Table<Record>	Table.naturalRightOuterJoin(String sql, QueryPart... parts) NATURAL RIGHT OUTER JOIN a table to this table.
Table<Record>	Table.naturalRightOuterJoin(TableLike<?> table) NATURAL RIGHT OUTER JOIN a table to this table.
ResultQuery<Record>	FactoryOperations.resultQuery(String sql) Create a new query holding plain SQL.
ResultQuery<Record>	FactoryOperations.resultQuery(String sql, Object... bindings) Create a new query holding plain SQL.
ResultQuery<Record>	FactoryOperations.resultQuery(String sql, QueryPart... parts) Create a new query holding plain SQL.
Table<Record>	DivideByReturningStep.returning(Collection<? extends Field<?>> fields) Specify the fields that you want the division to return from the dividend
Table<Record>	DivideByReturningStep.returning(Field<?>... fields) Specify the fields that you want the division to return from the dividend
Table<Record>	TableOnStep.using(Collection<? extends Field<?>> fields) Join the table with the USING(column [, column...])
Table<Record>	TableOnStep.using(Field<?>... fields) Join the table with the USING(column [, column...])

Methods in org.jooq with parameters of type Record

Modifier and Type	Method and Description
void	ExecuteContext.record(Record record) Calling this has no effect.

Method parameters in org.jooq with type arguments of type Record

Modifier and Type	Method and Description
<E> E	Record.map(RecordMapper<Record,E> mapper) Map this record into a custom mapper callback

Uses of Record in org.jooq.impl

Classes in org.jooq.impl with type parameters of type Record

Modifier and Type	Class and Description
class	TableImpl<R extends Record> A common base type for tables This type is for JOOQ INTERNAL USE only.
class	UpdatableTableImpl<R extends Record> A table implementation for a table holding a primary key This type is for JOOQ INTERNAL USE only.

Classes in org.jooq.impl that implement Record

Modifier and Type	Class and Description
class	CustomRecord<R extends TableRecord<R>> A base class for custom TableRecord implementations in client code.
class	TableRecordImpl<R extends TableRecord<R>> A record implementation for a record originating from a single table This type is for JOOQ INTERNAL USE only.
class	UDTRecordImpl<R extends UDTRecord<R>> A record implementation for a record originating from a single UDT This type is for JOOQ INTERNAL USE only.
class	UpdatableRecordImpl<R extends UpdatableRecord<R>> A record implementation for a record holding a primary key This type is for JOOQ INTERNAL USE only.

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

Modifier and Type	Field and Description
static SQLDataType<Result<Record>>	SQLDataType.RESULT The ResultSet type This is not a SQL or JDBC standard.

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

Modifier and Type	Method and Description
protected static <R extends Record,U extends Record> ForeignKey<R,U>	AbstractKeys.createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields) Factory method for foreign keys
protected static <R extends Record,U extends Record> ForeignKey<R,U>	AbstractKeys.createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields) Factory method for foreign keys
protected static <R extends Record,T> Identity<R,T>	AbstractKeys.createIdentity(Table<R> table, TableField<R,T> field) Factory method for identities
protected static <R extends Record> UniqueKey<R>	AbstractKeys.createUniqueKey(Table<R> table, TableField<R,?>... fields) Factory method for unique keys
<R extends Record> DeleteWhereStep<R>	FactoryProxy.delete(Table<R> table) Deprecated.
<R extends Record> DeleteWhereStep<R>	Factory.delete(Table<R> table) Create a new DSL delete statement.
<R extends Record> DeleteQuery<R>	FactoryProxy.deleteQuery(Table<R> table) Deprecated.
<R extends Record> DeleteQuery<R>	Factory.deleteQuery(Table<R> table) Create a new DeleteQuery
<R extends Record> Result<R>	FactoryProxy.fetch(Table<R> table) Deprecated.
<R extends Record> Result<R>	Factory.fetch(Table<R> table) Execute and return all records for SELECT * FROM [table] The result and its contained records are attached to this Configuration by default.
<R extends Record> Result<R>	FactoryProxy.fetch(Table<R> table, Condition condition) Deprecated.
<R extends Record> Result<R>	Factory.fetch(Table<R> table, Condition condition) Execute and return all records for SELECT * FROM [table] WHERE [condition] The result and its contained records are attached to this Configuration by default.
<R extends Record> R	FactoryProxy.fetchAny(Table<R> table) Deprecated.
<R extends Record> R	Factory.fetchAny(Table<R> table) Execute and return zero or one record for SELECT * FROM [table] LIMIT 1 The resulting record is attached to this Configuration by default.
<R extends Record> R	FactoryProxy.fetchOne(Table<R> table) Deprecated.
<R extends Record> R	Factory.fetchOne(Table<R> table) Execute and return zero or one record for SELECT * FROM [table] The resulting record is attached to this Configuration by default.
<R extends Record> R	FactoryProxy.fetchOne(Table<R> table, Condition condition) Deprecated.
<R extends Record> R	Factory.fetchOne(Table<R> table, Condition condition) Execute and return zero or one record for SELECT * FROM [table] WHERE [condition] The resulting record is attached to this Configuration by default.
<O extends Record> List<ForeignKey<O,R>>	UpdatableTableImpl.getReferencesFrom(Table<O> other)
<R extends Record> InsertSetStep<R>	FactoryProxy.insertInto(Table<R> into) Deprecated.
<R extends Record> InsertSetStep<R>	Factory.insertInto(Table<R> into) Create a new DSL insert statement.
<R extends Record> InsertValuesStep<R>	FactoryProxy.insertInto(Table<R> into, Collection<? extends Field<?>> fields) Deprecated.
<R extends Record> InsertValuesStep<R>	Factory.insertInto(Table<R> into, Collection<? extends Field<?>> fields) Create a new DSL insert statement.
<R extends Record> InsertValuesStep<R>	FactoryProxy.insertInto(Table<R> into, Field<?>... fields) Deprecated.
<R extends Record> InsertValuesStep<R>	Factory.insertInto(Table<R> into, Field<?>... fields) Create a new DSL insert statement.
<R extends Record> Insert<R>	FactoryProxy.insertInto(Table<R> into, Select<?> select) Deprecated.
<R extends Record> Insert<R>	Factory.insertInto(Table<R> into, Select<?> select) Deprecated.
<R extends Record> InsertQuery<R>	FactoryProxy.insertQuery(Table<R> into) Deprecated.
<R extends Record> InsertQuery<R>	Factory.insertQuery(Table<R> into) Create a new InsertQuery
<R extends Record> MergeUsingStep<R>	FactoryProxy.mergeInto(Table<R> table) Deprecated.
<R extends Record> MergeUsingStep<R>	Factory.mergeInto(Table<R> table) Create a new DSL SQL standard MERGE statement.
<R extends Record> MergeKeyStep<R>	FactoryProxy.mergeInto(Table<R> table, Collection<? extends Field<?>> fields) Deprecated.
<R extends Record> MergeKeyStep<R>	Factory.mergeInto(Table<R> table, Collection<? extends Field<?>> fields) Create a new DSL merge statement (H2-specific syntax)
<R extends Record> MergeKeyStep<R>	FactoryProxy.mergeInto(Table<R> table, Field<?>... fields) Deprecated.
<R extends Record> MergeKeyStep<R>	Factory.mergeInto(Table<R> table, Field<?>... fields) Create a new DSL merge statement (H2-specific syntax) This statement is available from DSL syntax only.
<R extends Record> SimpleSelectWhereStep<R>	FactoryProxy.selectFrom(Table<R> table) Deprecated.
<R extends Record> SimpleSelectWhereStep<R>	Factory.selectFrom(Table<R> table) Create a new DSL select statement Example: SELECT * FROM [table] WHERE [conditions] ORDER BY [ordering] LIMIT [limit clause]
<R extends Record> SimpleSelectQuery<R>	FactoryProxy.selectQuery(TableLike<R> table) Deprecated.
<R extends Record> SimpleSelectQuery<R>	Factory.selectQuery(TableLike<R> table) Create a new SelectQuery
static <R extends Record> Table<R>	Factory.table(Select<R> select) A synonym for TableLike.asTable().
<R extends Record> Truncate<R>	FactoryProxy.truncate(Table<R> table) Deprecated.
<R extends Record> Truncate<R>	Factory.truncate(Table<R> table) Create a new DSL truncate statement.
<R extends Record> UpdateSetStep<R>	FactoryProxy.update(Table<R> table) Deprecated.
<R extends Record> UpdateSetStep<R>	Factory.update(Table<R> table) Create a new DSL update statement.
<R extends Record> UpdateQuery<R>	FactoryProxy.updateQuery(Table<R> table) Deprecated.
<R extends Record> UpdateQuery<R>	Factory.updateQuery(Table<R> table) Create a new UpdateQuery

Methods in org.jooq.impl that return Record

Modifier and Type	Method and Description
Record	FactoryProxy.fetchOne(String sql) Deprecated.
Record	Factory.fetchOne(String sql) Execute a new query holding plain SQL.
Record	FactoryProxy.fetchOne(String sql, Object... bindings) Deprecated.
Record	Factory.fetchOne(String sql, Object... bindings) Execute a new query holding plain SQL.
Record	FactoryProxy.fetchOne(String sql, QueryPart... parts) Deprecated.
Record	Factory.fetchOne(String sql, QueryPart... parts) Execute a new query holding plain SQL.

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

Modifier and Type	Method and Description
Result<Record>	FactoryProxy.fetch(ResultSet rs) Deprecated.
Result<Record>	Factory.fetch(ResultSet rs) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Result<Record>	FactoryProxy.fetch(String sql) Deprecated.
Result<Record>	Factory.fetch(String sql) Execute a new query holding plain SQL.
Result<Record>	FactoryProxy.fetch(String sql, Object... bindings) Deprecated.
Result<Record>	Factory.fetch(String sql, Object... bindings) Execute a new query holding plain SQL.
Result<Record>	FactoryProxy.fetch(String sql, QueryPart... parts) Deprecated.
Result<Record>	Factory.fetch(String sql, QueryPart... parts) Execute a new query holding plain SQL.
Result<Record>	FactoryProxy.fetchFromCSV(String string) Deprecated.
Result<Record>	Factory.fetchFromCSV(String string) Fetch all data from a CSV string.
Result<Record>	FactoryProxy.fetchFromCSV(String string, char delimiter) Deprecated.
Result<Record>	Factory.fetchFromCSV(String string, char delimiter) Fetch all data from a CSV string.
Cursor<Record>	FactoryProxy.fetchLazy(ResultSet rs) Deprecated.
Cursor<Record>	Factory.fetchLazy(ResultSet rs) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
Cursor<Record>	FactoryProxy.fetchLazy(String sql) Deprecated.
Cursor<Record>	Factory.fetchLazy(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.
Cursor<Record>	FactoryProxy.fetchLazy(String sql, Object... bindings) Deprecated.
Cursor<Record>	Factory.fetchLazy(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.
Cursor<Record>	FactoryProxy.fetchLazy(String sql, QueryPart... parts) Deprecated.
Cursor<Record>	Factory.fetchLazy(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.
List<Result<Record>>	FactoryProxy.fetchMany(String sql) Deprecated.
List<Result<Record>>	Factory.fetchMany(String sql) Execute a new query holding plain SQL, possibly returning several result sets Example (Sybase ASE): String sql = "sp_help 'my_table'"; NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
List<Result<Record>>	FactoryProxy.fetchMany(String sql, Object... bindings) Deprecated.
List<Result<Record>>	Factory.fetchMany(String sql, Object... bindings) Execute a new query holding plain SQL, possibly returning several result sets.
List<Result<Record>>	FactoryProxy.fetchMany(String sql, QueryPart... parts) Deprecated.
List<Result<Record>>	Factory.fetchMany(String sql, QueryPart... parts) Execute a new query holding plain SQL, possibly returning several result sets.
ResultQuery<Record>	FactoryProxy.resultQuery(String sql) Deprecated.
ResultQuery<Record>	Factory.resultQuery(String sql) Create a new query holding plain SQL.
ResultQuery<Record>	FactoryProxy.resultQuery(String sql, Object... bindings) Deprecated.
ResultQuery<Record>	Factory.resultQuery(String sql, Object... bindings) Create a new query holding plain SQL.
ResultQuery<Record>	FactoryProxy.resultQuery(String sql, QueryPart... parts) Deprecated.
ResultQuery<Record>	Factory.resultQuery(String sql, QueryPart... parts) Create a new query holding plain SQL.
static Table<Record>	Factory.table(String sql) A custom SQL clause that can render arbitrary table expressions.
static Table<Record>	Factory.table(String sql, Object... bindings) A custom SQL clause that can render arbitrary table expressions.
static Table<Record>	Factory.table(String sql, QueryPart... parts) A custom SQL clause that can render arbitrary table expressions.
static Table<Record>	Factory.tableByName(String... qualifiedName) Create a qualified table, given its table name This constructs a table reference given the table's qualified name. jOOQ will render the table name according to your Settings.getRenderNameStyle() settings.

Uses of Record in org.jooq.util.h2

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

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

Uses of Record in org.jooq.util.hsqldb

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

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

Uses of Record in org.jooq.util.oracle

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

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

Uses of Record in org.jooq.util.postgres

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

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