Uses of Class
org.jooq.exception.DataAccessException

Packages that use DataAccessException

org.jooq
org.jooq.exception
org.jooq.impl

Uses of DataAccessException in org.jooq

Methods in org.jooq that return DataAccessException

DataAccessException

LoaderError.exception() The underlying DataAccessException that caused the error

Methods in org.jooq that throw DataAccessException

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 context) Bind all parameters of this QueryPart to a PreparedStatement This method is for JOOQ INTERNAL USE only.
BindContext	BindContext.bind(Collection<? extends QueryPart> parts) Bind values from several QueryPart's.
BatchBindStep	BatchBindStep.bind(Object... bindValues) Set bind values on the batch statement
BindContext	BindContext.bind(QueryPart part) Bind values from a QueryPart.
BindContext	BindContext.bind(QueryPart[] parts) Bind values from several QueryPart's.
BindContext	BindContext.bindValue(Object value, Class<?> type) Bind a value using a specific type.
BindContext	BindContext.bindValues(Object... values) Bind several values.
void	Cursor.close() Explicitly close the underlying PreparedStatement and ResultSet If you fetch all records from the underlying ResultSet, jOOQ Cursor implementations will close themselves for you.
<T extends Number> T	FactoryOperations.currval(Sequence<T> sequence) Convenience method to fetch the CURRVAL for a sequence directly from this Factory'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.
int	TableRecord.deleteUsing(TableField<R,?>... keys) Deletes this record from the database, based on the value of the provided keys.
int	Routine.execute() Execute the stored object on an underlying connection
int	Query.execute() Execute the query, if it has been created with a properly configured factory
int[]	Batch.execute() Execute the batch operation.
int	Routine.execute(Configuration configuration) Execute the stored object using a Configuration object
int	FactoryOperations.execute(String sql) Execute a query holding plain SQL.
int	FactoryOperations.execute(String sql, Object... bindings) Execute a new query holding plain SQL.
<R extends TableRecord<R>> int	FactoryOperations.executeDelete(Table<R> table) Delete records from a table DELETE FROM [table]
<R extends TableRecord<R>,T> int	FactoryOperations.executeDelete(Table<R> table, Condition condition) Delete records from a table DELETE FROM [table] WHERE [condition]
<R extends TableRecord<R>> int	FactoryOperations.executeDeleteOne(Table<R> table) Delete one record in a table DELETE FROM [table]
<R extends TableRecord<R>,T> int	FactoryOperations.executeDeleteOne(Table<R> table, Condition condition) Delete one record in a table DELETE FROM [table] WHERE [condition]
<R extends TableRecord<R>> int	FactoryOperations.executeInsert(Table<R> table, R record) Insert one record INSERT INTO [table] ...
<R extends TableRecord<R>> int	FactoryOperations.executeUpdate(Table<R> table, R record) Update a table UPDATE [table] SET [modified values in record]
<R extends TableRecord<R>,T> int	FactoryOperations.executeUpdate(Table<R> table, R record, Condition condition) Update a table UPDATE [table] SET [modified values in record] WHERE [condition]
<R extends TableRecord<R>> int	FactoryOperations.executeUpdateOne(Table<R> table, R record) Update one record in a table UPDATE [table] SET [modified values in record]
<R extends TableRecord<R>,T> int	FactoryOperations.executeUpdateOne(Table<R> table, R record, Condition condition) Update one record in a table UPDATE [table] SET [modified values in record] WHERE [condition]
Result<R>	ResultQuery.fetch() Execute the query and return the generated result This is the same as calling Query.execute() and then ResultQuery.getResult()
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.
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.
Result<Record>	FactoryOperations.fetch(ResultSet rs) Fetch all data from a JDBC ResultSet and transform it to a jOOQ Result.
List<?>	ResultQuery.fetch(String fieldName) Execute the query and return all values for a field name from the generated result.
Result<Record>	FactoryOperations.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>	FactoryOperations.fetch(String sql, Object... bindings) Execute a new query holding plain SQL.
<R extends Record> Result<R>	FactoryOperations.fetch(Table<R> table) Execute and return all records for SELECT * FROM [table]
<R extends Record> Result<R>	FactoryOperations.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> R	FactoryOperations.fetchAny(Table<R> table) Execute and return zero or one record for SELECT * FROM [table] 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]
<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<R>> H	ResultQuery.fetchInto(H handler) Fetch results into a custom handler callback
<H extends RecordHandler<R>> H	Cursor.fetchInto(H handler) Fetch results into a custom handler callback
<Z extends Record> Result<Z>	ResultQuery.fetchInto(Table<Z> table) Map resulting records onto a custom record.
<Z extends Record> List<Z>	Cursor.fetchInto(Table<Z> table) Map resulting records onto a custom record.
FutureResult<R>	ResultQuery.fetchLater() Fetch results asynchronously.
FutureResult<R>	ResultQuery.fetchLater(ExecutorService executor) Fetch results asynchronously.
Cursor<R>	ResultQuery.fetchLazy() Execute the query and "lazily" return the generated result The returned Cursor holds a reference to the executed PreparedStatement and the associated ResultSet.
Cursor<R>	ResultQuery.fetchLazy(int fetchSize) Execute the query and "lazily" return the generated result The returned Cursor holds a reference to the executed PreparedStatement and the associated ResultSet.
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.
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.
<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,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.
List<Map<String,Object>>	ResultQuery.fetchMaps() Execute the query and return the generated result as a list of name/value maps.
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 This will conveniently close the Cursor, after the last Record was fetched.
<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.
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.
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	FactoryOperations.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	FactoryOperations.fetchOne(String sql, Object... bindings) Execute a new query holding plain SQL.
<R extends Record> R	FactoryOperations.fetchOne(Table<R> table) Execute and return zero or one record for SELECT * FROM [table]
<R extends Record> R	FactoryOperations.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	Cursor.fetchOneInto(Class<? extends E> type) Map the next resulting record onto a custom type.
<H extends RecordHandler<R>> H	Cursor.fetchOneInto(H handler) Fetch the next record into a custom handler callback This will conveniently close the Cursor, after the last Record was fetched.
<Z extends Record> Z	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.
ResultSet	ResultQuery.fetchResultSet() Execute the query and return the generated result as a JDBC ResultSet This will return the ResultSet returned by the JDBC driver, leaving it untouched.
boolean	Cursor.hasNext() Check whether this cursor has a next record This will conveniently close the Cursor, after the last Record was fetched.
BigInteger	FactoryOperations.lastID() Retrieve the last inserted ID.
<T extends Number> T	FactoryOperations.nextval(Sequence<T> sequence) Convenience method to fetch the NEXTVAL for a sequence directly from this Factory's underlying JDBC Connection
TableOnConditionStep	TableOnStep.onKey() Join the table on a non-ambiguous foreign key relationship between the two joined tables.
SelectJoinStep	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	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, based on the value of the primary key or main unique key.
void	TableRecord.refreshUsing(TableField<R,?>... keys) Refresh this record from the database, based on the value of the provided keys.
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.
int	UpdatableRecord.store() Store this record back to the database.
int	TableRecord.storeUsing(TableField<R,?>... keys) Store this record back to the database.
int	FactoryOperations.use(Schema schema) Use a schema as the default schema of the underlying connection.
int	FactoryOperations.use(String schema) Use a schema as the default schema of the underlying connection.

