Module com.aoapps.dbc

Package com.aoapps.dbc

Interface DatabaseAccess

All Known Implementing Classes:

CloseableDatabase, Database, DatabaseConnection

public interface DatabaseAccess

Wraps and simplifies access to a JDBC database.

Author:

AO Industries, Inc.

Nested Class Summary

Nested Classes

Modifier and Type	Interface	Description
static enum	DatabaseAccess.Null	These may be used as parameters to represent null values of specific types.

Method Summary

Modifier and Type	Method	Description
DoubleStream	doubleStream(int isolationLevel, boolean readOnly, String sql, Object... params)	Query the database with a DoubleStream return type.
default DoubleStream	doubleStream(String sql, Object... params)	Read-only query the database with a DoubleStream return type.
default DoubleStream	doubleStreamUpdate(String sql, Object... params)	Read-write query the database with a DoubleStream return type.
default BigDecimal	executeBigDecimalQuery(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryBigDecimal(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default BigDecimal	executeBigDecimalQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryBigDecimal(java.lang.String, java.lang.Object...)
default BigDecimal	executeBigDecimalUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateBigDecimal(java.lang.String, java.lang.Object...)
default Boolean	executeBooleanQuery(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryBoolean(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default boolean	executeBooleanQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryBoolean(java.lang.String, java.lang.Object...)
default boolean	executeBooleanUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateBoolean(java.lang.String, java.lang.Object...)
default byte[]	executeByteArrayQuery(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryByteArray(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default byte[]	executeByteArrayQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryByteArray(java.lang.String, java.lang.Object...)
default byte[]	executeByteArrayUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateByteArray(java.lang.String, java.lang.Object...)
default Date	executeDateQuery(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryDate(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default Date	executeDateQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryDate(java.lang.String, java.lang.Object...)
default Date	executeDateUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateDate(java.lang.String, java.lang.Object...)
default IntList	executeIntListQuery(int isolationLevel, boolean readOnly, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryIntList(int, boolean, java.lang.String, java.lang.Object...)
default IntList	executeIntListQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryIntList(java.lang.String, java.lang.Object...)
default IntList	executeIntListUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateIntList(java.lang.String, java.lang.Object...)
default Integer	executeIntQuery(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryInt(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default int	executeIntQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryInt(java.lang.String, java.lang.Object...)
default int	executeIntUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateInt(java.lang.String, java.lang.Object...)
default LongList	executeLongListQuery(int isolationLevel, boolean readOnly, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryLongList(int, boolean, java.lang.String, java.lang.Object...)
default LongList	executeLongListQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryLongList(java.lang.String, java.lang.Object...)
default LongList	executeLongListUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateLongList(java.lang.String, java.lang.Object...)
default Long	executeLongQuery(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryLong(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default long	executeLongQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryLong(java.lang.String, java.lang.Object...)
default long	executeLongUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateLong(java.lang.String, java.lang.Object...)
default <T, C extends Collection<? super T>> C	executeObjectCollectionQuery(int isolationLevel, boolean readOnly, C collection, ObjectFactory<T> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryCollection(int, boolean, java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
default <T, C extends Collection<? super T>, Ex extends Exception> C	executeObjectCollectionQuery(int isolationLevel, boolean readOnly, C collection, Class<Ex> exClass, ObjectFactoryE<T,Ex> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryCollection(int, boolean, java.util.Collection, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)
default <T, C extends Collection<? super T>> C	executeObjectCollectionQuery(int isolationLevel, boolean readOnly, C collection, Class<T> clazz, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryCollection(int, boolean, java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.
default <T, C extends Collection<? super T>> C	executeObjectCollectionQuery(C collection, ObjectFactory<T> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
default <T, C extends Collection<? super T>, Ex extends Exception> C	executeObjectCollectionQuery(C collection, Class<Ex> exClass, ObjectFactoryE<T,Ex> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryCollection(java.util.Collection, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)
default <T, C extends Collection<? super T>> C	executeObjectCollectionQuery(C collection, Class<T> clazz, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.
default <T, C extends Collection<? super T>> C	executeObjectCollectionUpdate(C collection, ObjectFactory<T> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
default <T, C extends Collection<? super T>, Ex extends Exception> C	executeObjectCollectionUpdate(C collection, Class<Ex> exClass, ObjectFactoryE<T,Ex> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateCollection(java.util.Collection, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)
default <T, C extends Collection<? super T>> C	executeObjectCollectionUpdate(C collection, Class<T> clazz, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.
default <T> List<T>	executeObjectListQuery(int isolationLevel, boolean readOnly, ObjectFactory<T> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryList(int, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
default <T, Ex extends Exception> List<T>	executeObjectListQuery(int isolationLevel, boolean readOnly, Class<Ex> exClass, ObjectFactoryE<T,Ex> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryList(int, boolean, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)
default <T> List<T>	executeObjectListQuery(int isolationLevel, boolean readOnly, Class<T> clazz, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryList(int, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.
default <T> List<T>	executeObjectListQuery(ObjectFactory<T> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
default <T, Ex extends Exception> List<T>	executeObjectListQuery(Class<Ex> exClass, ObjectFactoryE<T,Ex> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryList(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)
default <T> List<T>	executeObjectListQuery(Class<T> clazz, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.
default <T> List<T>	executeObjectListUpdate(ObjectFactory<T> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
default <T, Ex extends Exception> List<T>	executeObjectListUpdate(Class<Ex> exClass, ObjectFactoryE<T,Ex> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateList(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)
default <T> List<T>	executeObjectListUpdate(Class<T> clazz, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.
default <T> T	executeObjectQuery(int isolationLevel, boolean readOnly, boolean rowRequired, ObjectFactory<T> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryObject(int, boolean, boolean, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
default <T, Ex extends Exception> T	executeObjectQuery(int isolationLevel, boolean readOnly, boolean rowRequired, Class<Ex> exClass, ObjectFactoryE<T,Ex> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryObject(int, boolean, boolean, boolean, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)
default <T> T	executeObjectQuery(int isolationLevel, boolean readOnly, boolean rowRequired, Class<T> clazz, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryObject(int, boolean, boolean, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.
default <T> T	executeObjectQuery(ObjectFactory<T> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
default <T, Ex extends Exception> T	executeObjectQuery(Class<Ex> exClass, ObjectFactoryE<T,Ex> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryObject(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)
default <T> T	executeObjectQuery(Class<T> clazz, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.
default <T> T	executeObjectUpdate(ObjectFactory<T> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
default <T, Ex extends Exception> T	executeObjectUpdate(Class<Ex> exClass, ObjectFactoryE<T,Ex> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateObject(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)
default <T> T	executeObjectUpdate(Class<T> clazz, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.
default <T> T	executeQuery(int isolationLevel, boolean readOnly, ResultSetHandler<T> resultSetHandler, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryCall(int, boolean, com.aoapps.dbc.ResultSetCallable, java.lang.String, java.lang.Object...)
default <T, Ex extends Exception> T	executeQuery(int isolationLevel, boolean readOnly, Class<Ex> exClass, ResultSetHandlerE<T,Ex> resultSetHandler, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryCall(int, boolean, java.lang.Class, com.aoapps.dbc.ResultSetCallableE, java.lang.String, java.lang.Object...)
default <T> T	executeQuery(ResultSetHandler<T> resultSetHandler, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryCall(com.aoapps.dbc.ResultSetCallable, java.lang.String, java.lang.Object...)
default <T, Ex extends Exception> T	executeQuery(Class<Ex> exClass, ResultSetHandlerE<T,Ex> resultSetHandler, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryCall(java.lang.Class, com.aoapps.dbc.ResultSetCallableE, java.lang.String, java.lang.Object...)
default List<Short>	executeShortListQuery(int isolationLevel, boolean readOnly, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryList(int, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with ObjectFactories.Short
default List<Short>	executeShortListQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with ObjectFactories.Short
default List<Short>	executeShortListUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with ObjectFactories.Short
default Short	executeShortQuery(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryShort(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default short	executeShortQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryShort(java.lang.String, java.lang.Object...)
default short	executeShortUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateShort(java.lang.String, java.lang.Object...)
default List<String>	executeStringListQuery(int isolationLevel, boolean readOnly, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryStringList(int, boolean, java.lang.String, java.lang.Object...)
default List<String>	executeStringListQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryStringList(java.lang.String, java.lang.Object...)
default List<String>	executeStringListUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateStringList(java.lang.String, java.lang.Object...)
default String	executeStringQuery(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryString(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default String	executeStringQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryString(java.lang.String, java.lang.Object...)
default String	executeStringUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateString(java.lang.String, java.lang.Object...)
default Timestamp	executeTimestampQuery(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryTimestamp(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default Timestamp	executeTimestampQuery(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryTimestamp(java.lang.String, java.lang.Object...)
default Timestamp	executeTimestampUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateTimestamp(java.lang.String, java.lang.Object...)
default <T> T	executeUpdate(ResultSetHandler<T> resultSetHandler, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateCall(com.aoapps.dbc.ResultSetCallable, java.lang.String, java.lang.Object...)
default <T, Ex extends Exception> T	executeUpdate(Class<Ex> exClass, ResultSetHandlerE<T,Ex> resultSetHandler, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use updateCall(java.lang.Class, com.aoapps.dbc.ResultSetCallableE, java.lang.String, java.lang.Object...)
default int	executeUpdate(String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use update(java.lang.String, java.lang.Object...)
IntStream	intStream(int isolationLevel, boolean readOnly, String sql, Object... params)	Query the database with an IntStream return type.
default IntStream	intStream(String sql, Object... params)	Read-only query the database with an IntStream return type.
default IntStream	intStreamUpdate(String sql, Object... params)	Read-write query the database with an IntStream return type.
boolean	isInTransaction()	Checks if the current thread is in a transaction.
long	largeUpdate(String sql, Object... params)	Performs an update on the database and returns the number of rows affected.
LongStream	longStream(int isolationLevel, boolean readOnly, String sql, Object... params)	Query the database with a LongStream return type.
default LongStream	longStream(String sql, Object... params)	Read-only query the database with a LongStream return type.
default LongStream	longStreamUpdate(String sql, Object... params)	Read-write query the database with a LongStream return type.
default BigDecimal	queryBigDecimal(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with a BigDecimal return type.
default BigDecimal	queryBigDecimal(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryBigDecimal(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default BigDecimal	queryBigDecimal(String sql, Object... params)	Read-only query the database with a required non-null BigDecimal return type.
default BigDecimal	queryBigDecimalNullable(String sql, Object... params)	Read-only query the database with a required nullable BigDecimal return type.
default Optional<BigDecimal>	queryBigDecimalOptional(String sql, Object... params)	Read-only query the database with an optional non-null BigDecimal return type.
default Optional<BigDecimal>	queryBigDecimalOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable BigDecimal return type.
default Boolean	queryBoolean(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with a Boolean return type.
default Boolean	queryBoolean(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryBoolean(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default boolean	queryBoolean(String sql, Object... params)	Read-only query the database with a required non-null boolean return type.
default Boolean	queryBooleanNullable(String sql, Object... params)	Read-only query the database with a required nullable Boolean return type.
default Optional<Boolean>	queryBooleanOptional(String sql, Object... params)	Read-only query the database with an optional non-null Boolean return type.
default Optional<Boolean>	queryBooleanOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable Boolean return type.
default byte[]	queryByteArray(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with a byte[] return type.
default byte[]	queryByteArray(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryByteArray(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default byte[]	queryByteArray(String sql, Object... params)	Read-only query the database with a required non-null byte[] return type.
default byte[]	queryByteArrayNullable(String sql, Object... params)	Read-only query the database with a required nullable byte[] return type.
default Optional<byte[]>	queryByteArrayOptional(String sql, Object... params)	Read-only query the database with an optional non-null byte[] return type.
default Optional<byte[]>	queryByteArrayOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable byte[] return type.
default <T> T	queryCall(int isolationLevel, boolean readOnly, ResultSetCallable<? extends T> resultSetCallable, String sql, Object... params)	Query the database, calling the ResultSetCallable once.
<T, Ex extends Throwable> T	queryCall(int isolationLevel, boolean readOnly, Class<? extends Ex> exClass, ResultSetCallableE<? extends T,? extends Ex> resultSetCallable, String sql, Object... params)	Query the database, calling the ResultSetCallableE once.
default <T> T	queryCall(ResultSetCallable<? extends T> resultSetCallable, String sql, Object... params)	Read-only query the database, calling the ResultSetCallable once.
default <T, Ex extends Throwable> T	queryCall(Class<? extends Ex> exClass, ResultSetCallableE<? extends T,? extends Ex> resultSetCallable, String sql, Object... params)	Read-only query the database, calling the ResultSetCallableE once.
default <T, C extends Collection<? super T>> C	queryCollection(int isolationLevel, boolean readOnly, C collection, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Query the database with a Collection<T> return type, objects are created with the provided factory.
default <T, C extends Collection<? super T>, Ex extends Throwable> C	queryCollection(int isolationLevel, boolean readOnly, C collection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Query the database with a Collection<T> return type, objects are created with the provided factory.
default <T, C extends Collection<? super T>> C	queryCollection(C collection, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-only query the database with a Collection<T> return type, objects are created with the provided factory.
default <T, C extends Collection<? super T>, Ex extends Throwable> C	queryCollection(C collection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-only query the database with a Collection<T> return type, objects are created with the provided factory.
default Date	queryDate(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with a Date return type.
default Date	queryDate(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryDate(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default Date	queryDate(String sql, Object... params)	Read-only query the database with a required non-null Date return type.
default Date	queryDateNullable(String sql, Object... params)	Read-only query the database with a required nullable Date return type.
default Optional<Date>	queryDateOptional(String sql, Object... params)	Read-only query the database with an optional non-null Date return type.
default Optional<Date>	queryDateOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable Date return type.
default Double	queryDouble(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with a Double return type.
default Double	queryDouble(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryDouble(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default double	queryDouble(String sql, Object... params)	Read-only query the database with a required non-null double return type.
default Double	queryDoubleNullable(String sql, Object... params)	Read-only query the database with a required nullable Double return type.
default Optional<Double>	queryDoubleOptional(String sql, Object... params)	Read-only query the database with an optional non-null Double return type.
default Optional<Double>	queryDoubleOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable Double return type.
default Float	queryFloat(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with a Float return type.
default Float	queryFloat(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryFloat(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default float	queryFloat(String sql, Object... params)	Read-only query the database with a required non-null float return type.
default Float	queryFloatNullable(String sql, Object... params)	Read-only query the database with a required nullable Float return type.
default Optional<Float>	queryFloatOptional(String sql, Object... params)	Read-only query the database with an optional non-null Float return type.
default Optional<Float>	queryFloatOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable Float return type.
default Integer	queryInt(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with an Integer return type.
default Integer	queryInt(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryInt(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default int	queryInt(String sql, Object... params)	Read-only query the database with a required non-null int return type.
default IntList	queryIntList(int isolationLevel, boolean readOnly, String sql, Object... params)	Query the database with an IntList return type.
default IntList	queryIntList(String sql, Object... params)	Read-only query the database with an IntList return type.
default Integer	queryIntNullable(String sql, Object... params)	Read-only query the database with a required nullable Integer return type.
default Optional<Integer>	queryIntOptional(String sql, Object... params)	Read-only query the database with an optional non-null Integer return type.
default Optional<Integer>	queryIntOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable Integer return type.
default <T> List<T>	queryList(int isolationLevel, boolean readOnly, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Query the database with a List<T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> List<T>	queryList(int isolationLevel, boolean readOnly, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Query the database with a List<T> return type, objects are created with the provided factory.
default <T> List<T>	queryList(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-only query the database with a List<T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> List<T>	queryList(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-only query the database with a List<T> return type, objects are created with the provided factory.
default Long	queryLong(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with a Long return type.
default Long	queryLong(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryLong(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default long	queryLong(String sql, Object... params)	Read-only query the database with a required non-null long return type.
default LongList	queryLongList(int isolationLevel, boolean readOnly, String sql, Object... params)	Query the database with a LongList return type.
default LongList	queryLongList(String sql, Object... params)	Read-only query the database with a LongList return type.
default Long	queryLongNullable(String sql, Object... params)	Read-only query the database with a required nullable Long return type.
default Optional<Long>	queryLongOptional(String sql, Object... params)	Read-only query the database with an optional non-null Long return type.
default Optional<Long>	queryLongOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable Long return type.
default <T, C extends Collection<? super T>> C	queryNewCollection(int isolationLevel, boolean readOnly, Function<? super Integer,? extends C> newCollection, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Query the database with a Collection<T> return type, objects are created with the provided factory.
default <T, C extends Collection<? super T>, Ex extends Throwable> C	queryNewCollection(int isolationLevel, boolean readOnly, Function<? super Integer,? extends C> newCollection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Query the database with a Collection<T> return type, objects are created with the provided factory.
default <T, C extends Collection<? super T>> C	queryNewCollection(Function<? super Integer,? extends C> newCollection, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-only query the database with a Collection<T> return type, objects are created with the provided factory.
default <T, C extends Collection<? super T>, Ex extends Throwable> C	queryNewCollection(Function<? super Integer,? extends C> newCollection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-only query the database with a Collection<T> return type, objects are created with the provided factory.
default <T> T	queryObject(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Query the database with a <T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> T	queryObject(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Query the database with a <T> return type, objects are created with the provided factory.
default <T> T	queryObject(int isolationLevel, boolean readOnly, boolean rowRequired, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryObject(int, boolean, boolean, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
default <T, Ex extends Throwable> T	queryObject(int isolationLevel, boolean readOnly, boolean rowRequired, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryObject(int, boolean, boolean, boolean, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)
default <T> T	queryObject(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-only query the database with a required non-null <T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> T	queryObject(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-only query the database with a required non-null <T> return type, objects are created with the provided factory.
default <T> T	queryObjectNullable(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-only query the database with a required nullable <T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> T	queryObjectNullable(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-only query the database with a required nullable <T> return type, objects are created with the provided factory.
default <T> Optional<T>	queryObjectOptional(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-only query the database with an optional non-null <T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> Optional<T>	queryObjectOptional(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-only query the database with an optional non-null <T> return type, objects are created with the provided factory.
default <T> Optional<T>	queryObjectOptionalNullable(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-only query the database with an optional nullable <T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> Optional<T>	queryObjectOptionalNullable(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-only query the database with an optional nullable <T> return type, objects are created with the provided factory.
default void	queryRun(int isolationLevel, boolean readOnly, ResultSetRunnable resultSetRunnable, String sql, Object... params)	Query the database, calling the ResultSetRunnable once.
default <Ex extends Throwable> void	queryRun(int isolationLevel, boolean readOnly, Class<? extends Ex> exClass, ResultSetRunnableE<? extends Ex> resultSetRunnable, String sql, Object... params)	Query the database, calling the ResultSetRunnableE once.
default void	queryRun(ResultSetRunnable resultSetRunnable, String sql, Object... params)	Read-only query the database, calling the ResultSetRunnable once.
default <Ex extends Throwable> void	queryRun(Class<? extends Ex> exClass, ResultSetRunnableE<? extends Ex> resultSetRunnable, String sql, Object... params)	Read-only query the database, calling the ResultSetRunnableE once.
default Short	queryShort(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with a Short return type.
default Short	queryShort(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryShort(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default short	queryShort(String sql, Object... params)	Read-only query the database with a required non-null short return type.
default Short	queryShortNullable(String sql, Object... params)	Read-only query the database with a required nullable Short return type.
default Optional<Short>	queryShortOptional(String sql, Object... params)	Read-only query the database with an optional non-null Short return type.
default Optional<Short>	queryShortOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable Short return type.
default String	queryString(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with a String return type.
default String	queryString(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryString(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default String	queryString(String sql, Object... params)	Read-only query the database with a required non-null String return type.
default List<String>	queryStringList(int isolationLevel, boolean readOnly, String sql, Object... params)	Query the database with a List<String> return type.
default List<String>	queryStringList(String sql, Object... params)	Read-only query the database with a List<String> return type.
default String	queryStringNullable(String sql, Object... params)	Read-only query the database with a required nullable String return type.
default Optional<String>	queryStringOptional(String sql, Object... params)	Read-only query the database with an optional non-null String return type.
default Optional<String>	queryStringOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable String return type.
default Timestamp	queryTimestamp(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params)	Query the database with a Timestamp return type.
default Timestamp	queryTimestamp(int isolationLevel, boolean readOnly, boolean rowRequired, String sql, Object... params)	Deprecated, for removal: This API element is subject to removal in a future version. Please use queryTimestamp(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)
default Timestamp	queryTimestamp(String sql, Object... params)	Read-only query the database with a required non-null Timestamp return type.
default Timestamp	queryTimestampNullable(String sql, Object... params)	Read-only query the database with a required nullable Timestamp return type.
default Optional<Timestamp>	queryTimestampOptional(String sql, Object... params)	Read-only query the database with an optional non-null Timestamp return type.
default Optional<Timestamp>	queryTimestampOptionalNullable(String sql, Object... params)	Read-only query the database with an optional nullable Timestamp return type.
default <T> Stream<T>	stream(int isolationLevel, boolean readOnly, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Query the database with a Stream<T> return type, objects are created with the provided factory.
<T, Ex extends Throwable> Stream<T>	stream(int isolationLevel, boolean readOnly, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Query the database with a Stream<T> return type, objects are created with the provided factory.
default <T> Stream<T>	stream(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-only query the database with a Stream<T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> Stream<T>	stream(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-only query the database with a Stream<T> return type, objects are created with the provided factory.
default <T> Stream<Optional<T>>	streamOptional(int isolationLevel, boolean readOnly, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> Stream<Optional<T>>	streamOptional(int isolationLevel, boolean readOnly, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.
default <T> Stream<Optional<T>>	streamOptional(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-only query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> Stream<Optional<T>>	streamOptional(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-only query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.
default <T> Stream<Optional<T>>	streamOptionalUpdate(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-write query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> Stream<Optional<T>>	streamOptionalUpdate(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-write query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.
default Stream<String>	streamString(int isolationLevel, boolean readOnly, String sql, Object... params)	Query the database with a Stream<String> return type.
default Stream<String>	streamString(String sql, Object... params)	Read-only query the database with a Stream<String> return type.
default Stream<String>	streamStringUpdate(String sql, Object... params)	Read-write query the database with a Stream<String> return type.
default <T> Stream<T>	streamUpdate(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-write query the database with a Stream<T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> Stream<T>	streamUpdate(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-write query the database with a Stream<T> return type, objects are created with the provided factory.
default <V> V	transactionCall(DatabaseCallable<? extends V> callable)	Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.
default <V> V	transactionCall(CallableE<? extends V,? extends SQLException> callable)	Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.
<V, Ex extends Throwable> V	transactionCall(Class<? extends Ex> exClass, DatabaseCallableE<? extends V,? extends Ex> callable)	Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.
default <V, Ex extends Throwable> V	transactionCall(Class<? extends Ex> exClass, CallableE<? extends V,? extends Ex> callable)	Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.
default void	transactionRun(DatabaseRunnable runnable)	Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.
default void	transactionRun(RunnableE<? extends SQLException> runnable)	Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.
default <Ex extends Throwable> void	transactionRun(Class<? extends Ex> exClass, DatabaseRunnableE<? extends Ex> runnable)	Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.
default <Ex extends Throwable> void	transactionRun(Class<? extends Ex> exClass, RunnableE<? extends Ex> runnable)	Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.
int	update(String sql, Object... params)	Performs an update on the database and returns the number of rows affected.
default BigDecimal	updateBigDecimal(String sql, Object... params)	Read-write query the database with a required non-null BigDecimal return type.
default BigDecimal	updateBigDecimalNullable(String sql, Object... params)	Read-write query the database with a required nullable BigDecimal return type.
default Optional<BigDecimal>	updateBigDecimalOptional(String sql, Object... params)	Read-write query the database with an optional non-null BigDecimal return type.
default Optional<BigDecimal>	updateBigDecimalOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable BigDecimal return type.
default boolean	updateBoolean(String sql, Object... params)	Read-write query the database with a required non-null boolean return type.
default Boolean	updateBooleanNullable(String sql, Object... params)	Read-write query the database with a required nullable Boolean return type.
default Optional<Boolean>	updateBooleanOptional(String sql, Object... params)	Read-write query the database with an optional non-null Boolean return type.
default Optional<Boolean>	updateBooleanOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable Boolean return type.
default byte[]	updateByteArray(String sql, Object... params)	Read-write query the database with a required non-null byte[] return type.
default byte[]	updateByteArrayNullable(String sql, Object... params)	Read-write query the database with a required nullable byte[] return type.
default Optional<byte[]>	updateByteArrayOptional(String sql, Object... params)	Read-write query the database with an optional non-null byte[] return type.
default Optional<byte[]>	updateByteArrayOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable byte[] return type.
default <T> T	updateCall(ResultSetCallable<? extends T> resultSetCallable, String sql, Object... params)	Read-write query the database, calling the ResultSetCallable once.
default <T, Ex extends Throwable> T	updateCall(Class<? extends Ex> exClass, ResultSetCallableE<? extends T,? extends Ex> resultSetCallable, String sql, Object... params)	Read-write query the database, calling the ResultSetCallableE once.
default <T, C extends Collection<? super T>> C	updateCollection(C collection, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-write query the database with a Collection<T> return type, objects are created with the provided factory.
default <T, C extends Collection<? super T>, Ex extends Throwable> C	updateCollection(C collection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-write query the database with a Collection<T> return type, objects are created with the provided factory.
default Date	updateDate(String sql, Object... params)	Read-write query the database with a required non-null Date return type.
default Date	updateDateNullable(String sql, Object... params)	Read-write query the database with a required nullable Date return type.
default Optional<Date>	updateDateOptional(String sql, Object... params)	Read-write query the database with an optional non-null Date return type.
default Optional<Date>	updateDateOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable Date return type.
default double	updateDouble(String sql, Object... params)	Read-write query the database with a required non-null double return type.
default Double	updateDoubleNullable(String sql, Object... params)	Read-write query the database with a required nullable Double return type.
default Optional<Double>	updateDoubleOptional(String sql, Object... params)	Read-write query the database with an optional non-null Double return type.
default Optional<Double>	updateDoubleOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable Double return type.
default float	updateFloat(String sql, Object... params)	Read-write query the database with a required non-null float return type.
default Float	updateFloatNullable(String sql, Object... params)	Read-write query the database with a required nullable Float return type.
default Optional<Float>	updateFloatOptional(String sql, Object... params)	Read-write query the database with an optional non-null Float return type.
default Optional<Float>	updateFloatOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable Float return type.
default int	updateInt(String sql, Object... params)	Read-write query the database with a required non-null int return type.
default IntList	updateIntList(String sql, Object... params)	Read-write query the database with an IntList return type.
default Integer	updateIntNullable(String sql, Object... params)	Read-write query the database with a required nullable Integer return type.
default Optional<Integer>	updateIntOptional(String sql, Object... params)	Read-write query the database with an optional non-null Integer return type.
default Optional<Integer>	updateIntOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable Integer return type.
default <T> List<T>	updateList(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-write query the database with a List<T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> List<T>	updateList(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-write query the database with a List<T> return type, objects are created with the provided factory.
default long	updateLong(String sql, Object... params)	Read-write query the database with a required non-null long return type.
default LongList	updateLongList(String sql, Object... params)	Read-write query the database with a LongList return type.
default Long	updateLongNullable(String sql, Object... params)	Read-write query the database with a required nullable Long return type.
default Optional<Long>	updateLongOptional(String sql, Object... params)	Read-write query the database with an optional non-null Long return type.
default Optional<Long>	updateLongOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable Long return type.
default <T, C extends Collection<? super T>> C	updateNewCollection(Function<? super Integer,? extends C> newCollection, ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-write query the database with a Collection<T> return type, objects are created with the provided factory.
default <T, C extends Collection<? super T>, Ex extends Throwable> C	updateNewCollection(Function<? super Integer,? extends C> newCollection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-write query the database with a Collection<T> return type, objects are created with the provided factory.
default <T> T	updateObject(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-write query the database with a required non-null <T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> T	updateObject(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-write query the database with a required non-null <T> return type, objects are created with the provided factory.
default <T> T	updateObjectNullable(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-write query the database with a required nullable <T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> T	updateObjectNullable(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-write query the database with a required nullable <T> return type, objects are created with the provided factory.
default <T> Optional<T>	updateObjectOptional(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-write query the database with an optional non-null <T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> Optional<T>	updateObjectOptional(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-write query the database with an optional non-null <T> return type, objects are created with the provided factory.
default <T> Optional<T>	updateObjectOptionalNullable(ObjectFactory<? extends T> objectFactory, String sql, Object... params)	Read-write query the database with an optional nullable <T> return type, objects are created with the provided factory.
default <T, Ex extends Throwable> Optional<T>	updateObjectOptionalNullable(Class<? extends Ex> exClass, ObjectFactoryE<? extends T,? extends Ex> objectFactory, String sql, Object... params)	Read-write query the database with an optional nullable <T> return type, objects are created with the provided factory.
default void	updateRun(ResultSetRunnable resultSetRunnable, String sql, Object... params)	Read-write query the database, calling the ResultSetRunnable once.
default <Ex extends Throwable> void	updateRun(Class<? extends Ex> exClass, ResultSetRunnableE<? extends Ex> resultSetRunnable, String sql, Object... params)	Read-write query the database, calling the ResultSetRunnableE once.
default short	updateShort(String sql, Object... params)	Read-write query the database with a required non-null short return type.
default Short	updateShortNullable(String sql, Object... params)	Read-write query the database with a required nullable Short return type.
default Optional<Short>	updateShortOptional(String sql, Object... params)	Read-write query the database with an optional non-null Short return type.
default Optional<Short>	updateShortOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable Short return type.
default String	updateString(String sql, Object... params)	Read-write query the database with a required non-null String return type.
default List<String>	updateStringList(String sql, Object... params)	Read-write query the database with a List<String> return type.
default String	updateStringNullable(String sql, Object... params)	Read-write query the database with a required nullable String return type.
default Optional<String>	updateStringOptional(String sql, Object... params)	Read-write query the database with an optional non-null String return type.
default Optional<String>	updateStringOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable String return type.
default Timestamp	updateTimestamp(String sql, Object... params)	Read-write query the database with a required non-null Timestamp return type.
default Timestamp	updateTimestampNullable(String sql, Object... params)	Read-write query the database with a required nullable Timestamp return type.
default Optional<Timestamp>	updateTimestampOptional(String sql, Object... params)	Read-write query the database with an optional non-null Timestamp return type.
default Optional<Timestamp>	updateTimestampOptionalNullable(String sql, Object... params)	Read-write query the database with an optional nullable Timestamp return type.

Method Details

isInTransaction

boolean isInTransaction()

Checks if the current thread is in a transaction.

See Also:

• transactionCall(com.aoapps.lang.concurrent.CallableE)
• transactionCall(java.lang.Class, com.aoapps.lang.concurrent.CallableE)
• transactionCall(com.aoapps.dbc.DatabaseCallable)
• transactionCall(java.lang.Class, com.aoapps.dbc.DatabaseCallableE)
• transactionRun(com.aoapps.lang.RunnableE)
• transactionRun(java.lang.Class, com.aoapps.lang.RunnableE)
• transactionRun(com.aoapps.dbc.DatabaseRunnable)
• transactionRun(java.lang.Class, com.aoapps.dbc.DatabaseRunnableE)

transactionCall

default <V> V transactionCall(CallableE<? extends V,? extends SQLException> callable)
                       throws SQLException

Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.

1. Rolls-back the transaction on NoRowException, NullDataException, or ExtraRowException on the outer-most transaction only.
2. Rolls-back the transaction on all other Throwable.

The connection allocated is stored as a ThreadLocal and will be automatically reused if another transaction is performed within this transaction. Any nested transaction will automatically become part of the enclosing transaction. For safety, a nested transaction will still rollback the entire transaction on any exception.

Throws:

SQLException

See Also:

• isInTransaction()

transactionCall

default <V,
Ex extends Throwable> V transactionCall(Class<? extends Ex> exClass,
 CallableE<? extends V,? extends Ex> callable)
                                             throws SQLException,
Ex

Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.

1. Rolls-back the transaction on NoRowException, NullDataException, or ExtraRowException on the outer-most transaction only.
2. Rolls-back the transaction on all other Throwable.

The connection allocated is stored as a ThreadLocal and will be automatically reused if another transaction is performed within this transaction. Any nested transaction will automatically become part of the enclosing transaction. For safety, a nested transaction will still rollback the entire transaction on any exception.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• isInTransaction()

transactionCall

default <V> V transactionCall(DatabaseCallable<? extends V> callable)
                       throws SQLException

Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.

1. Rolls-back the transaction on NoRowException, NullDataException, or ExtraRowException on the outer-most transaction only.
2. Rolls-back the transaction on all other Throwable.

The connection allocated is stored as a ThreadLocal and will be automatically reused if another transaction is performed within this transaction. Any nested transaction will automatically become part of the enclosing transaction. For safety, a nested transaction will still rollback the entire transaction on any exception.

Throws:

SQLException

See Also:

• isInTransaction()

transactionCall

<V,
Ex extends Throwable> V transactionCall(Class<? extends Ex> exClass,
 DatabaseCallableE<? extends V,? extends Ex> callable)
                                     throws SQLException,
Ex

Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.

1. Rolls-back the transaction on NoRowException, NullDataException, or ExtraRowException on the outer-most transaction only.
2. Rolls-back the transaction on all other Throwable.

The connection allocated is stored as a ThreadLocal and will be automatically reused if another transaction is performed within this transaction. Any nested transaction will automatically become part of the enclosing transaction. For safety, a nested transaction will still rollback the entire transaction on any exception.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• isInTransaction()

transactionRun

default void transactionRun(RunnableE<? extends SQLException> runnable)
                     throws SQLException

Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.

1. Rolls-back the transaction on NoRowException, NullDataException, or ExtraRowException on the outer-most transaction only.
2. Rolls-back the transaction on all other Throwable.

The connection allocated is stored as a ThreadLocal and will be automatically reused if another transaction is performed within this transaction. Any nested transaction will automatically become part of the enclosing transaction. For safety, a nested transaction will still rollback the entire transaction on any exception.

Throws:

SQLException

See Also:

• isInTransaction()

transactionRun

default <Ex extends Throwable> void transactionRun(Class<? extends Ex> exClass,
 RunnableE<? extends Ex> runnable)
                                            throws SQLException,
Ex

Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.

1. Rolls-back the transaction on NoRowException, NullDataException, or ExtraRowException on the outer-most transaction only.
2. Rolls-back the transaction on all other Throwable.

The connection allocated is stored as a ThreadLocal and will be automatically reused if another transaction is performed within this transaction. Any nested transaction will automatically become part of the enclosing transaction. For safety, a nested transaction will still rollback the entire transaction on any exception.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• isInTransaction()

transactionRun

default void transactionRun(DatabaseRunnable runnable)
                     throws SQLException

Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.

1. Rolls-back the transaction on NoRowException, NullDataException, or ExtraRowException on the outer-most transaction only.
2. Rolls-back the transaction on all other Throwable.

The connection allocated is stored as a ThreadLocal and will be automatically reused if another transaction is performed within this transaction. Any nested transaction will automatically become part of the enclosing transaction. For safety, a nested transaction will still rollback the entire transaction on any exception.

Throws:

SQLException

See Also:

• isInTransaction()

transactionRun

default <Ex extends Throwable> void transactionRun(Class<? extends Ex> exClass,
 DatabaseRunnableE<? extends Ex> runnable)
                                            throws SQLException,
Ex

Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.

1. Rolls-back the transaction on NoRowException, NullDataException, or ExtraRowException on the outer-most transaction only.
2. Rolls-back the transaction on all other Throwable.

The connection allocated is stored as a ThreadLocal and will be automatically reused if another transaction is performed within this transaction. Any nested transaction will automatically become part of the enclosing transaction. For safety, a nested transaction will still rollback the entire transaction on any exception.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• isInTransaction()

queryBigDecimal

default BigDecimal queryBigDecimal(String sql,
 Object... params)
                            throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null BigDecimal return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryBigDecimalNullable

default BigDecimal queryBigDecimalNullable(String sql,
 Object... params)
                                    throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable BigDecimal return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryBigDecimalOptional

default Optional<BigDecimal> queryBigDecimalOptional(String sql,
 Object... params)
                                              throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null BigDecimal return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryBigDecimalOptionalNullable

default Optional<BigDecimal> queryBigDecimalOptionalNullable(String sql,
 Object... params)
                                                      throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable BigDecimal return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeBigDecimalQuery

@Deprecated(forRemoval=true)
default BigDecimal executeBigDecimalQuery(String sql,
 Object... params)
                                   throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryBigDecimal(java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

updateBigDecimal

default BigDecimal updateBigDecimal(String sql,
 Object... params)
                             throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null BigDecimal return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateBigDecimalNullable

default BigDecimal updateBigDecimalNullable(String sql,
 Object... params)
                                     throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable BigDecimal return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateBigDecimalOptional

default Optional<BigDecimal> updateBigDecimalOptional(String sql,
 Object... params)
                                               throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null BigDecimal return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateBigDecimalOptionalNullable

default Optional<BigDecimal> updateBigDecimalOptionalNullable(String sql,
 Object... params)
                                                       throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable BigDecimal return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeBigDecimalUpdate

@Deprecated(forRemoval=true)
default BigDecimal executeBigDecimalUpdate(String sql,
 Object... params)
                                    throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateBigDecimal(java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryBigDecimal

default BigDecimal queryBigDecimal(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                            throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a BigDecimal return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryBigDecimal

@Deprecated(forRemoval=true)
default BigDecimal queryBigDecimal(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                            throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryBigDecimal(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

executeBigDecimalQuery

@Deprecated(forRemoval=true)
default BigDecimal executeBigDecimalQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                                   throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryBigDecimal(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryBoolean

default boolean queryBoolean(String sql,
 Object... params)
                      throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null boolean return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryBooleanNullable

default Boolean queryBooleanNullable(String sql,
 Object... params)
                              throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable Boolean return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryBooleanOptional

default Optional<Boolean> queryBooleanOptional(String sql,
 Object... params)
                                        throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null Boolean return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional#empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryBooleanOptionalNullable

default Optional<Boolean> queryBooleanOptionalNullable(String sql,
 Object... params)
                                                throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable Boolean return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeBooleanQuery

@Deprecated(forRemoval=true)
default boolean executeBooleanQuery(String sql,
 Object... params)
                             throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryBoolean(java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

updateBoolean

default boolean updateBoolean(String sql,
 Object... params)
                       throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null boolean return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateBooleanNullable

default Boolean updateBooleanNullable(String sql,
 Object... params)
                               throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable Boolean return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateBooleanOptional

default Optional<Boolean> updateBooleanOptional(String sql,
 Object... params)
                                         throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null Boolean return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional#empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateBooleanOptionalNullable

default Optional<Boolean> updateBooleanOptionalNullable(String sql,
 Object... params)
                                                 throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable Boolean return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeBooleanUpdate

@Deprecated(forRemoval=true)
default boolean executeBooleanUpdate(String sql,
 Object... params)
                              throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateBoolean(java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

queryBoolean

default Boolean queryBoolean(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                      throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a Boolean return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryBoolean

@Deprecated(forRemoval=true)
default Boolean queryBoolean(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                      throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryBoolean(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

executeBooleanQuery

@Deprecated(forRemoval=true)
default Boolean executeBooleanQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                             throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryBoolean(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

queryByteArray

default byte[] queryByteArray(String sql,
 Object... params)
                       throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null byte[] return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryByteArrayNullable

default byte[] queryByteArrayNullable(String sql,
 Object... params)
                               throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable byte[] return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryByteArrayOptional

default Optional<byte[]> queryByteArrayOptional(String sql,
 Object... params)
                                         throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null byte[] return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryByteArrayOptionalNullable

default Optional<byte[]> queryByteArrayOptionalNullable(String sql,
 Object... params)
                                                 throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable byte[] return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeByteArrayQuery

@Deprecated(forRemoval=true)
default byte[] executeByteArrayQuery(String sql,
 Object... params)
                              throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryByteArray(java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

updateByteArray

default byte[] updateByteArray(String sql,
 Object... params)
                        throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null byte[] return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateByteArrayNullable

default byte[] updateByteArrayNullable(String sql,
 Object... params)
                                throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable byte[] return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateByteArrayOptional

default Optional<byte[]> updateByteArrayOptional(String sql,
 Object... params)
                                          throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null byte[] return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateByteArrayOptionalNullable

default Optional<byte[]> updateByteArrayOptionalNullable(String sql,
 Object... params)
                                                  throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable byte[] return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeByteArrayUpdate

@Deprecated(forRemoval=true)
default byte[] executeByteArrayUpdate(String sql,
 Object... params)
                               throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateByteArray(java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryByteArray

default byte[] queryByteArray(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                       throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a byte[] return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryByteArray

@Deprecated(forRemoval=true)
default byte[] queryByteArray(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                       throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryByteArray(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

executeByteArrayQuery

@Deprecated(forRemoval=true)
default byte[] executeByteArrayQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                              throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryByteArray(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryDate

default Date queryDate(String sql,
 Object... params)
                throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null Date return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryDateNullable

default Date queryDateNullable(String sql,
 Object... params)
                        throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable Date return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryDateOptional

default Optional<Date> queryDateOptional(String sql,
 Object... params)
                                  throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null Date return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryDateOptionalNullable

default Optional<Date> queryDateOptionalNullable(String sql,
 Object... params)
                                          throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable Date return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeDateQuery

@Deprecated(forRemoval=true)
default Date executeDateQuery(String sql,
 Object... params)
                       throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryDate(java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

updateDate

default Date updateDate(String sql,
 Object... params)
                 throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null Date return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateDateNullable

default Date updateDateNullable(String sql,
 Object... params)
                         throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable Date return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateDateOptional

default Optional<Date> updateDateOptional(String sql,
 Object... params)
                                   throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null Date return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateDateOptionalNullable

default Optional<Date> updateDateOptionalNullable(String sql,
 Object... params)
                                           throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable Date return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeDateUpdate

@Deprecated(forRemoval=true)
default Date executeDateUpdate(String sql,
 Object... params)
                        throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateDate(java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryDate

default Date queryDate(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a Date return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryDate

@Deprecated(forRemoval=true)
default Date queryDate(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryDate(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

executeDateQuery

@Deprecated(forRemoval=true)
default Date executeDateQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                       throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryDate(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryDouble

default double queryDouble(String sql,
 Object... params)
                    throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null double return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryDoubleNullable

default Double queryDoubleNullable(String sql,
 Object... params)
                            throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable Double return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryDoubleOptional

default Optional<Double> queryDoubleOptional(String sql,
 Object... params)
                                      throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null Double return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryDoubleOptionalNullable

default Optional<Double> queryDoubleOptionalNullable(String sql,
 Object... params)
                                              throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable Double return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

updateDouble

default double updateDouble(String sql,
 Object... params)
                     throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null double return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateDoubleNullable

default Double updateDoubleNullable(String sql,
 Object... params)
                             throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable Double return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateDoubleOptional

default Optional<Double> updateDoubleOptional(String sql,
 Object... params)
                                       throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null Double return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateDoubleOptionalNullable

default Optional<Double> updateDoubleOptionalNullable(String sql,
 Object... params)
                                               throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable Double return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

queryDouble

default Double queryDouble(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                    throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a Double return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryDouble

@Deprecated(forRemoval=true)
default Double queryDouble(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                    throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryDouble(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

doubleStream

default DoubleStream doubleStream(String sql,
 Object... params)
                           throws NullDataException,
SQLException

Read-only query the database with a DoubleStream return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

NullDataException - When has a SQL NULL value.

SQLException

See Also:

• doubleStreamUpdate(java.lang.String, java.lang.Object...)

doubleStreamUpdate

default DoubleStream doubleStreamUpdate(String sql,
 Object... params)
                                 throws NullDataException,
SQLException

Read-write query the database with a DoubleStream return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

NullDataException - When has a SQL NULL value.

SQLException

See Also:

• doubleStream(java.lang.String, java.lang.Object...)

doubleStream

DoubleStream doubleStream(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
                   throws NullDataException,
SQLException

Query the database with a DoubleStream return type.

Throws:

NullDataException - When has a SQL NULL value.

SQLException

queryFloat

default float queryFloat(String sql,
 Object... params)
                  throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null float return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryFloatNullable

default Float queryFloatNullable(String sql,
 Object... params)
                          throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable Float return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryFloatOptional

default Optional<Float> queryFloatOptional(String sql,
 Object... params)
                                    throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null Float return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryFloatOptionalNullable

default Optional<Float> queryFloatOptionalNullable(String sql,
 Object... params)
                                            throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable Float return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

updateFloat

default float updateFloat(String sql,
 Object... params)
                   throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null float return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateFloatNullable

default Float updateFloatNullable(String sql,
 Object... params)
                           throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable Float return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateFloatOptional

default Optional<Float> updateFloatOptional(String sql,
 Object... params)
                                     throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null Float return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateFloatOptionalNullable

default Optional<Float> updateFloatOptionalNullable(String sql,
 Object... params)
                                             throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable Float return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

queryFloat

default Float queryFloat(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                  throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a Float return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryFloat

@Deprecated(forRemoval=true)
default Float queryFloat(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                  throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryFloat(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

queryInt

default int queryInt(String sql,
 Object... params)
              throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null int return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryIntNullable

default Integer queryIntNullable(String sql,
 Object... params)
                          throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable Integer return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryIntOptional

default Optional<Integer> queryIntOptional(String sql,
 Object... params)
                                    throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null Integer return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryIntOptionalNullable

default Optional<Integer> queryIntOptionalNullable(String sql,
 Object... params)
                                            throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable Integer return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeIntQuery

@Deprecated(forRemoval=true)
default int executeIntQuery(String sql,
 Object... params)
                     throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryInt(java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

updateInt

default int updateInt(String sql,
 Object... params)
               throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null int return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateIntNullable

default Integer updateIntNullable(String sql,
 Object... params)
                           throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable Integer return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateIntOptional

default Optional<Integer> updateIntOptional(String sql,
 Object... params)
                                     throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null Integer return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateIntOptionalNullable

default Optional<Integer> updateIntOptionalNullable(String sql,
 Object... params)
                                             throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable Integer return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeIntUpdate

@Deprecated(forRemoval=true)
default int executeIntUpdate(String sql,
 Object... params)
                      throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateInt(java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

queryInt

default Integer queryInt(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                  throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with an Integer return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryInt

@Deprecated(forRemoval=true)
default Integer queryInt(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                  throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryInt(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

executeIntQuery

@Deprecated(forRemoval=true)
default Integer executeIntQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                         throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryInt(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

queryIntList

default IntList queryIntList(String sql,
 Object... params)
                      throws NullDataException,
SQLException

Read-only query the database with an IntList return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

NullDataException - When has a SQL NULL value.

SQLException

See Also:

• updateIntList(java.lang.String, java.lang.Object...)

executeIntListQuery

@Deprecated(forRemoval=true)
default IntList executeIntListQuery(String sql,
 Object... params)
                             throws NullDataException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryIntList(java.lang.String, java.lang.Object...)

Throws:

NullDataException

SQLException

updateIntList

default IntList updateIntList(String sql,
 Object... params)
                       throws NullDataException,
SQLException

Read-write query the database with an IntList return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

NullDataException - When has a SQL NULL value.

SQLException

See Also:

• queryIntList(java.lang.String, java.lang.Object...)

executeIntListUpdate

@Deprecated(forRemoval=true)
default IntList executeIntListUpdate(String sql,
 Object... params)
                              throws NullDataException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateIntList(java.lang.String, java.lang.Object...)

Throws:

NullDataException

SQLException

queryIntList

default IntList queryIntList(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
                      throws NullDataException,
SQLException

Query the database with an IntList return type.

Throws:

NullDataException - When has a SQL NULL value.

SQLException

executeIntListQuery

@Deprecated(forRemoval=true)
default IntList executeIntListQuery(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
                             throws NullDataException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryIntList(int, boolean, java.lang.String, java.lang.Object...)

Throws:

NullDataException

SQLException

intStream

default IntStream intStream(String sql,
 Object... params)
                     throws NullDataException,
SQLException

Read-only query the database with an IntStream return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

NullDataException - When has a SQL NULL value.

SQLException

See Also:

• intStreamUpdate(java.lang.String, java.lang.Object...)

intStreamUpdate

default IntStream intStreamUpdate(String sql,
 Object... params)
                           throws NullDataException,
SQLException

Read-write query the database with an IntStream return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

NullDataException - When has a SQL NULL value.

SQLException

See Also:

• intStream(java.lang.String, java.lang.Object...)

intStream

IntStream intStream(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
             throws NullDataException,
SQLException

Query the database with an IntStream return type.

Throws:

NullDataException - When has a SQL NULL value.

SQLException

queryLong

default long queryLong(String sql,
 Object... params)
                throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null long return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryLongNullable

default Long queryLongNullable(String sql,
 Object... params)
                        throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable Long return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryLongOptional

default Optional<Long> queryLongOptional(String sql,
 Object... params)
                                  throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null Long return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryLongOptionalNullable

default Optional<Long> queryLongOptionalNullable(String sql,
 Object... params)
                                          throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable Long return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeLongQuery

@Deprecated(forRemoval=true)
default long executeLongQuery(String sql,
 Object... params)
                       throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryLong(java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

updateLong

default long updateLong(String sql,
 Object... params)
                 throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null long return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateLongNullable

default Long updateLongNullable(String sql,
 Object... params)
                         throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable Long return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateLongOptional

default Optional<Long> updateLongOptional(String sql,
 Object... params)
                                   throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null Long return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateLongOptionalNullable

default Optional<Long> updateLongOptionalNullable(String sql,
 Object... params)
                                           throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable Long return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeLongUpdate

@Deprecated(forRemoval=true)
default long executeLongUpdate(String sql,
 Object... params)
                        throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateLong(java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

queryLong

default Long queryLong(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a Long return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryLong

@Deprecated(forRemoval=true)
default Long queryLong(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryLong(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

executeLongQuery

@Deprecated(forRemoval=true)
default Long executeLongQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                       throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryLong(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

queryLongList

default LongList queryLongList(String sql,
 Object... params)
                        throws NullDataException,
SQLException

Read-only query the database with a LongList return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

NullDataException - When has a SQL NULL value.

SQLException

See Also:

• updateLongList(java.lang.String, java.lang.Object...)

executeLongListQuery

@Deprecated(forRemoval=true)
default LongList executeLongListQuery(String sql,
 Object... params)
                               throws NullDataException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryLongList(java.lang.String, java.lang.Object...)

Throws:

NullDataException

SQLException

updateLongList

default LongList updateLongList(String sql,
 Object... params)
                         throws NullDataException,
SQLException

Read-write query the database with a LongList return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

NullDataException - When has a SQL NULL value.

SQLException

See Also:

• queryLongList(java.lang.String, java.lang.Object...)

executeLongListUpdate

@Deprecated(forRemoval=true)
default LongList executeLongListUpdate(String sql,
 Object... params)
                                throws NullDataException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateLongList(java.lang.String, java.lang.Object...)

Throws:

NullDataException

SQLException

queryLongList

default LongList queryLongList(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
                        throws NullDataException,
SQLException

Query the database with a LongList return type.

Throws:

NullDataException - When has a SQL NULL value.

SQLException

executeLongListQuery

@Deprecated(forRemoval=true)
default LongList executeLongListQuery(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
                               throws NullDataException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryLongList(int, boolean, java.lang.String, java.lang.Object...)

Throws:

NullDataException

SQLException

longStream

default LongStream longStream(String sql,
 Object... params)
                       throws NullDataException,
SQLException

Read-only query the database with a LongStream return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

NullDataException - When has a SQL NULL value.

SQLException

See Also:

• longStreamUpdate(java.lang.String, java.lang.Object...)

longStreamUpdate

default LongStream longStreamUpdate(String sql,
 Object... params)
                             throws NullDataException,
SQLException

Read-write query the database with a LongStream return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

NullDataException - When has a SQL NULL value.

SQLException

See Also:

• longStream(java.lang.String, java.lang.Object...)

longStream

LongStream longStream(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
               throws NullDataException,
SQLException

Query the database with a LongStream return type.

Throws:

NullDataException - When has a SQL NULL value.

SQLException

executeObjectQuery

@Deprecated(forRemoval=true)
default <T> T executeObjectQuery(Class<T> clazz,
 String sql,
 Object... params)
                          throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.

Read-only query the database with a required <T> return type. Class <T> must have a constructor that takes a single argument of ResultSet.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true

Returns:

The value or null when row with null value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

See Also:

• executeObjectUpdate(java.lang.Class, java.lang.String, java.lang.Object...)

executeObjectUpdate

@Deprecated(forRemoval=true)
default <T> T executeObjectUpdate(Class<T> clazz,
 String sql,
 Object... params)
                           throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.

Read-write query the database with a required <T> return type. Class <T> must have a constructor that takes a single argument of ResultSet.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true

Returns:

The value or null when row with null value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

See Also:

• executeObjectQuery(java.lang.Class, java.lang.String, java.lang.Object...)

executeObjectQuery

@Deprecated(forRemoval=true)
default <T> T executeObjectQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 Class<T> clazz,
 String sql,
 Object... params)
                          throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryObject(int, boolean, boolean, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.

Query the database with a <T> return type. Class <T> must have a constructor that takes a single argument of ResultSet.

Returns:

The value or null when no row and row not required, or when row with null value.

Throws:

NoRowException - When has no row and rowRequired.

ExtraRowException - When has more than one row.

SQLException

queryObject

default <T> T queryObject(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                   throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with objectFactory returning null.

ExtraRowException - When has more than one row.

SQLException

queryObjectNullable

default <T> T queryObjectNullable(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                           throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with objectFactory returning null.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryObjectOptional

default <T> Optional<T> queryObjectOptional(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                     throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with objectFactory returning null.

ExtraRowException - When has more than one row.

SQLException

queryObjectOptionalNullable

default <T> Optional<T> queryObjectOptionalNullable(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                             throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with objectFactory returning null.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeObjectQuery

@Deprecated(forRemoval=true)
default <T> T executeObjectQuery(ObjectFactory<T> objectFactory,
 String sql,
 Object... params)
                          throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

updateObject

default <T> T updateObject(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                    throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with objectFactory returning null.

ExtraRowException - When has more than one row.

SQLException

updateObjectNullable

default <T> T updateObjectNullable(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                            throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with objectFactory returning null.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateObjectOptional

default <T> Optional<T> updateObjectOptional(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                      throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with objectFactory returning null.

ExtraRowException - When has more than one row.

SQLException

updateObjectOptionalNullable

default <T> Optional<T> updateObjectOptionalNullable(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                              throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with objectFactory returning null.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeObjectUpdate

@Deprecated(forRemoval=true)
default <T> T executeObjectUpdate(ObjectFactory<T> objectFactory,
 String sql,
 Object... params)
                           throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryObject

default <T> T queryObject(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                   throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a <T> return type, objects are created with the provided factory.

Returns:

The value, null when no row and !rowRequired, or null when row with objectFactory returning null value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with objectFactory returning null and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryObject

@Deprecated(forRemoval=true)
default <T> T queryObject(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                   throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryObject(int, boolean, boolean, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

executeObjectQuery

@Deprecated(forRemoval=true)
default <T> T executeObjectQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 ObjectFactory<T> objectFactory,
 String sql,
 Object... params)
                          throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryObject(int, boolean, boolean, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryObject

default <T,
Ex extends Throwable> T queryObject(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                         throws NoRowException,
NullDataException,
ExtraRowException,
SQLException,
Ex

Read-only query the database with a required non-null <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with objectFactory returning null.

ExtraRowException - When has more than one row.

SQLException

Ex

queryObjectNullable

default <T,
Ex extends Throwable> T queryObjectNullable(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                                 throws NoRowException,
ExtraRowException,
SQLException,
Ex

Read-only query the database with a required nullable <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

The value or null when row with objectFactory returning null.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

Ex

queryObjectOptional

default <T,
Ex extends Throwable> Optional<T> queryObjectOptional(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                                           throws NullDataException,
ExtraRowException,
SQLException,
Ex

Read-only query the database with an optional non-null <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with objectFactory returning null.

ExtraRowException - When has more than one row.

SQLException

Ex

queryObjectOptionalNullable

default <T,
Ex extends Throwable> Optional<T> queryObjectOptionalNullable(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                                                   throws ExtraRowException,
SQLException,
Ex

Read-only query the database with an optional nullable <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

The value or Optional.empty() when either no row or row with objectFactory returning null.

Throws:

ExtraRowException - When has more than one row.

SQLException

Ex

executeObjectQuery

@Deprecated(forRemoval=true)
default <T,
Ex extends Exception> T executeObjectQuery(Class<Ex> exClass,
 ObjectFactoryE<T,Ex> objectFactory,
 String sql,
 Object... params)
                                                throws NoRowException,
ExtraRowException,
SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryObject(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

NoRowException

ExtraRowException

SQLException

Ex

updateObject

default <T,
Ex extends Throwable> T updateObject(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                          throws NoRowException,
NullDataException,
ExtraRowException,
SQLException,
Ex

Read-write query the database with a required non-null <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with objectFactory returning null.

ExtraRowException - When has more than one row.

SQLException

Ex

updateObjectNullable

default <T,
Ex extends Throwable> T updateObjectNullable(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                                  throws NoRowException,
ExtraRowException,
SQLException,
Ex

Read-write query the database with a required nullable <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

The value or null when row with objectFactory returning null.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

Ex

updateObjectOptional

default <T,
Ex extends Throwable> Optional<T> updateObjectOptional(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                                            throws NullDataException,
ExtraRowException,
SQLException,
Ex

Read-write query the database with an optional non-null <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with objectFactory returning null.

ExtraRowException - When has more than one row.

SQLException

Ex

updateObjectOptionalNullable

default <T,
Ex extends Throwable> Optional<T> updateObjectOptionalNullable(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                                                    throws ExtraRowException,
SQLException,
Ex

Read-write query the database with an optional nullable <T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

The value or Optional.empty() when either no row or row with objectFactory returning null.

Throws:

ExtraRowException - When has more than one row.

SQLException

Ex

executeObjectUpdate

@Deprecated(forRemoval=true)
default <T,
Ex extends Exception> T executeObjectUpdate(Class<Ex> exClass,
 ObjectFactoryE<T,Ex> objectFactory,
 String sql,
 Object... params)
                                                 throws NoRowException,
ExtraRowException,
SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateObject(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

NoRowException

ExtraRowException

SQLException

Ex

queryObject

default <T,
Ex extends Throwable> T queryObject(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                         throws NoRowException,
NullDataException,
ExtraRowException,
SQLException,
Ex

Query the database with a <T> return type, objects are created with the provided factory.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

The value, null when no row and !rowRequired, or null when row with objectFactory returning null value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with objectFactory returning null and !nullable.

ExtraRowException - When has more than one row.

SQLException

Ex

queryObject

@Deprecated(forRemoval=true)
default <T,
Ex extends Throwable> T queryObject(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                         throws NoRowException,
ExtraRowException,
SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryObject(int, boolean, boolean, boolean, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

Ex

executeObjectQuery

@Deprecated(forRemoval=true)
default <T,
Ex extends Exception> T executeObjectQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 Class<Ex> exClass,
 ObjectFactoryE<T,Ex> objectFactory,
 String sql,
 Object... params)
                                                throws NoRowException,
ExtraRowException,
SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryObject(int, boolean, boolean, boolean, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

NoRowException

ExtraRowException

SQLException

Ex

executeObjectListQuery

@Deprecated(forRemoval=true)
default <T> List<T> executeObjectListQuery(Class<T> clazz,
 String sql,
 Object... params)
                                    throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.

Read-only query the database with a List<T> return type. Class <T> must have a constructor that takes a single argument of ResultSet.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Returns:

An unmodifiable list

Throws:

SQLException

See Also:

• executeObjectListUpdate(java.lang.Class, java.lang.String, java.lang.Object...)

executeObjectListUpdate

@Deprecated(forRemoval=true)
default <T> List<T> executeObjectListUpdate(Class<T> clazz,
 String sql,
 Object... params)
                                     throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.

Read-write query the database with a List<T> return type. Class <T> must have a constructor that takes a single argument of ResultSet.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Returns:

An unmodifiable list

Throws:

SQLException

See Also:

• executeObjectListQuery(java.lang.Class, java.lang.String, java.lang.Object...)

executeObjectListQuery

@Deprecated(forRemoval=true)
default <T> List<T> executeObjectListQuery(int isolationLevel,
 boolean readOnly,
 Class<T> clazz,
 String sql,
 Object... params)
                                    throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryList(int, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.

Query the database with a List<T> return type. Class <T> must have a constructor that takes a single argument of ResultSet.

Returns:

An unmodifiable list

Throws:

SQLException

queryList

default <T> List<T> queryList(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                       throws SQLException

Read-only query the database with a List<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Returns:

An unmodifiable list

Throws:

SQLException

See Also:

• updateList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

executeObjectListQuery

@Deprecated(forRemoval=true)
default <T> List<T> executeObjectListQuery(ObjectFactory<T> objectFactory,
 String sql,
 Object... params)
                                    throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

Throws:

SQLException

updateList

default <T> List<T> updateList(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                        throws SQLException

Read-write query the database with a List<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Returns:

An unmodifiable list

Throws:

SQLException

See Also:

• queryList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

executeObjectListUpdate

@Deprecated(forRemoval=true)
default <T> List<T> executeObjectListUpdate(ObjectFactory<T> objectFactory,
 String sql,
 Object... params)
                                     throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

Throws:

SQLException

queryList

default <T> List<T> queryList(int isolationLevel,
 boolean readOnly,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                       throws SQLException

Query the database with a List<T> return type, objects are created with the provided factory.

Returns:

An unmodifiable list

Throws:

SQLException

executeObjectListQuery

@Deprecated(forRemoval=true)
default <T> List<T> executeObjectListQuery(int isolationLevel,
 boolean readOnly,
 ObjectFactory<T> objectFactory,
 String sql,
 Object... params)
                                    throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryList(int, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

Throws:

SQLException

queryList

default <T,
Ex extends Throwable> List<T> queryList(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                             throws SQLException,
Ex

Read-only query the database with a List<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

An unmodifiable list

Throws:

SQLException

Ex

See Also:

• updateList(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

executeObjectListQuery

@Deprecated(forRemoval=true)
default <T,
Ex extends Exception> List<T> executeObjectListQuery(Class<Ex> exClass,
 ObjectFactoryE<T,Ex> objectFactory,
 String sql,
 Object... params)
                                                          throws SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryList(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

updateList

default <T,
Ex extends Throwable> List<T> updateList(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                              throws SQLException,
Ex

Read-write query the database with a List<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

An unmodifiable list

Throws:

SQLException

Ex

See Also:

• queryList(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

executeObjectListUpdate

@Deprecated(forRemoval=true)
default <T,
Ex extends Exception> List<T> executeObjectListUpdate(Class<Ex> exClass,
 ObjectFactoryE<T,Ex> objectFactory,
 String sql,
 Object... params)
                                                           throws SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateList(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

queryList

default <T,
Ex extends Throwable> List<T> queryList(int isolationLevel,
 boolean readOnly,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                             throws SQLException,
Ex

Query the database with a List<T> return type, objects are created with the provided factory.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Returns:

An unmodifiable list

Throws:

SQLException

Ex

executeObjectListQuery

@Deprecated(forRemoval=true)
default <T,
Ex extends Exception> List<T> executeObjectListQuery(int isolationLevel,
 boolean readOnly,
 Class<Ex> exClass,
 ObjectFactoryE<T,Ex> objectFactory,
 String sql,
 Object... params)
                                                          throws SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryList(int, boolean, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

stream

default <T> Stream<T> stream(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                      throws SQLException

Read-only query the database with a Stream<T> return type, objects are created with the provided factory.

When the factory is nullable, the stream may contain null elements. Otherwise, will have the characteristic Spliterator.NONNULL.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

SQLException

See Also:

• streamUpdate(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

streamUpdate

default <T> Stream<T> streamUpdate(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                            throws SQLException

Read-write query the database with a Stream<T> return type, objects are created with the provided factory.

When the factory is nullable, the stream may contain null elements. Otherwise, will have the characteristic Spliterator.NONNULL.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

SQLException

See Also:

• stream(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

stream

default <T> Stream<T> stream(int isolationLevel,
 boolean readOnly,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                      throws SQLException

Query the database with a Stream<T> return type, objects are created with the provided factory.

When the factory is nullable, the stream may contain null elements. Otherwise, will have the characteristic Spliterator.NONNULL.

Throws:

SQLException

stream

default <T,
Ex extends Throwable> Stream<T> stream(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                            throws SQLException,
Ex

Read-only query the database with a Stream<T> return type, objects are created with the provided factory.

When the factory is nullable, the stream may contain null elements. Otherwise, will have the characteristic Spliterator.NONNULL.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• streamUpdate(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

streamUpdate

default <T,
Ex extends Throwable> Stream<T> streamUpdate(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                                  throws SQLException,
Ex

Read-write query the database with a Stream<T> return type, objects are created with the provided factory.

When the factory is nullable, the stream may contain null elements. Otherwise, will have the characteristic Spliterator.NONNULL.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• stream(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

stream

<T,
Ex extends Throwable> Stream<T> stream(int isolationLevel,
 boolean readOnly,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                    throws SQLException,
Ex

Query the database with a Stream<T> return type, objects are created with the provided factory.

When the factory is nullable, the stream may contain null elements. Otherwise, will have the characteristic Spliterator.NONNULL.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

streamOptional

default <T> Stream<Optional<T>> streamOptional(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                        throws SQLException

Read-only query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.

Always has the characteristic Spliterator.NONNULL.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

SQLException

See Also:

• streamOptionalUpdate(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

streamOptionalUpdate

default <T> Stream<Optional<T>> streamOptionalUpdate(ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                              throws SQLException

Read-write query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.

Always has the characteristic Spliterator.NONNULL.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

SQLException

See Also:

• streamOptional(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

streamOptional

default <T> Stream<Optional<T>> streamOptional(int isolationLevel,
 boolean readOnly,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                        throws SQLException

Query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.

Always has the characteristic Spliterator.NONNULL.

Throws:

SQLException

streamOptional

default <T,
Ex extends Throwable>
Stream<Optional<T>> streamOptional(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                            throws SQLException,
Ex

Read-only query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.

Always has the characteristic Spliterator.NONNULL.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• streamOptionalUpdate(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

streamOptionalUpdate

default <T,
Ex extends Throwable>
Stream<Optional<T>> streamOptionalUpdate(Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                                  throws SQLException,
Ex

Read-write query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.

Always has the characteristic Spliterator.NONNULL.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• streamOptional(java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

streamOptional

default <T,
Ex extends Throwable>
Stream<Optional<T>> streamOptional(int isolationLevel,
 boolean readOnly,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
                            throws SQLException,
Ex

Query the database with a Stream<Optional<T>> return type, objects are created with the provided factory.

Always has the characteristic Spliterator.NONNULL.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

executeObjectCollectionQuery

@Deprecated(forRemoval=true)
default <T,
C extends Collection<? super T>> C executeObjectCollectionQuery(C collection,
 Class<T> clazz,
 String sql,
 Object... params)
                                                                     throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.

Read-only query the database with a Collection<T> return type. Class <T> must have a constructor that takes a single argument of ResultSet.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

SQLException

See Also:

• executeObjectCollectionUpdate(java.util.Collection, java.lang.Class, java.lang.String, java.lang.Object...)

executeObjectCollectionUpdate

@Deprecated(forRemoval=true)
default <T,
C extends Collection<? super T>> C executeObjectCollectionUpdate(C collection,
 Class<T> clazz,
 String sql,
 Object... params)
                                                                      throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.

Read-write query the database with a Collection<T> return type. Class <T> must have a constructor that takes a single argument of ResultSet.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

SQLException

See Also:

• executeObjectCollectionQuery(java.util.Collection, java.lang.Class, java.lang.String, java.lang.Object...)

executeObjectCollectionQuery

@Deprecated(forRemoval=true)
default <T,
C extends Collection<? super T>> C executeObjectCollectionQuery(int isolationLevel,
 boolean readOnly,
 C collection,
 Class<T> clazz,
 String sql,
 Object... params)
                                                                     throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryCollection(int, boolean, java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with a constructor lambda Class::new.

Query the database with a Collection<T> return type. Class <T> must have a constructor that takes a single argument of ResultSet.

Throws:

SQLException

queryCollection

default <T,
C extends Collection<? super T>> C queryCollection(C collection,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                                        throws SQLException

Read-only query the database with a Collection<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

SQLException

See Also:

• updateCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

executeObjectCollectionQuery

@Deprecated(forRemoval=true)
default <T,
C extends Collection<? super T>> C executeObjectCollectionQuery(C collection,
 ObjectFactory<T> objectFactory,
 String sql,
 Object... params)
                                                                     throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

Throws:

SQLException

updateCollection

default <T,
C extends Collection<? super T>> C updateCollection(C collection,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                                         throws SQLException

Read-write query the database with a Collection<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

SQLException

See Also:

• queryCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

executeObjectCollectionUpdate

@Deprecated(forRemoval=true)
default <T,
C extends Collection<? super T>> C executeObjectCollectionUpdate(C collection,
 ObjectFactory<T> objectFactory,
 String sql,
 Object... params)
                                                                      throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

Throws:

SQLException

queryCollection

default <T,
C extends Collection<? super T>> C queryCollection(int isolationLevel,
 boolean readOnly,
 C collection,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                                        throws SQLException

Query the database with a Collection<T> return type, objects are created with the provided factory.

Throws:

SQLException

executeObjectCollectionQuery

@Deprecated(forRemoval=true)
default <T,
C extends Collection<? super T>> C executeObjectCollectionQuery(int isolationLevel,
 boolean readOnly,
 C collection,
 ObjectFactory<T> objectFactory,
 String sql,
 Object... params)
                                                                     throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryCollection(int, boolean, java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

Throws:

SQLException

queryCollection

default <T,
C extends Collection<? super T>,
Ex extends Throwable>
C queryCollection(C collection,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
           throws SQLException,
Ex

Read-only query the database with a Collection<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• updateCollection(java.util.Collection, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

executeObjectCollectionQuery

@Deprecated(forRemoval=true)
default <T,
C extends Collection<? super T>,
Ex extends Exception>
C executeObjectCollectionQuery(C collection,
 Class<Ex> exClass,
 ObjectFactoryE<T,Ex> objectFactory,
 String sql,
 Object... params)
                        throws SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryCollection(java.util.Collection, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

updateCollection

default <T,
C extends Collection<? super T>,
Ex extends Throwable>
C updateCollection(C collection,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
            throws SQLException,
Ex

Read-write query the database with a Collection<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• queryCollection(java.util.Collection, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

executeObjectCollectionUpdate

@Deprecated(forRemoval=true)
default <T,
C extends Collection<? super T>,
Ex extends Exception>
C executeObjectCollectionUpdate(C collection,
 Class<Ex> exClass,
 ObjectFactoryE<T,Ex> objectFactory,
 String sql,
 Object... params)
                         throws SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateCollection(java.util.Collection, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

queryCollection

default <T,
C extends Collection<? super T>,
Ex extends Throwable>
C queryCollection(int isolationLevel,
 boolean readOnly,
 C collection,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
           throws SQLException,
Ex

Query the database with a Collection<T> return type, objects are created with the provided factory.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

executeObjectCollectionQuery

@Deprecated(forRemoval=true)
default <T,
C extends Collection<? super T>,
Ex extends Exception>
C executeObjectCollectionQuery(int isolationLevel,
 boolean readOnly,
 C collection,
 Class<Ex> exClass,
 ObjectFactoryE<T,Ex> objectFactory,
 String sql,
 Object... params)
                        throws SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryCollection(int, boolean, java.util.Collection, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

queryNewCollection

default <T,
C extends Collection<? super T>> C queryNewCollection(Function<? super Integer,? extends C> newCollection,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                                           throws SQLException

Read-only query the database with a Collection<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Parameters:

newCollection - given the row count, or null when unknown, creates the new collection

Throws:

SQLException

See Also:

• updateNewCollection(java.util.function.Function, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)

updateNewCollection

default <T,
C extends Collection<? super T>> C updateNewCollection(Function<? super Integer,? extends C> newCollection,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                                            throws SQLException

Read-write query the database with a Collection<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Parameters:

newCollection - given the row count, or null when unknown, creates the new collection

Throws:

SQLException

See Also:

• queryNewCollection(java.util.function.Function, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object[])

queryNewCollection

default <T,
C extends Collection<? super T>> C queryNewCollection(int isolationLevel,
 boolean readOnly,
 Function<? super Integer,? extends C> newCollection,
 ObjectFactory<? extends T> objectFactory,
 String sql,
 Object... params)
                                                           throws SQLException

Query the database with a Collection<T> return type, objects are created with the provided factory.

Parameters:

newCollection - given the row count, or null when unknown, creates the new collection

Throws:

SQLException

queryNewCollection

default <T,
C extends Collection<? super T>,
Ex extends Throwable>
C queryNewCollection(Function<? super Integer,? extends C> newCollection,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
              throws SQLException,
Ex

Read-only query the database with a Collection<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Parameters:

newCollection - given the row count, or null when unknown, creates the new collection

Throws:

SQLException

Ex

See Also:

• updateNewCollection(java.util.function.Function, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object...)

updateNewCollection

default <T,
C extends Collection<? super T>,
Ex extends Throwable>
C updateNewCollection(Function<? super Integer,? extends C> newCollection,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
               throws SQLException,
Ex

Read-write query the database with a Collection<T> return type, objects are created with the provided factory.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Parameters:

newCollection - given the row count, or null when unknown, creates the new collection

Throws:

SQLException

Ex

See Also:

• queryNewCollection(java.util.function.Function, java.lang.Class, com.aoapps.dbc.ObjectFactoryE, java.lang.String, java.lang.Object[])

queryNewCollection

default <T,
C extends Collection<? super T>,
Ex extends Throwable>
C queryNewCollection(int isolationLevel,
 boolean readOnly,
 Function<? super Integer,? extends C> newCollection,
 Class<? extends Ex> exClass,
 ObjectFactoryE<? extends T,? extends Ex> objectFactory,
 String sql,
 Object... params)
              throws SQLException,
Ex

Query the database with a Collection<T> return type, objects are created with the provided factory.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Parameters:

newCollection - given the row count, or null when unknown, creates the new collection

Throws:

SQLException

Ex

queryCall

default <T> T queryCall(ResultSetCallable<? extends T> resultSetCallable,
 String sql,
 Object... params)
                 throws SQLException

Read-only query the database, calling the ResultSetCallable once.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

SQLException

See Also:

• updateCall(com.aoapps.dbc.ResultSetCallable, java.lang.String, java.lang.Object[])

executeQuery

@Deprecated(forRemoval=true)
default <T> T executeQuery(ResultSetHandler<T> resultSetHandler,
 String sql,
 Object... params)
                    throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryCall(com.aoapps.dbc.ResultSetCallable, java.lang.String, java.lang.Object...)

Throws:

SQLException

updateCall

default <T> T updateCall(ResultSetCallable<? extends T> resultSetCallable,
 String sql,
 Object... params)
                  throws SQLException

Read-write query the database, calling the ResultSetCallable once.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

SQLException

See Also:

• queryCall(com.aoapps.dbc.ResultSetCallable, java.lang.String, java.lang.Object[])

executeUpdate

@Deprecated(forRemoval=true)
default <T> T executeUpdate(ResultSetHandler<T> resultSetHandler,
 String sql,
 Object... params)
                     throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateCall(com.aoapps.dbc.ResultSetCallable, java.lang.String, java.lang.Object...)

Throws:

SQLException

queryCall

default <T> T queryCall(int isolationLevel,
 boolean readOnly,
 ResultSetCallable<? extends T> resultSetCallable,
 String sql,
 Object... params)
                 throws SQLException

Query the database, calling the ResultSetCallable once.

Throws:

SQLException

executeQuery

@Deprecated(forRemoval=true)
default <T> T executeQuery(int isolationLevel,
 boolean readOnly,
 ResultSetHandler<T> resultSetHandler,
 String sql,
 Object... params)
                    throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryCall(int, boolean, com.aoapps.dbc.ResultSetCallable, java.lang.String, java.lang.Object...)

Throws:

SQLException

queryCall

default <T,
Ex extends Throwable> T queryCall(Class<? extends Ex> exClass,
 ResultSetCallableE<? extends T,? extends Ex> resultSetCallable,
 String sql,
 Object... params)
                                       throws SQLException,
Ex

Read-only query the database, calling the ResultSetCallableE once.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• updateCall(java.lang.Class, com.aoapps.dbc.ResultSetCallableE, java.lang.String, java.lang.Object[])

executeQuery

@Deprecated(forRemoval=true)
default <T,
Ex extends Exception> T executeQuery(Class<Ex> exClass,
 ResultSetHandlerE<T,Ex> resultSetHandler,
 String sql,
 Object... params)
                                          throws SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryCall(java.lang.Class, com.aoapps.dbc.ResultSetCallableE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

updateCall

default <T,
Ex extends Throwable> T updateCall(Class<? extends Ex> exClass,
 ResultSetCallableE<? extends T,? extends Ex> resultSetCallable,
 String sql,
 Object... params)
                                        throws SQLException,
Ex

Read-write query the database, calling the ResultSetCallableE once.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• queryCall(java.lang.Class, com.aoapps.dbc.ResultSetCallableE, java.lang.String, java.lang.Object[])

executeUpdate

@Deprecated(forRemoval=true)
default <T,
Ex extends Exception> T executeUpdate(Class<Ex> exClass,
 ResultSetHandlerE<T,Ex> resultSetHandler,
 String sql,
 Object... params)
                                           throws SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateCall(java.lang.Class, com.aoapps.dbc.ResultSetCallableE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

queryCall

<T,
Ex extends Throwable> T queryCall(int isolationLevel,
 boolean readOnly,
 Class<? extends Ex> exClass,
 ResultSetCallableE<? extends T,? extends Ex> resultSetCallable,
 String sql,
 Object... params)
                               throws SQLException,
Ex

Query the database, calling the ResultSetCallableE once.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

executeQuery

@Deprecated(forRemoval=true)
default <T,
Ex extends Exception> T executeQuery(int isolationLevel,
 boolean readOnly,
 Class<Ex> exClass,
 ResultSetHandlerE<T,Ex> resultSetHandler,
 String sql,
 Object... params)
                                          throws SQLException,
Ex

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryCall(int, boolean, java.lang.Class, com.aoapps.dbc.ResultSetCallableE, java.lang.String, java.lang.Object...)

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

queryRun

default void queryRun(ResultSetRunnable resultSetRunnable,
 String sql,
 Object... params)
               throws SQLException

Read-only query the database, calling the ResultSetRunnable once.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

SQLException

See Also:

• updateRun(com.aoapps.dbc.ResultSetRunnable, java.lang.String, java.lang.Object[])

updateRun

default void updateRun(ResultSetRunnable resultSetRunnable,
 String sql,
 Object... params)
                throws SQLException

Read-write query the database, calling the ResultSetRunnable once.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

SQLException

See Also:

• queryRun(com.aoapps.dbc.ResultSetRunnable, java.lang.String, java.lang.Object[])

queryRun

default void queryRun(int isolationLevel,
 boolean readOnly,
 ResultSetRunnable resultSetRunnable,
 String sql,
 Object... params)
               throws SQLException

Query the database, calling the ResultSetRunnable once.

Throws:

SQLException

queryRun

default <Ex extends Throwable> void queryRun(Class<? extends Ex> exClass,
 ResultSetRunnableE<? extends Ex> resultSetRunnable,
 String sql,
 Object... params)
                                      throws SQLException,
Ex

Read-only query the database, calling the ResultSetRunnableE once.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• updateRun(java.lang.Class, com.aoapps.dbc.ResultSetRunnableE, java.lang.String, java.lang.Object[])

updateRun

default <Ex extends Throwable> void updateRun(Class<? extends Ex> exClass,
 ResultSetRunnableE<? extends Ex> resultSetRunnable,
 String sql,
 Object... params)
                                       throws SQLException,
Ex

Read-write query the database, calling the ResultSetRunnableE once.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

See Also:

• queryRun(java.lang.Class, com.aoapps.dbc.ResultSetRunnableE, java.lang.String, java.lang.Object[])

queryRun

default <Ex extends Throwable> void queryRun(int isolationLevel,
 boolean readOnly,
 Class<? extends Ex> exClass,
 ResultSetRunnableE<? extends Ex> resultSetRunnable,
 String sql,
 Object... params)
                                      throws SQLException,
Ex

Query the database, calling the ResultSetRunnableE once.

Type Parameters:

Ex - An arbitrary exception type that may be thrown

Throws:

SQLException

Ex

queryShort

default short queryShort(String sql,
 Object... params)
                  throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null short return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryShortNullable

default Short queryShortNullable(String sql,
 Object... params)
                          throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable Short return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryShortOptional

default Optional<Short> queryShortOptional(String sql,
 Object... params)
                                    throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null Short return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryShortOptionalNullable

default Optional<Short> queryShortOptionalNullable(String sql,
 Object... params)
                                            throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable Short return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeShortQuery

@Deprecated(forRemoval=true)
default short executeShortQuery(String sql,
 Object... params)
                         throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryShort(java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

updateShort

default short updateShort(String sql,
 Object... params)
                   throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null short return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateShortNullable

default Short updateShortNullable(String sql,
 Object... params)
                           throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable Short return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateShortOptional

default Optional<Short> updateShortOptional(String sql,
 Object... params)
                                     throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null Short return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateShortOptionalNullable

default Optional<Short> updateShortOptionalNullable(String sql,
 Object... params)
                                             throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable Short return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeShortUpdate

@Deprecated(forRemoval=true)
default short executeShortUpdate(String sql,
 Object... params)
                          throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateShort(java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

queryShort

default Short queryShort(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                  throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a Short return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryShort

@Deprecated(forRemoval=true)
default Short queryShort(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                  throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryShort(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

executeShortQuery

@Deprecated(forRemoval=true)
default Short executeShortQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                         throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryShort(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

NullDataException

ExtraRowException

SQLException

executeShortListQuery

@Deprecated(forRemoval=true)
default List<Short> executeShortListQuery(String sql,
 Object... params)
                                   throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with ObjectFactories.Short

Read-only query the database with a List<Short> return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

SQLException

See Also:

• executeShortListUpdate(java.lang.String, java.lang.Object...)

executeShortListUpdate

@Deprecated(forRemoval=true)
default List<Short> executeShortListUpdate(String sql,
 Object... params)
                                    throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with ObjectFactories.Short

Read-write query the database with a List<Short> return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

SQLException

See Also:

• executeShortListQuery(java.lang.String, java.lang.Object...)

executeShortListQuery

@Deprecated(forRemoval=true)
default List<Short> executeShortListQuery(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
                                   throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryList(int, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...) with ObjectFactories.Short

Query the database with a List<Short> return type.

Throws:

SQLException

queryString

default String queryString(String sql,
 Object... params)
                    throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null String return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryStringNullable

default String queryStringNullable(String sql,
 Object... params)
                            throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable String return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryStringOptional

default Optional<String> queryStringOptional(String sql,
 Object... params)
                                      throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null String return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryStringOptionalNullable

default Optional<String> queryStringOptionalNullable(String sql,
 Object... params)
                                              throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable String return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeStringQuery

@Deprecated(forRemoval=true)
default String executeStringQuery(String sql,
 Object... params)
                           throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryString(java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

updateString

default String updateString(String sql,
 Object... params)
                     throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null String return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateStringNullable

default String updateStringNullable(String sql,
 Object... params)
                             throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable String return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateStringOptional

default Optional<String> updateStringOptional(String sql,
 Object... params)
                                       throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null String return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateStringOptionalNullable

default Optional<String> updateStringOptionalNullable(String sql,
 Object... params)
                                               throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable String return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeStringUpdate

@Deprecated(forRemoval=true)
default String executeStringUpdate(String sql,
 Object... params)
                            throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateString(java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryString

default String queryString(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                    throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a String return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryString

@Deprecated(forRemoval=true)
default String queryString(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                    throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryString(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

executeStringQuery

@Deprecated(forRemoval=true)
default String executeStringQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                           throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryString(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryStringList

default List<String> queryStringList(String sql,
 Object... params)
                              throws SQLException

Read-only query the database with a List<String> return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

SQLException

See Also:

• updateStringList(java.lang.String, java.lang.Object...)

executeStringListQuery

@Deprecated(forRemoval=true)
default List<String> executeStringListQuery(String sql,
 Object... params)
                                     throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryStringList(java.lang.String, java.lang.Object...)

Throws:

SQLException

updateStringList

default List<String> updateStringList(String sql,
 Object... params)
                               throws SQLException

Read-write query the database with a List<String> return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

SQLException

See Also:

• queryStringList(java.lang.String, java.lang.Object...)

executeStringListUpdate

@Deprecated(forRemoval=true)
default List<String> executeStringListUpdate(String sql,
 Object... params)
                                      throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateStringList(java.lang.String, java.lang.Object...)

Throws:

SQLException

queryStringList

default List<String> queryStringList(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
                              throws SQLException

Query the database with a List<String> return type.

Throws:

SQLException

executeStringListQuery

@Deprecated(forRemoval=true)
default List<String> executeStringListQuery(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
                                     throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryStringList(int, boolean, java.lang.String, java.lang.Object...)

Throws:

SQLException

streamString

default Stream<String> streamString(String sql,
 Object... params)
                             throws SQLException

Read-only query the database with a Stream<String> return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true

Throws:

SQLException

See Also:

• streamStringUpdate(java.lang.String, java.lang.Object...)

streamStringUpdate

default Stream<String> streamStringUpdate(String sql,
 Object... params)
                                   throws SQLException

Read-write query the database with a Stream<String> return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false

Throws:

SQLException

See Also:

• streamString(java.lang.String, java.lang.Object...)

streamString

default Stream<String> streamString(int isolationLevel,
 boolean readOnly,
 String sql,
 Object... params)
                             throws SQLException

Query the database with a Stream<String> return type.

Throws:

SQLException

queryTimestamp

default Timestamp queryTimestamp(String sql,
 Object... params)
                          throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-only query the database with a required non-null Timestamp return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryTimestampNullable

default Timestamp queryTimestampNullable(String sql,
 Object... params)
                                  throws NoRowException,
ExtraRowException,
SQLException

Read-only query the database with a required nullable Timestamp return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

queryTimestampOptional

default Optional<Timestamp> queryTimestampOptional(String sql,
 Object... params)
                                            throws NullDataException,
ExtraRowException,
SQLException

Read-only query the database with an optional non-null Timestamp return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

queryTimestampOptionalNullable

default Optional<Timestamp> queryTimestampOptionalNullable(String sql,
 Object... params)
                                                    throws ExtraRowException,
SQLException

Read-only query the database with an optional nullable Timestamp return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = true
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeTimestampQuery

@Deprecated(forRemoval=true)
default Timestamp executeTimestampQuery(String sql,
 Object... params)
                                 throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryTimestamp(java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

updateTimestamp

default Timestamp updateTimestamp(String sql,
 Object... params)
                           throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Read-write query the database with a required non-null Timestamp return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = false

Returns:

The value, never null.

Throws:

NoRowException - When has no row.

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateTimestampNullable

default Timestamp updateTimestampNullable(String sql,
 Object... params)
                                   throws NoRowException,
ExtraRowException,
SQLException

Read-write query the database with a required nullable Timestamp return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = true
• nullable = true

Returns:

The value or null when row with SQL NULL value.

Throws:

NoRowException - When has no row.

ExtraRowException - When has more than one row.

SQLException

updateTimestampOptional

default Optional<Timestamp> updateTimestampOptional(String sql,
 Object... params)
                                             throws NullDataException,
ExtraRowException,
SQLException

Read-write query the database with an optional non-null Timestamp return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = false

Returns:

The value or Optional.empty() when no row.

Throws:

NullDataException - When has a row, but with SQL NULL value.

ExtraRowException - When has more than one row.

SQLException

updateTimestampOptionalNullable

default Optional<Timestamp> updateTimestampOptionalNullable(String sql,
 Object... params)
                                                     throws ExtraRowException,
SQLException

Read-write query the database with an optional nullable Timestamp return type.

• isolationLevel = Connections.DEFAULT_TRANSACTION_ISOLATION
• readOnly = false
• rowRequired = false
• nullable = true

Returns:

The value or Optional.empty() when either no row or row with SQL NULL value.

Throws:

ExtraRowException - When has more than one row.

SQLException

executeTimestampUpdate

@Deprecated(forRemoval=true)
default Timestamp executeTimestampUpdate(String sql,
 Object... params)
                                  throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use updateTimestamp(java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

queryTimestamp

default Timestamp queryTimestamp(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 boolean nullable,
 String sql,
 Object... params)
                          throws NoRowException,
NullDataException,
ExtraRowException,
SQLException

Query the database with a Timestamp return type.

Returns:

The value, null when no row and !rowRequired, or null when row with SQL NULL value and nullable.

Throws:

NoRowException - When has no row and rowRequired.

NullDataException - When has a row, but with SQL NULL value and !nullable.

ExtraRowException - When has more than one row.

SQLException

queryTimestamp

@Deprecated(forRemoval=true)
default Timestamp queryTimestamp(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                          throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryTimestamp(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

executeTimestampQuery

@Deprecated(forRemoval=true)
default Timestamp executeTimestampQuery(int isolationLevel,
 boolean readOnly,
 boolean rowRequired,
 String sql,
 Object... params)
                                 throws NoRowException,
ExtraRowException,
SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use queryTimestamp(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)

Throws:

NoRowException

ExtraRowException

SQLException

update

int update(String sql,
 Object... params)
    throws SQLException

Performs an update on the database and returns the number of rows affected.

Throws:

SQLException

largeUpdate

long largeUpdate(String sql,
 Object... params)
          throws SQLException

Performs an update on the database and returns the number of rows affected.

Throws:

SQLException

executeUpdate

@Deprecated(forRemoval=true)
default int executeUpdate(String sql,
 Object... params)
                   throws SQLException

Deprecated, for removal: This API element is subject to removal in a future version.

Please use update(java.lang.String, java.lang.Object...)

Throws:

SQLException