Package | Description |
---|---|
org.jooq |
The
org.jooq package contains jOOQ's public API. |
org.jooq.exception |
The
org.jooq.exception package contains jOOQ's exceptions. |
org.jooq.impl |
The
org.jooq.impl package contains jOOQ's implementation classes. |
Modifier and Type | Method and Description |
---|---|
DataAccessException |
LoaderError.exception()
The underlying
DataAccessException that caused the error |
Modifier and Type | Method and Description |
---|---|
Connection |
ConnectionProvider.acquire()
Acquire a connection from the connection lifecycle handler.
|
void |
SelectQuery.addJoinOnKey(TableLike<?> table,
JoinType type)
Joins the existing table product to a new table using a foreign key
|
void |
SelectQuery.addJoinOnKey(TableLike<?> table,
JoinType type,
TableField<?,?>... keyFields)
Joins the existing table product to a new table using a foreign key
|
void |
QueryPartInternal.bind(BindContext ctx)
Bind all parameters of this
QueryPart to a PreparedStatement
This method is for JOOQ INTERNAL USE only. |
BindContext |
BindContext.bind(Collection<? extends QueryPart> parts)
Deprecated.
- 3.2.0 - [#2666] - Use
Context.visit(QueryPart) instead |
BindContext |
BindContext.bind(QueryPart part)
Deprecated.
- 3.2.0 - [#2666] - Use
Context.visit(QueryPart) instead |
BindContext |
BindContext.bind(QueryPart[] parts)
Deprecated.
- 3.2.0 - [#2666] - Use
Context.visit(QueryPart) instead |
BindContext |
BindContext.bindValue(Object value,
Class<?> type)
Deprecated.
- 3.4.0 - [#3114] - Use
BindContext.bindValue(Object, Field) instead |
BindContext |
BindContext.bindValue(Object value,
Field<?> field)
Bind a value using a specific type.
|
BindContext |
BindContext.bindValues(Object... values)
Deprecated.
- 3.4.0 - [#3114] - Use
BindContext.bindValue(Object, Field) instead |
void |
Query.cancel()
Cancel the underlying statement.
|
void |
Query.close()
Close the underlying statement.
|
void |
Cursor.close()
Explicitly close the underlying
PreparedStatement and
ResultSet . |
long |
DAO.count()
Count all records of the underlying table.
|
<T extends Number> |
DSLContext.currval(Sequence<T> sequence)
Convenience method to fetch the CURRVAL for a sequence directly from this
DSLContext 's underlying JDBC Connection |
int |
UpdatableRecord.delete()
Deletes this record from the database, based on the value of the primary
key or main unique key.
|
void |
DAO.delete(Collection<P> objects)
Performs a
DELETE statement for a given set of POJOs |
void |
DAO.delete(P... objects)
Performs a
DELETE statement for a given set of POJOs |
void |
DAO.deleteById(Collection<T> ids)
Performs a
DELETE statement for a given set of IDs |
void |
DAO.deleteById(T... ids)
Performs a
DELETE statement for a given set of IDs |
int |
Routine.execute()
Execute the stored object on an underlying connection
|
int |
Query.execute()
Execute the query, if it has been created with a proper configuration.
|
int[] |
Batch.execute()
Execute the batch operation.
|
int |
Routine.execute(Configuration configuration)
Execute the stored object using a
Configuration object |
int |
DSLContext.execute(Query query)
Execute a
Query in the context of this DSLContext . |
int |
DSLContext.execute(String sql)
Execute a query holding plain SQL.
|
int |
DSLContext.execute(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
int |
DSLContext.execute(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends UpdatableRecord<R>> |
DSLContext.executeDelete(R record)
Delete a record from a table.
|
<R extends TableRecord<R>,T> |
DSLContext.executeDelete(R record,
Condition condition)
Delete a record from a table.
|
<R extends TableRecord<R>> |
DSLContext.executeInsert(R record)
Insert one record.
|
<R extends UpdatableRecord<R>> |
DSLContext.executeUpdate(R record)
Update a table.
|
<R extends TableRecord<R>,T> |
DSLContext.executeUpdate(R record,
Condition condition)
Update a table.
|
boolean |
DAO.exists(P object)
Checks if a given POJO exists
|
boolean |
DAO.existsById(T id)
Checks if a given ID exists
|
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.
|
<T> List<T> |
ResultQuery.fetch(Field<?> field,
Class<? extends T> type)
Execute the query and return all values for a field from the generated
result.
|
<T> List<T> |
ResultQuery.fetch(Field<T> field)
Execute the query and return all values for a field from the generated
result.
|
<T,U> List<U> |
ResultQuery.fetch(Field<T> field,
Converter<? super T,U> converter)
Execute the query and return all values for a field from the generated
result.
|
<Z> List<P> |
DAO.fetch(Field<Z> field,
Z... values)
Find records by a given field and a set of values.
|
List<?> |
ResultQuery.fetch(int fieldIndex)
Execute the query and return all values for a field index from the
generated result.
|
Result<R> |
Cursor.fetch(int number)
Fetch the next couple of records from the cursor.
|
<T> List<T> |
ResultQuery.fetch(int fieldIndex,
Class<? extends T> type)
Execute the query and return all values for a field index from the
generated result.
|
<U> List<U> |
ResultQuery.fetch(int fieldIndex,
Converter<?,U> converter)
Execute the query and return all values for a field index from the
generated result.
|
<E> List<E> |
ResultQuery.fetch(RecordMapper<? super R,E> mapper)
Fetch results into a custom mapper callback.
|
<E> List<E> |
Cursor.fetch(RecordMapper<? super R,E> mapper)
Fetch results into a custom mapper callback.
|
<R extends Record> |
DSLContext.fetch(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
results. |
Result<Record> |
DSLContext.fetch(ResultSet rs)
|
Result<Record> |
DSLContext.fetch(ResultSet rs,
Class<?>... types)
|
Result<Record> |
DSLContext.fetch(ResultSet rs,
DataType<?>... types)
|
Result<Record> |
DSLContext.fetch(ResultSet rs,
Field<?>... fields)
|
List<?> |
ResultQuery.fetch(String fieldName)
Execute the query and return all values for a field name from the
generated result.
|
Result<Record> |
DSLContext.fetch(String sql)
Execute a new query holding plain SQL.
|
<T> List<T> |
ResultQuery.fetch(String fieldName,
Class<? extends T> type)
Execute the query and return all values for a field name from the
generated result.
|
<U> List<U> |
ResultQuery.fetch(String fieldName,
Converter<?,U> converter)
Execute the query and return all values for a field name from the
generated result.
|
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> |
DSLContext.fetch(Table<R> table)
Execute and return all records for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetch(Table<R> table,
Condition condition)
Execute and return all records for
SELECT * FROM [table] WHERE [condition] . |
R |
ResultQuery.fetchAny()
Execute the query and return at most one resulting record.
|
<R extends Record> |
DSLContext.fetchAny(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] LIMIT 1 . |
<R extends Record> |
DSLContext.fetchAny(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition] LIMIT 1 . |
<T> T[] |
ResultQuery.fetchArray(Field<?> field,
Class<? extends T> type)
Execute the query and return all values for a field from the generated
result.
|
<T> T[] |
ResultQuery.fetchArray(Field<T> field)
Execute the query and return all values for a field from the generated
result.
|
<T,U> U[] |
ResultQuery.fetchArray(Field<T> field,
Converter<? super T,U> converter)
Execute the query and return all values for a field from the generated
result.
|
Object[] |
ResultQuery.fetchArray(int fieldIndex)
Execute the query and return all values for a field index from the
generated result.
|
<T> T[] |
ResultQuery.fetchArray(int fieldIndex,
Class<? extends T> type)
Execute the query and return all values for a field index from the
generated result.
|
<U> U[] |
ResultQuery.fetchArray(int fieldIndex,
Converter<?,U> converter)
Execute the query and return all values for a field index from the
generated result.
|
Object[] |
ResultQuery.fetchArray(String fieldName)
Execute the query and return all values for a field name from the
generated result.
|
<T> T[] |
ResultQuery.fetchArray(String fieldName,
Class<? extends T> type)
Execute the query and return all values for a field name from the
generated result.
|
<U> U[] |
ResultQuery.fetchArray(String fieldName,
Converter<?,U> converter)
Execute the query and return all values for a field name from the
generated result.
|
Object[][] |
ResultQuery.fetchArrays()
Execute the query and return the generated result as an Object matrix
You can access data like this
query.fetchArray()[recordIndex][fieldIndex] |
<O extends TableRecord<O>> |
UpdatableRecord.fetchChild(ForeignKey<O,R> key)
Fetch a child record of this record, given a foreign key
This returns a child record referencing this record through a given
foreign key.
|
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>> |
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
|
int |
Select.fetchCount()
Execute this query in the context of its attached executor and return
a
COUNT(*) value. |
int |
DSLContext.fetchCount(Select<?> query)
|
int |
DSLContext.fetchCount(Table<?> table)
Count the number of records in a table.
|
int |
DSLContext.fetchCount(Table<?> table,
Condition condition)
Count the number of records in a table.
|
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.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.
|
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. |
<K,E> Map<K,List<E>> |
ResultQuery.fetchGroups(Field<K> key,
Class<? extends E> type)
Return a
Map with results grouped by the given key and mapped
into the given entity type. |
<K,V> Map<K,List<V>> |
ResultQuery.fetchGroups(Field<K> key,
Field<V> value)
Execute the query and return a
Map with one of the result's
columns as key and another one of the result's columns as value
Unlike ResultQuery.fetchMap(Field, Field) , this method allows for non-unique
keys in the result set. |
<K,E> Map<K,List<E>> |
ResultQuery.fetchGroups(Field<K> key,
RecordMapper<? super R,E> mapper)
Return a
Map with results grouped by the given key and mapped by
the given mapper. |
<E> List<E> |
ResultQuery.fetchInto(Class<? extends E> type)
Map resulting records onto a custom type.
|
<E> List<E> |
Cursor.fetchInto(Class<? extends E> type)
Map resulting records onto a custom type.
|
<H extends RecordHandler<? super R>> |
ResultQuery.fetchInto(H handler)
Fetch results into a custom handler callback.
|
<H extends RecordHandler<? super R>> |
Cursor.fetchInto(H handler)
Fetch results into a custom handler callback.
|
<Z extends Record> |
ResultQuery.fetchInto(Table<Z> table)
Map resulting records onto a custom record.
|
<Z extends Record> |
Cursor.fetchInto(Table<Z> table)
Map resulting records onto a custom record.
|
FutureResult<R> |
ResultQuery.fetchLater()
Deprecated.
- 3.2.0 - [#2581] - This method will be removed in jOOQ 4.0
|
FutureResult<R> |
ResultQuery.fetchLater(ExecutorService executor)
Deprecated.
- 3.2.0 - [#2581] - This method will be removed in jOOQ 4.0
|
Cursor<R> |
ResultQuery.fetchLazy()
Execute the query and "lazily" return the generated result.
|
Cursor<R> |
ResultQuery.fetchLazy(int fetchSize)
Deprecated.
- [#2811] - 3.3.0 - Use
ResultQuery.fetchSize(int) and
ResultQuery.fetchLazy() instead. |
<R extends Record> |
DSLContext.fetchLazy(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a cursor. |
Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs)
|
Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs,
Class<?>... types)
|
Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs,
DataType<?>... types)
|
Cursor<Record> |
DSLContext.fetchLazy(ResultSet rs,
Field<?>... fields)
|
Cursor<Record> |
DSLContext.fetchLazy(String sql)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(String sql,
Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
Cursor<Record> |
DSLContext.fetchLazy(String sql,
QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated
result.
|
<R extends Record> |
DSLContext.fetchLazy(Table<R> table)
Execute and return all records lazily for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetchLazy(Table<R> table,
Condition condition)
Execute and return all records lazily for
SELECT * FROM [table] WHERE [condition] . |
List<Result<Record>> |
ResultQuery.fetchMany()
Execute a query, possibly returning several result sets.
|
<R extends 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,R> |
ResultQuery.fetchMap(Field<?>[] keys)
Execute the query and return a
Map with keys as a map key and the
corresponding record as value. |
<K> Map<K,R> |
ResultQuery.fetchMap(Field<K> key)
Execute the query and return a
Map with one of the result's
columns as key and the corresponding records as value. |
<K,E> Map<K,E> |
ResultQuery.fetchMap(Field<K> key,
Class<? extends E> type)
Execute the query and return a
Map with results grouped by the
given key and mapped into the given entity type. |
<K,V> Map<K,V> |
ResultQuery.fetchMap(Field<K> key,
Field<V> value)
Execute the query and return a
Map with one of the result's
columns as key and another one of the result's columns as value
An exception is thrown, if the key turns out to be non-unique in the
result set. |
<K,E> Map<K,E> |
ResultQuery.fetchMap(Field<K> key,
RecordMapper<? super R,E> mapper)
Execute the query and return a
Map with results grouped by the
given key and mapped by the given mapper. |
List<Map<String,Object>> |
ResultQuery.fetchMaps()
Execute the query and return the generated result as a list of name/value
maps.
|
R |
UpdateResultStep.fetchOne()
The record holding returned values as specified by the
UpdateReturningStep |
R |
ResultQuery.fetchOne()
Execute the query and return at most one resulting record.
|
R |
InsertResultStep.fetchOne()
The record holding returned values as specified by the
InsertReturningStep |
R |
Cursor.fetchOne()
Fetch the next record from the cursor.
|
<T> T |
ResultQuery.fetchOne(Field<?> field,
Class<? extends T> type)
Execute the query and return return at most one resulting value for a
field from the generated result.
|
<T> T |
ResultQuery.fetchOne(Field<T> field)
Execute the query and return return at most one resulting value for a
field from the generated result.
|
<T,U> U |
ResultQuery.fetchOne(Field<T> field,
Converter<? super T,U> converter)
Execute the query and return return at most one resulting value for a
field from the generated result.
|
<Z> P |
DAO.fetchOne(Field<Z> field,
Z value)
Find a unique record by a given field and a value.
|
Object |
ResultQuery.fetchOne(int fieldIndex)
Execute the query and return return at most one resulting value for a
field index from the generated result.
|
<T> T |
ResultQuery.fetchOne(int fieldIndex,
Class<? extends T> type)
Execute the query and return return at most one resulting value for a
field index from the generated result.
|
<U> U |
ResultQuery.fetchOne(int fieldIndex,
Converter<?,U> converter)
Execute the query and return return at most one resulting value for a
field index from the generated result.
|
<E> E |
Cursor.fetchOne(RecordMapper<? super R,E> mapper)
Fetch the next record into a custom mapper callback.
|
<R extends Record> |
DSLContext.fetchOne(ResultQuery<R> query)
Execute a
ResultQuery in the context of this DSLContext and return
a record. |
Record |
DSLContext.fetchOne(ResultSet rs)
|
Record |
DSLContext.fetchOne(ResultSet rs,
Class<?>... types)
|
Record |
DSLContext.fetchOne(ResultSet rs,
DataType<?>... types)
|
Record |
DSLContext.fetchOne(ResultSet rs,
Field<?>... fields)
|
Object |
ResultQuery.fetchOne(String fieldName)
Execute the query and return return at most one resulting value for a
field name from the generated result.
|
Record |
DSLContext.fetchOne(String sql)
Execute a new query holding plain SQL.
|
<T> T |
ResultQuery.fetchOne(String fieldName,
Class<? extends T> type)
Execute the query and return return at most one resulting value for a
field name from the generated result.
|
<U> U |
ResultQuery.fetchOne(String fieldName,
Converter<?,U> converter)
Execute the query and return return at most one resulting value for a
field name from the generated result.
|
Record |
DSLContext.fetchOne(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Record |
DSLContext.fetchOne(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
<R extends Record> |
DSLContext.fetchOne(Table<R> table)
Execute and return zero or one record for
SELECT * FROM [table] . |
<R extends Record> |
DSLContext.fetchOne(Table<R> table,
Condition condition)
Execute and return zero or one record for
SELECT * FROM [table] WHERE [condition] . |
Object[] |
ResultQuery.fetchOneArray()
Execute the query and return at most one resulting record as an array
You can access data like this
query.fetchOneArray()[fieldIndex] |
<E> E |
ResultQuery.fetchOneInto(Class<? extends E> type)
Map resulting records onto a custom type.
|
<E> E |
Cursor.fetchOneInto(Class<? extends E> type)
Map the next resulting record onto a custom type.
|
<H extends RecordHandler<? super R>> |
Cursor.fetchOneInto(H handler)
Fetch the next record into a custom handler callback.
|
<Z extends Record> |
ResultQuery.fetchOneInto(Table<Z> table)
Map resulting records onto a custom record.
|
<Z extends Record> |
Cursor.fetchOneInto(Table<Z> table)
Map the next resulting record onto a custom record.
|
Map<String,Object> |
ResultQuery.fetchOneMap()
Execute the query and return at most one resulting record as a name/value
map.
|
<O extends UpdatableRecord<O>> |
TableRecord.fetchParent(ForeignKey<R,O> key)
Fetch a parent record of this record, given a foreign key
This returns a parent record referenced by this record through a given
foreign key.
|
O |
ForeignKey.fetchParent(R record)
Fetch a parent record of a given record through this foreign key
This returns a parent record referenced by a given record through this
foreign key.
|
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.
|
ResultSet |
ResultQuery.fetchResultSet()
Execute the query and return the generated result as a JDBC
ResultSet . |
<T,R extends Record1<T>> |
DSLContext.fetchValue(ResultQuery<R> query)
Execute a
ResultQuery in the context of this
DSLContext and return a single value. |
Object |
DSLContext.fetchValue(ResultSet rs)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
DSLContext.fetchValue(ResultSet rs,
Class<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
DSLContext.fetchValue(ResultSet rs,
DataType<T> type)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
<T> T |
DSLContext.fetchValue(ResultSet rs,
Field<T> field)
Fetch a record from a JDBC
ResultSet and return the only
contained value. |
Object |
DSLContext.fetchValue(String sql)
Execute a new query holding plain SQL.
|
Object |
DSLContext.fetchValue(String sql,
Object... bindings)
Execute a new query holding plain SQL.
|
Object |
DSLContext.fetchValue(String sql,
QueryPart... parts)
Execute a new query holding plain SQL.
|
List<P> |
DAO.findAll()
Find all records of the underlying table.
|
P |
DAO.findById(T id)
Find a record of the underlying table by ID.
|
List<Catalog> |
Meta.getCatalogs()
Get all catalog objects from the underlying
DatabaseMetaData . |
List<UniqueKey<?>> |
Meta.getPrimaryKeys()
Get all primary keys from the underlying
DatabaseMetaData . |
List<Schema> |
Meta.getSchemas()
Get all schema objects from the underlying
DatabaseMetaData . |
List<Table<?>> |
Meta.getTables()
Get all table objects from the underlying
DatabaseMetaData . |
boolean |
Cursor.hasNext()
Check whether this cursor has a next record.
|
int |
UpdatableRecord.insert()
Store this record back to the database using an
INSERT
statement. |
void |
DAO.insert(Collection<P> objects)
Performs a batch
INSERT statement for a given set of POJOs |
void |
DAO.insert(P... objects)
Performs a batch
INSERT statement for a given set of POJOs |
void |
DAO.insert(P object)
Performs an
INSERT statement for a given POJO |
BigInteger |
DSLContext.lastID()
Retrieve the last inserted ID.
|
<T extends Number> |
DSLContext.nextval(Sequence<T> sequence)
Convenience method to fetch the NEXTVAL for a sequence directly from this
DSLContext 's underlying JDBC Connection |
TableOnConditionStep |
TableOnStep.onKey()
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
|
SelectJoinStep<R> |
SelectOnStep.onKey()
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
|
TableOnConditionStep |
TableOnStep.onKey(TableField<?,?>... keyFields)
Join the table on a non-ambiguous foreign key relationship between the
two joined tables.
|
SelectJoinStep<R> |
SelectOnStep.onKey(TableField<?,?>... keyFields)
Join the previous table on a non-ambiguous foreign key relationship
between the two joined tables.
|
void |
UpdatableRecord.refresh()
Refresh this record from the database.
|
void |
UpdatableRecord.refresh(Field<?>... fields)
Refresh parts of this record from the database.
|
void |
ConnectionProvider.release(Connection connection)
Release a connection to the connection lifecycle handler.
|
int |
UpdatableRecord.store()
Store this record back to the database.
|
int |
UpdatableRecord.update()
Store this record back to the database using an
UPDATE
statement. |
void |
DAO.update(Collection<P> objects)
Performs a batch
UPDATE statement for a given set of POJOs |
void |
DAO.update(P... objects)
Performs a batch
UPDATE statement for a given set of POJOs |
void |
DAO.update(P object)
Performs an
UPDATE statement for a given POJO |
C |
Context.visit(QueryPart part)
Visit a
QueryPart in the current Context . |
Modifier and Type | Class and Description |
---|---|
class |
DataChangedException
An error occurred while storing a record whose underlying data had already
been changed
|
class |
DataTypeException
An error occurred while handling data types.
|
class |
DetachedException
|
class |
InvalidResultException
An unexpected result was encountered after executing a
Query . |
class |
MappingException
An error occurred while fetching data into a user defined Java object with
any of these methods:
ResultQuery.fetchInto(Class)
Cursor.fetchInto(Class)
Result.into(Class)
Record.into(Class)
... or when copying data into a Record with any of these methods
DSLContext.newRecord(org.jooq.Table, Object)
Record.from(Object)
|
Modifier and Type | Method and Description |
---|---|
void |
CustomQueryPart.bind(BindContext context)
Subclasses may implement this method
Bind all parameters of this QueryPart to a PreparedStatement
This method is for JOOQ INTERNAL USE only. |
void |
CustomField.bind(BindContext context)
Subclasses may implement this method
Bind all parameters of this QueryPart to a PreparedStatement
This method is for JOOQ INTERNAL USE only. |
void |
CustomCondition.bind(BindContext context)
Subclasses may implement this method
Bind all parameters of this QueryPart to a PreparedStatement
This method is for JOOQ INTERNAL USE only. |
void |
DefaultConnectionProvider.commit()
Convenience method to access
Connection.commit() . |
boolean |
DefaultConnectionProvider.getAutoCommit()
Convenience method to access
Connection.getAutoCommit() . |
int |
DefaultConnectionProvider.getHoldability()
Convenience method to access
Connection.getHoldability() . |
int |
DefaultConnectionProvider.getTransactionIsolation()
Convenience method to access
Connection.getTransactionIsolation() . |
void |
DefaultConnectionProvider.releaseSavepoint(Savepoint savepoint)
Convenience method to access
Connection.releaseSavepoint(Savepoint) . |
void |
DefaultConnectionProvider.rollback()
Convenience method to access
Connection.rollback() . |
void |
DefaultConnectionProvider.rollback(Savepoint savepoint)
Convenience method to access
Connection.rollback(Savepoint) . |
void |
DefaultConnectionProvider.setAutoCommit(boolean autoCommit)
Convenience method to access
Connection.setAutoCommit(boolean) . |
void |
DefaultConnectionProvider.setHoldability(int holdability)
Convenience method to access
Connection.setHoldability(int) . |
Savepoint |
DefaultConnectionProvider.setSavepoint()
Convenience method to access
Connection.setSavepoint() . |
Savepoint |
DefaultConnectionProvider.setSavepoint(String name)
Convenience method to access
Connection.setSavepoint(String) . |
void |
DefaultConnectionProvider.setTransactionIsolation(int level)
Convenience method to access
Connection.setTransactionIsolation(int) . |
Copyright © 2014. All Rights Reserved.