Uses of DataAccessException in org.jooq.exception

Subclasses of DataAccessException in org.jooq.exception

class	DataTypeException An error occurred while handling data types.
class	DetachedException An operation was invoked on a detached object (Query, QueryPart, or UpdatableRecord).
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 FactoryOperations.newRecord(org.jooq.Table, Object) Record.from(Object)

Uses of DataAccessException in org.jooq.impl

Methods in org.jooq.impl that throw DataAccessException

abstract void	CustomField.bind(BindContext context) Subclasses must implement this method Bind all parameters of this QueryPart to a PreparedStatement This method is for JOOQ INTERNAL USE only.
abstract void	CustomCondition.bind(BindContext context) Subclasses must implement this method Bind all parameters of this QueryPart to a PreparedStatement This method is for JOOQ INTERNAL USE only.
int	Factory.execute(String sql) Execute a query holding plain SQL.
int	Factory.execute(String sql, Object... bindings) Execute a new query holding plain SQL.
Cursor<Record>	Factory.fetchLazy(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.
Cursor<Record>	Factory.fetchLazy(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.
ResultQuery<Record>	Factory.resultQuery(String sql) Create a new query holding plain SQL.
ResultQuery<Record>	Factory.resultQuery(String sql, Object... bindings) Create a new query holding plain SQL.