- All Known Implementing Classes:
CloseableDatabase
,Database
,DatabaseConnection
- Author:
- AO Industries, Inc.
-
Nested Class Summary
Nested ClassesModifier and TypeInterfaceDescriptionstatic enum
These may be used as parameters to represent null values of specific types. -
Method Summary
Modifier and TypeMethodDescriptiondoubleStream
(int isolationLevel, boolean readOnly, String sql, Object... params) Query the database with aDoubleStream
return type.default DoubleStream
doubleStream
(String sql, Object... params) Read-only query the database with aDoubleStream
return type.default DoubleStream
doubleStreamUpdate
(String sql, Object... params) Read-write query the database with aDoubleStream
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.default BigDecimal
executeBigDecimalQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default BigDecimal
executeBigDecimalUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default boolean
executeBooleanQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default boolean
executeBooleanUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default byte[]
executeByteArrayQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default byte[]
executeByteArrayUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default Date
executeDateQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default Date
executeDateUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default IntList
executeIntListQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default IntList
executeIntListUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default int
executeIntQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default int
executeIntUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default LongList
executeLongListQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default LongList
executeLongListUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default long
executeLongQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default long
executeLongUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default <T,
C extends Collection<? super T>>
CexecuteObjectCollectionQuery
(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.default <T,
C extends Collection<? super T>, Ex extends Exception>
CexecuteObjectCollectionQuery
(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.default <T,
C extends Collection<? super T>>
CexecuteObjectCollectionQuery
(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 usequeryCollection(int, boolean, java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.default <T,
C extends Collection<? super T>>
CexecuteObjectCollectionQuery
(C collection, ObjectFactory<T> objectFactory, String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default <T,
C extends Collection<? super T>, Ex extends Exception>
CexecuteObjectCollectionQuery
(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.default <T,
C extends Collection<? super T>>
CexecuteObjectCollectionQuery
(C collection, Class<T> clazz, String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.Please usequeryCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.default <T,
C extends Collection<? super T>>
CexecuteObjectCollectionUpdate
(C collection, ObjectFactory<T> objectFactory, String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default <T,
C extends Collection<? super T>, Ex extends Exception>
CexecuteObjectCollectionUpdate
(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.default <T,
C extends Collection<? super T>>
CexecuteObjectCollectionUpdate
(C collection, Class<T> clazz, String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.Please useupdateCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::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.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.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 usequeryList(int, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::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.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.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 usequeryList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::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.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.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 useupdateList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::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.default <T,
Ex extends Exception>
TexecuteObjectQuery
(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.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 usequeryObject(int, boolean, boolean, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::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.default <T,
Ex extends Exception>
TexecuteObjectQuery
(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.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 usequeryObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::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.default <T,
Ex extends Exception>
TexecuteObjectUpdate
(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.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 useupdateObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::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.default <T,
Ex extends Exception>
TexecuteQuery
(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.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.default <T,
Ex extends Exception>
TexecuteQuery
(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.executeShortListQuery
(int isolationLevel, boolean readOnly, String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.executeShortListQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.executeShortListUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default short
executeShortQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default short
executeShortUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.executeStringListQuery
(int isolationLevel, boolean readOnly, String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.executeStringListQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.executeStringListUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default String
executeStringQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default String
executeStringUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default Timestamp
executeTimestampQuery
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.default Timestamp
executeTimestampUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.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.default <T,
Ex extends Exception>
TexecuteUpdate
(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.default int
executeUpdate
(String sql, Object... params) Deprecated, for removal: This API element is subject to removal in a future version.Query the database with anIntStream
return type.default IntStream
Read-only query the database with anIntStream
return type.default IntStream
intStreamUpdate
(String sql, Object... params) Read-write query the database with anIntStream
return type.boolean
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
(int isolationLevel, boolean readOnly, String sql, Object... params) Query the database with aLongStream
return type.default LongStream
longStream
(String sql, Object... params) Read-only query the database with aLongStream
return type.default LongStream
longStreamUpdate
(String sql, Object... params) Read-write query the database with aLongStream
return type.default BigDecimal
queryBigDecimal
(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params) Query the database with aBigDecimal
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.default BigDecimal
queryBigDecimal
(String sql, Object... params) Read-only query the database with a required non-nullBigDecimal
return type.default BigDecimal
queryBigDecimalNullable
(String sql, Object... params) Read-only query the database with a required nullableBigDecimal
return type.default Optional
<BigDecimal> queryBigDecimalOptional
(String sql, Object... params) Read-only query the database with an optional non-nullBigDecimal
return type.default Optional
<BigDecimal> queryBigDecimalOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullableBigDecimal
return type.default Boolean
queryBoolean
(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params) Query the database with aBoolean
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.default boolean
queryBoolean
(String sql, Object... params) Read-only query the database with a required non-nullboolean
return type.default Boolean
queryBooleanNullable
(String sql, Object... params) Read-only query the database with a required nullableBoolean
return type.queryBooleanOptional
(String sql, Object... params) Read-only query the database with an optional non-nullBoolean
return type.queryBooleanOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullableBoolean
return type.default byte[]
queryByteArray
(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params) Query the database with abyte[]
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.default byte[]
queryByteArray
(String sql, Object... params) Read-only query the database with a required non-nullbyte[]
return type.default byte[]
queryByteArrayNullable
(String sql, Object... params) Read-only query the database with a required nullablebyte[]
return type.default Optional
<byte[]> queryByteArrayOptional
(String sql, Object... params) Read-only query the database with an optional non-nullbyte[]
return type.default Optional
<byte[]> queryByteArrayOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullablebyte[]
return type.default <T> T
queryCall
(int isolationLevel, boolean readOnly, ResultSetCallable<? extends T> resultSetCallable, String sql, Object... params) Query the database, calling theResultSetCallable
once.<T,
Ex extends Throwable>
TqueryCall
(int isolationLevel, boolean readOnly, Class<? extends Ex> exClass, ResultSetCallableE<? extends T, ? extends Ex> resultSetCallable, String sql, Object... params) Query the database, calling theResultSetCallableE
once.default <T> T
queryCall
(ResultSetCallable<? extends T> resultSetCallable, String sql, Object... params) Read-only query the database, calling theResultSetCallable
once.default <T,
Ex extends Throwable>
TqueryCall
(Class<? extends Ex> exClass, ResultSetCallableE<? extends T, ? extends Ex> resultSetCallable, String sql, Object... params) Read-only query the database, calling theResultSetCallableE
once.default <T,
C extends Collection<? super T>>
CqueryCollection
(int isolationLevel, boolean readOnly, C collection, ObjectFactory<? extends T> objectFactory, String sql, Object... params) Query the database with aCollection<T>
return type, objects are created with the provided factory.default <T,
C extends Collection<? super T>, Ex extends Throwable>
CqueryCollection
(int isolationLevel, boolean readOnly, C collection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Query the database with aCollection<T>
return type, objects are created with the provided factory.default <T,
C extends Collection<? super T>>
CqueryCollection
(C collection, ObjectFactory<? extends T> objectFactory, String sql, Object... params) Read-only query the database with aCollection<T>
return type, objects are created with the provided factory.default <T,
C extends Collection<? super T>, Ex extends Throwable>
CqueryCollection
(C collection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Read-only query the database with aCollection<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 aDate
return type.default Date
Deprecated, for removal: This API element is subject to removal in a future version.default Date
Read-only query the database with a required non-nullDate
return type.default Date
queryDateNullable
(String sql, Object... params) Read-only query the database with a required nullableDate
return type.queryDateOptional
(String sql, Object... params) Read-only query the database with an optional non-nullDate
return type.queryDateOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullableDate
return type.default Double
queryDouble
(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params) Query the database with aDouble
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.default double
queryDouble
(String sql, Object... params) Read-only query the database with a required non-nulldouble
return type.default Double
queryDoubleNullable
(String sql, Object... params) Read-only query the database with a required nullableDouble
return type.queryDoubleOptional
(String sql, Object... params) Read-only query the database with an optional non-nullDouble
return type.queryDoubleOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullableDouble
return type.default Float
queryFloat
(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params) Query the database with aFloat
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.default float
queryFloat
(String sql, Object... params) Read-only query the database with a required non-nullfloat
return type.default Float
queryFloatNullable
(String sql, Object... params) Read-only query the database with a required nullableFloat
return type.queryFloatOptional
(String sql, Object... params) Read-only query the database with an optional non-nullFloat
return type.queryFloatOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullableFloat
return type.default Integer
queryInt
(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params) Query the database with anInteger
return type.default Integer
Deprecated, for removal: This API element is subject to removal in a future version.default int
Read-only query the database with a required non-nullint
return type.default IntList
queryIntList
(int isolationLevel, boolean readOnly, String sql, Object... params) Query the database with anIntList
return type.default IntList
queryIntList
(String sql, Object... params) Read-only query the database with anIntList
return type.default Integer
queryIntNullable
(String sql, Object... params) Read-only query the database with a required nullableInteger
return type.queryIntOptional
(String sql, Object... params) Read-only query the database with an optional non-nullInteger
return type.queryIntOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullableInteger
return type.default <T> List
<T> queryList
(int isolationLevel, boolean readOnly, ObjectFactory<? extends T> objectFactory, String sql, Object... params) Query the database with aList<T>
return type, objects are created with the provided factory.queryList
(int isolationLevel, boolean readOnly, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Query the database with aList<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 aList<T>
return type, objects are created with the provided factory.queryList
(Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Read-only query the database with aList<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 aLong
return type.default Long
Deprecated, for removal: This API element is subject to removal in a future version.default long
Read-only query the database with a required non-nulllong
return type.default LongList
queryLongList
(int isolationLevel, boolean readOnly, String sql, Object... params) Query the database with aLongList
return type.default LongList
queryLongList
(String sql, Object... params) Read-only query the database with aLongList
return type.default Long
queryLongNullable
(String sql, Object... params) Read-only query the database with a required nullableLong
return type.queryLongOptional
(String sql, Object... params) Read-only query the database with an optional non-nullLong
return type.queryLongOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullableLong
return type.default <T,
C extends Collection<? super T>>
CqueryNewCollection
(int isolationLevel, boolean readOnly, Function<? super Integer, ? extends C> newCollection, ObjectFactory<? extends T> objectFactory, String sql, Object... params) Query the database with aCollection<T>
return type, objects are created with the provided factory.default <T,
C extends Collection<? super T>, Ex extends Throwable>
CqueryNewCollection
(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 aCollection<T>
return type, objects are created with the provided factory.default <T,
C extends Collection<? super T>>
CqueryNewCollection
(Function<? super Integer, ? extends C> newCollection, ObjectFactory<? extends T> objectFactory, String sql, Object... params) Read-only query the database with aCollection<T>
return type, objects are created with the provided factory.default <T,
C extends Collection<? super T>, Ex extends Throwable>
CqueryNewCollection
(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 aCollection<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>
TqueryObject
(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.default <T,
Ex extends Throwable>
TqueryObject
(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.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>
TqueryObject
(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>
TqueryObjectNullable
(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.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.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 theResultSetRunnable
once.default <Ex extends Throwable>
voidqueryRun
(int isolationLevel, boolean readOnly, Class<? extends Ex> exClass, ResultSetRunnableE<? extends Ex> resultSetRunnable, String sql, Object... params) Query the database, calling theResultSetRunnableE
once.default void
queryRun
(ResultSetRunnable resultSetRunnable, String sql, Object... params) Read-only query the database, calling theResultSetRunnable
once.default <Ex extends Throwable>
voidqueryRun
(Class<? extends Ex> exClass, ResultSetRunnableE<? extends Ex> resultSetRunnable, String sql, Object... params) Read-only query the database, calling theResultSetRunnableE
once.default Short
queryShort
(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params) Query the database with aShort
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.default short
queryShort
(String sql, Object... params) Read-only query the database with a required non-nullshort
return type.default Short
queryShortNullable
(String sql, Object... params) Read-only query the database with a required nullableShort
return type.queryShortOptional
(String sql, Object... params) Read-only query the database with an optional non-nullShort
return type.queryShortOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullableShort
return type.default String
queryString
(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params) Query the database with aString
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.default String
queryString
(String sql, Object... params) Read-only query the database with a required non-nullString
return type.queryStringList
(int isolationLevel, boolean readOnly, String sql, Object... params) Query the database with aList<String>
return type.queryStringList
(String sql, Object... params) Read-only query the database with aList<String>
return type.default String
queryStringNullable
(String sql, Object... params) Read-only query the database with a required nullableString
return type.queryStringOptional
(String sql, Object... params) Read-only query the database with an optional non-nullString
return type.queryStringOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullableString
return type.default Timestamp
queryTimestamp
(int isolationLevel, boolean readOnly, boolean rowRequired, boolean nullable, String sql, Object... params) Query the database with aTimestamp
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.default Timestamp
queryTimestamp
(String sql, Object... params) Read-only query the database with a required non-nullTimestamp
return type.default Timestamp
queryTimestampNullable
(String sql, Object... params) Read-only query the database with a required nullableTimestamp
return type.queryTimestampOptional
(String sql, Object... params) Read-only query the database with an optional non-nullTimestamp
return type.queryTimestampOptionalNullable
(String sql, Object... params) Read-only query the database with an optional nullableTimestamp
return type.default <T> Stream
<T> stream
(int isolationLevel, boolean readOnly, ObjectFactory<? extends T> objectFactory, String sql, Object... params) Query the database with aStream<T>
return type, objects are created with the provided factory.stream
(int isolationLevel, boolean readOnly, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Query the database with aStream<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 aStream<T>
return type, objects are created with the provided factory.stream
(Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Read-only query the database with aStream<T>
return type, objects are created with the provided factory.streamOptional
(int isolationLevel, boolean readOnly, ObjectFactory<? extends T> objectFactory, String sql, Object... params) Query the database with aStream<Optional<T>>
return type, objects are created with the provided factory.streamOptional
(int isolationLevel, boolean readOnly, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Query the database with aStream<Optional<T>>
return type, objects are created with the provided factory.streamOptional
(ObjectFactory<? extends T> objectFactory, String sql, Object... params) Read-only query the database with aStream<Optional<T>>
return type, objects are created with the provided factory.streamOptional
(Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Read-only query the database with aStream<Optional<T>>
return type, objects are created with the provided factory.streamOptionalUpdate
(ObjectFactory<? extends T> objectFactory, String sql, Object... params) Read-write query the database with aStream<Optional<T>>
return type, objects are created with the provided factory.streamOptionalUpdate
(Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Read-write query the database with aStream<Optional<T>>
return type, objects are created with the provided factory.streamString
(int isolationLevel, boolean readOnly, String sql, Object... params) Query the database with aStream<String>
return type.streamString
(String sql, Object... params) Read-only query the database with aStream<String>
return type.streamStringUpdate
(String sql, Object... params) Read-write query the database with aStream<String>
return type.default <T> Stream
<T> streamUpdate
(ObjectFactory<? extends T> objectFactory, String sql, Object... params) Read-write query the database with aStream<T>
return type, objects are created with the provided factory.streamUpdate
(Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Read-write query the database with aStream<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>
VtransactionCall
(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>
VtransactionCall
(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>
voidtransactionRun
(Class<? extends Ex> exClass, DatabaseRunnableE<? extends Ex> runnable) Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.default <Ex extends Throwable>
voidtransactionRun
(Class<? extends Ex> exClass, RunnableE<? extends Ex> runnable) Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.int
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-nullBigDecimal
return type.default BigDecimal
updateBigDecimalNullable
(String sql, Object... params) Read-write query the database with a required nullableBigDecimal
return type.default Optional
<BigDecimal> updateBigDecimalOptional
(String sql, Object... params) Read-write query the database with an optional non-nullBigDecimal
return type.default Optional
<BigDecimal> updateBigDecimalOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullableBigDecimal
return type.default boolean
updateBoolean
(String sql, Object... params) Read-write query the database with a required non-nullboolean
return type.default Boolean
updateBooleanNullable
(String sql, Object... params) Read-write query the database with a required nullableBoolean
return type.updateBooleanOptional
(String sql, Object... params) Read-write query the database with an optional non-nullBoolean
return type.updateBooleanOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullableBoolean
return type.default byte[]
updateByteArray
(String sql, Object... params) Read-write query the database with a required non-nullbyte[]
return type.default byte[]
updateByteArrayNullable
(String sql, Object... params) Read-write query the database with a required nullablebyte[]
return type.default Optional
<byte[]> updateByteArrayOptional
(String sql, Object... params) Read-write query the database with an optional non-nullbyte[]
return type.default Optional
<byte[]> updateByteArrayOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullablebyte[]
return type.default <T> T
updateCall
(ResultSetCallable<? extends T> resultSetCallable, String sql, Object... params) Read-write query the database, calling theResultSetCallable
once.default <T,
Ex extends Throwable>
TupdateCall
(Class<? extends Ex> exClass, ResultSetCallableE<? extends T, ? extends Ex> resultSetCallable, String sql, Object... params) Read-write query the database, calling theResultSetCallableE
once.default <T,
C extends Collection<? super T>>
CupdateCollection
(C collection, ObjectFactory<? extends T> objectFactory, String sql, Object... params) Read-write query the database with aCollection<T>
return type, objects are created with the provided factory.default <T,
C extends Collection<? super T>, Ex extends Throwable>
CupdateCollection
(C collection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Read-write query the database with aCollection<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-nullDate
return type.default Date
updateDateNullable
(String sql, Object... params) Read-write query the database with a required nullableDate
return type.updateDateOptional
(String sql, Object... params) Read-write query the database with an optional non-nullDate
return type.updateDateOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullableDate
return type.default double
updateDouble
(String sql, Object... params) Read-write query the database with a required non-nulldouble
return type.default Double
updateDoubleNullable
(String sql, Object... params) Read-write query the database with a required nullableDouble
return type.updateDoubleOptional
(String sql, Object... params) Read-write query the database with an optional non-nullDouble
return type.updateDoubleOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullableDouble
return type.default float
updateFloat
(String sql, Object... params) Read-write query the database with a required non-nullfloat
return type.default Float
updateFloatNullable
(String sql, Object... params) Read-write query the database with a required nullableFloat
return type.updateFloatOptional
(String sql, Object... params) Read-write query the database with an optional non-nullFloat
return type.updateFloatOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullableFloat
return type.default int
Read-write query the database with a required non-nullint
return type.default IntList
updateIntList
(String sql, Object... params) Read-write query the database with anIntList
return type.default Integer
updateIntNullable
(String sql, Object... params) Read-write query the database with a required nullableInteger
return type.updateIntOptional
(String sql, Object... params) Read-write query the database with an optional non-nullInteger
return type.updateIntOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullableInteger
return type.default <T> List
<T> updateList
(ObjectFactory<? extends T> objectFactory, String sql, Object... params) Read-write query the database with aList<T>
return type, objects are created with the provided factory.updateList
(Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) Read-write query the database with aList<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-nulllong
return type.default LongList
updateLongList
(String sql, Object... params) Read-write query the database with aLongList
return type.default Long
updateLongNullable
(String sql, Object... params) Read-write query the database with a required nullableLong
return type.updateLongOptional
(String sql, Object... params) Read-write query the database with an optional non-nullLong
return type.updateLongOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullableLong
return type.default <T,
C extends Collection<? super T>>
CupdateNewCollection
(Function<? super Integer, ? extends C> newCollection, ObjectFactory<? extends T> objectFactory, String sql, Object... params) Read-write query the database with aCollection<T>
return type, objects are created with the provided factory.default <T,
C extends Collection<? super T>, Ex extends Throwable>
CupdateNewCollection
(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 aCollection<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>
TupdateObject
(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>
TupdateObjectNullable
(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.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.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 theResultSetRunnable
once.default <Ex extends Throwable>
voidupdateRun
(Class<? extends Ex> exClass, ResultSetRunnableE<? extends Ex> resultSetRunnable, String sql, Object... params) Read-write query the database, calling theResultSetRunnableE
once.default short
updateShort
(String sql, Object... params) Read-write query the database with a required non-nullshort
return type.default Short
updateShortNullable
(String sql, Object... params) Read-write query the database with a required nullableShort
return type.updateShortOptional
(String sql, Object... params) Read-write query the database with an optional non-nullShort
return type.updateShortOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullableShort
return type.default String
updateString
(String sql, Object... params) Read-write query the database with a required non-nullString
return type.updateStringList
(String sql, Object... params) Read-write query the database with aList<String>
return type.default String
updateStringNullable
(String sql, Object... params) Read-write query the database with a required nullableString
return type.updateStringOptional
(String sql, Object... params) Read-write query the database with an optional non-nullString
return type.updateStringOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullableString
return type.default Timestamp
updateTimestamp
(String sql, Object... params) Read-write query the database with a required non-nullTimestamp
return type.default Timestamp
updateTimestampNullable
(String sql, Object... params) Read-write query the database with a required nullableTimestamp
return type.updateTimestampOptional
(String sql, Object... params) Read-write query the database with an optional non-nullTimestamp
return type.updateTimestampOptionalNullable
(String sql, Object... params) Read-write query the database with an optional nullableTimestamp
return type.
-
Method Details
-
isInTransaction
boolean isInTransaction()Checks if the current thread is in a transaction.- See Also:
-
transactionCall
default <V> V transactionCall(CallableE<? extends V, ? extends SQLException> callable) throws SQLExceptionExecutes an arbitrary transaction, providing automatic commit, rollback, and connection management.- Rolls-back the transaction on
NoRowException
,NullDataException
, orExtraRowException
on the outer-most transaction only. - 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:
- Rolls-back the transaction on
-
transactionCall
default <V,Ex extends Throwable> V transactionCall(Class<? extends Ex> exClass, CallableE<? extends V, ? extends Ex> callable) throws SQLException, ExExecutes an arbitrary transaction, providing automatic commit, rollback, and connection management.- Rolls-back the transaction on
NoRowException
,NullDataException
, orExtraRowException
on the outer-most transaction only. - 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:
- Rolls-back the transaction on
-
transactionCall
Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.- Rolls-back the transaction on
NoRowException
,NullDataException
, orExtraRowException
on the outer-most transaction only. - 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:
- Rolls-back the transaction on
-
transactionCall
<V,Ex extends Throwable> V transactionCall(Class<? extends Ex> exClass, DatabaseCallableE<? extends V, ? extends Ex> callable) throws SQLException, ExExecutes an arbitrary transaction, providing automatic commit, rollback, and connection management.- Rolls-back the transaction on
NoRowException
,NullDataException
, orExtraRowException
on the outer-most transaction only. - 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:
- Rolls-back the transaction on
-
transactionRun
Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.- Rolls-back the transaction on
NoRowException
,NullDataException
, orExtraRowException
on the outer-most transaction only. - 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:
- Rolls-back the transaction on
-
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.- Rolls-back the transaction on
NoRowException
,NullDataException
, orExtraRowException
on the outer-most transaction only. - 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:
- Rolls-back the transaction on
-
transactionRun
Executes an arbitrary transaction, providing automatic commit, rollback, and connection management.- Rolls-back the transaction on
NoRowException
,NullDataException
, orExtraRowException
on the outer-most transaction only. - 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:
- Rolls-back the transaction on
-
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.- Rolls-back the transaction on
NoRowException
,NullDataException
, orExtraRowException
on the outer-most transaction only. - 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:
- Rolls-back the transaction on
-
queryBigDecimal
default BigDecimal queryBigDecimal(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-only query the database with a required non-nullBigDecimal
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
- isolationLevel =
-
queryBigDecimalNullable
default BigDecimal queryBigDecimalNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullableBigDecimal
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
- isolationLevel =
-
queryBigDecimalOptional
default Optional<BigDecimal> queryBigDecimalOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullBigDecimal
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
- isolationLevel =
-
queryBigDecimalOptionalNullable
default Optional<BigDecimal> queryBigDecimalOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullableBigDecimal
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
- isolationLevel =
-
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. -
updateBigDecimal
default BigDecimal updateBigDecimal(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nullBigDecimal
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
- isolationLevel =
-
updateBigDecimalNullable
default BigDecimal updateBigDecimalNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullableBigDecimal
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
- isolationLevel =
-
updateBigDecimalOptional
default Optional<BigDecimal> updateBigDecimalOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullBigDecimal
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
- isolationLevel =
-
updateBigDecimalOptionalNullable
default Optional<BigDecimal> updateBigDecimalOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullableBigDecimal
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
- isolationLevel =
-
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. -
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 aBigDecimal
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
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. -
queryBoolean
default boolean queryBoolean(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-only query the database with a required non-nullboolean
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
- isolationLevel =
-
queryBooleanNullable
default Boolean queryBooleanNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullableBoolean
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
- isolationLevel =
-
queryBooleanOptional
default Optional<Boolean> queryBooleanOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullBoolean
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
- isolationLevel =
-
queryBooleanOptionalNullable
default Optional<Boolean> queryBooleanOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullableBoolean
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
- isolationLevel =
-
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. -
updateBoolean
default boolean updateBoolean(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nullboolean
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
- isolationLevel =
-
updateBooleanNullable
default Boolean updateBooleanNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullableBoolean
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
- isolationLevel =
-
updateBooleanOptional
default Optional<Boolean> updateBooleanOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullBoolean
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
- isolationLevel =
-
updateBooleanOptionalNullable
default Optional<Boolean> updateBooleanOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullableBoolean
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
- isolationLevel =
-
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. -
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 aBoolean
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
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. -
queryByteArray
default byte[] queryByteArray(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-only query the database with a required non-nullbyte[]
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
- isolationLevel =
-
queryByteArrayNullable
default byte[] queryByteArrayNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullablebyte[]
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
- isolationLevel =
-
queryByteArrayOptional
default Optional<byte[]> queryByteArrayOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullbyte[]
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
- isolationLevel =
-
queryByteArrayOptionalNullable
default Optional<byte[]> queryByteArrayOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullablebyte[]
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
- isolationLevel =
-
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. -
updateByteArray
default byte[] updateByteArray(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nullbyte[]
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
- isolationLevel =
-
updateByteArrayNullable
default byte[] updateByteArrayNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullablebyte[]
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
- isolationLevel =
-
updateByteArrayOptional
default Optional<byte[]> updateByteArrayOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullbyte[]
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
- isolationLevel =
-
updateByteArrayOptionalNullable
default Optional<byte[]> updateByteArrayOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullablebyte[]
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
- isolationLevel =
-
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. -
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 abyte[]
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
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. -
queryDate
default Date queryDate(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-only query the database with a required non-nullDate
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
- isolationLevel =
-
queryDateNullable
default Date queryDateNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullableDate
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
- isolationLevel =
-
queryDateOptional
default Optional<Date> queryDateOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullDate
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
- isolationLevel =
-
queryDateOptionalNullable
default Optional<Date> queryDateOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullableDate
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
- isolationLevel =
-
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. -
updateDate
default Date updateDate(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nullDate
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
- isolationLevel =
-
updateDateNullable
default Date updateDateNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullableDate
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
- isolationLevel =
-
updateDateOptional
default Optional<Date> updateDateOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullDate
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
- isolationLevel =
-
updateDateOptionalNullable
default Optional<Date> updateDateOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullableDate
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
- isolationLevel =
-
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. -
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 aDate
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
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. -
queryDouble
default double queryDouble(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-only query the database with a required non-nulldouble
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
- isolationLevel =
-
queryDoubleNullable
default Double queryDoubleNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullableDouble
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
- isolationLevel =
-
queryDoubleOptional
default Optional<Double> queryDoubleOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullDouble
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
- isolationLevel =
-
queryDoubleOptionalNullable
default Optional<Double> queryDoubleOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullableDouble
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
- isolationLevel =
-
updateDouble
default double updateDouble(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nulldouble
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
- isolationLevel =
-
updateDoubleNullable
default Double updateDoubleNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullableDouble
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
- isolationLevel =
-
updateDoubleOptional
default Optional<Double> updateDoubleOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullDouble
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
- isolationLevel =
-
updateDoubleOptionalNullable
default Optional<Double> updateDoubleOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullableDouble
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
- isolationLevel =
-
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 aDouble
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
doubleStream
default DoubleStream doubleStream(String sql, Object... params) throws NullDataException, SQLException Read-only query the database with aDoubleStream
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
NullDataException
- When has a SQL NULL value.SQLException
- See Also:
- isolationLevel =
-
doubleStreamUpdate
default DoubleStream doubleStreamUpdate(String sql, Object... params) throws NullDataException, SQLException Read-write query the database with aDoubleStream
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
NullDataException
- When has a SQL NULL value.SQLException
- See Also:
- isolationLevel =
-
doubleStream
DoubleStream doubleStream(int isolationLevel, boolean readOnly, String sql, Object... params) throws NullDataException, SQLException Query the database with aDoubleStream
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-nullfloat
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
- isolationLevel =
-
queryFloatNullable
default Float queryFloatNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullableFloat
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
- isolationLevel =
-
queryFloatOptional
default Optional<Float> queryFloatOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullFloat
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
- isolationLevel =
-
queryFloatOptionalNullable
default Optional<Float> queryFloatOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullableFloat
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
- isolationLevel =
-
updateFloat
default float updateFloat(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nullfloat
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
- isolationLevel =
-
updateFloatNullable
default Float updateFloatNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullableFloat
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
- isolationLevel =
-
updateFloatOptional
default Optional<Float> updateFloatOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullFloat
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
- isolationLevel =
-
updateFloatOptionalNullable
default Optional<Float> updateFloatOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullableFloat
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
- isolationLevel =
-
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 aFloat
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
queryInt
default int queryInt(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-only query the database with a required non-nullint
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
- isolationLevel =
-
queryIntNullable
default Integer queryIntNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullableInteger
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
- isolationLevel =
-
queryIntOptional
default Optional<Integer> queryIntOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullInteger
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
- isolationLevel =
-
queryIntOptionalNullable
default Optional<Integer> queryIntOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullableInteger
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
- isolationLevel =
-
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. -
updateInt
default int updateInt(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nullint
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
- isolationLevel =
-
updateIntNullable
default Integer updateIntNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullableInteger
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
- isolationLevel =
-
updateIntOptional
default Optional<Integer> updateIntOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullInteger
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
- isolationLevel =
-
updateIntOptionalNullable
default Optional<Integer> updateIntOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullableInteger
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
- isolationLevel =
-
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. -
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 anInteger
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
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. -
queryIntList
Read-only query the database with anIntList
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
NullDataException
- When has a SQL NULL value.SQLException
- See Also:
- isolationLevel =
-
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.- Throws:
NullDataException
SQLException
-
updateIntList
Read-write query the database with anIntList
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
NullDataException
- When has a SQL NULL value.SQLException
- See Also:
- isolationLevel =
-
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.- Throws:
NullDataException
SQLException
-
queryIntList
default IntList queryIntList(int isolationLevel, boolean readOnly, String sql, Object... params) throws NullDataException, SQLException Query the database with anIntList
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.- Throws:
NullDataException
SQLException
-
intStream
Read-only query the database with anIntStream
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
NullDataException
- When has a SQL NULL value.SQLException
- See Also:
- isolationLevel =
-
intStreamUpdate
default IntStream intStreamUpdate(String sql, Object... params) throws NullDataException, SQLException Read-write query the database with anIntStream
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
NullDataException
- When has a SQL NULL value.SQLException
- See Also:
- isolationLevel =
-
intStream
IntStream intStream(int isolationLevel, boolean readOnly, String sql, Object... params) throws NullDataException, SQLException Query the database with anIntStream
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-nulllong
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
- isolationLevel =
-
queryLongNullable
default Long queryLongNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullableLong
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
- isolationLevel =
-
queryLongOptional
default Optional<Long> queryLongOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullLong
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
- isolationLevel =
-
queryLongOptionalNullable
default Optional<Long> queryLongOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullableLong
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
- isolationLevel =
-
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. -
updateLong
default long updateLong(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nulllong
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
- isolationLevel =
-
updateLongNullable
default Long updateLongNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullableLong
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
- isolationLevel =
-
updateLongOptional
default Optional<Long> updateLongOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullLong
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
- isolationLevel =
-
updateLongOptionalNullable
default Optional<Long> updateLongOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullableLong
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
- isolationLevel =
-
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. -
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 aLong
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
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. -
queryLongList
Read-only query the database with aLongList
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
NullDataException
- When has a SQL NULL value.SQLException
- See Also:
- isolationLevel =
-
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.- Throws:
NullDataException
SQLException
-
updateLongList
default LongList updateLongList(String sql, Object... params) throws NullDataException, SQLException Read-write query the database with aLongList
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
NullDataException
- When has a SQL NULL value.SQLException
- See Also:
- isolationLevel =
-
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.- Throws:
NullDataException
SQLException
-
queryLongList
default LongList queryLongList(int isolationLevel, boolean readOnly, String sql, Object... params) throws NullDataException, SQLException Query the database with aLongList
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.- Throws:
NullDataException
SQLException
-
longStream
Read-only query the database with aLongStream
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
NullDataException
- When has a SQL NULL value.SQLException
- See Also:
- isolationLevel =
-
longStreamUpdate
default LongStream longStreamUpdate(String sql, Object... params) throws NullDataException, SQLException Read-write query the database with aLongStream
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
NullDataException
- When has a SQL NULL value.SQLException
- See Also:
- isolationLevel =
-
longStream
LongStream longStream(int isolationLevel, boolean readOnly, String sql, Object... params) throws NullDataException, SQLException Query the database with aLongStream
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 usequeryObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.Read-only query the database with a required<T>
return type. Class <T> must have a constructor that takes a single argument ofResultSet
.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- rowRequired =
true
- Returns:
- The value or
null
when row withnull
value. - Throws:
NoRowException
- When has no row.ExtraRowException
- When has more than one row.SQLException
- See Also:
- isolationLevel =
-
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 useupdateObject(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.Read-write query the database with a required<T>
return type. Class <T> must have a constructor that takes a single argument ofResultSet
.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- rowRequired =
true
- Returns:
- The value or
null
when row withnull
value. - Throws:
NoRowException
- When has no row.ExtraRowException
- When has more than one row.SQLException
- See Also:
- isolationLevel =
-
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 usequeryObject(int, boolean, boolean, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.Query the database with a<T>
return type. Class <T> must have a constructor that takes a single argument ofResultSet
.- Returns:
- The value or
null
when no row and row not required, or when row withnull
value. - Throws:
NoRowException
- When has no row androwRequired
.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 withobjectFactory
returningnull
.ExtraRowException
- When has more than one row.SQLException
- isolationLevel =
-
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 withobjectFactory
returningnull
. - Throws:
NoRowException
- When has no row.ExtraRowException
- When has more than one row.SQLException
- isolationLevel =
-
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 withobjectFactory
returningnull
.ExtraRowException
- When has more than one row.SQLException
- isolationLevel =
-
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 withobjectFactory
returningnull
. - Throws:
ExtraRowException
- When has more than one row.SQLException
- isolationLevel =
-
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. -
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 withobjectFactory
returningnull
.ExtraRowException
- When has more than one row.SQLException
- isolationLevel =
-
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 withobjectFactory
returningnull
. - Throws:
NoRowException
- When has no row.ExtraRowException
- When has more than one row.SQLException
- isolationLevel =
-
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 withobjectFactory
returningnull
.ExtraRowException
- When has more than one row.SQLException
- isolationLevel =
-
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 withobjectFactory
returningnull
. - Throws:
ExtraRowException
- When has more than one row.SQLException
- isolationLevel =
-
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. -
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
, ornull
when row withobjectFactory
returningnull
value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.NullDataException
- When has a row, but withobjectFactory
returningnull
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. -
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. -
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, ExRead-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 withobjectFactory
returningnull
.ExtraRowException
- When has more than one row.SQLException
Ex
- isolationLevel =
-
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, ExRead-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 withobjectFactory
returningnull
. - Throws:
NoRowException
- When has no row.ExtraRowException
- When has more than one row.SQLException
Ex
- isolationLevel =
-
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, ExRead-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 withobjectFactory
returningnull
.ExtraRowException
- When has more than one row.SQLException
Ex
- isolationLevel =
-
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, ExRead-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 withobjectFactory
returningnull
. - Throws:
ExtraRowException
- When has more than one row.SQLException
Ex
- isolationLevel =
-
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, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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, ExRead-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 withobjectFactory
returningnull
.ExtraRowException
- When has more than one row.SQLException
Ex
- isolationLevel =
-
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, ExRead-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 withobjectFactory
returningnull
. - Throws:
NoRowException
- When has no row.ExtraRowException
- When has more than one row.SQLException
Ex
- isolationLevel =
-
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, ExRead-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 withobjectFactory
returningnull
.ExtraRowException
- When has more than one row.SQLException
Ex
- isolationLevel =
-
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, ExRead-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 withobjectFactory
returningnull
. - Throws:
ExtraRowException
- When has more than one row.SQLException
Ex
- isolationLevel =
-
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, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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, ExQuery 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
, ornull
when row withobjectFactory
returningnull
value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.NullDataException
- When has a row, but withobjectFactory
returningnull
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, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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 usequeryList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.Read-only query the database with aList<T>
return type. Class <T> must have a constructor that takes a single argument ofResultSet
.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Returns:
- An unmodifiable list
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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 useupdateList(com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.Read-write query the database with aList<T>
return type. Class <T> must have a constructor that takes a single argument ofResultSet
.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Returns:
- An unmodifiable list
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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 usequeryList(int, boolean, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.Query the database with aList<T>
return type. Class <T> must have a constructor that takes a single argument ofResultSet
.- 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 aList<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:
- isolationLevel =
-
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.- Throws:
SQLException
-
updateList
default <T> List<T> updateList(ObjectFactory<? extends T> objectFactory, String sql, Object... params) throws SQLException Read-write query the database with aList<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:
- isolationLevel =
-
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.- 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 aList<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.- 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, ExRead-only query the database with aList<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:
- isolationLevel =
-
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, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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, ExRead-write query the database with aList<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:
- isolationLevel =
-
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, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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, ExQuery the database with aList<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, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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 aStream<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 characteristicSpliterator.NONNULL
.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
SQLException
- See Also:
- isolationLevel =
-
streamUpdate
default <T> Stream<T> streamUpdate(ObjectFactory<? extends T> objectFactory, String sql, Object... params) throws SQLException Read-write query the database with aStream<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 characteristicSpliterator.NONNULL
.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
SQLException
- See Also:
- isolationLevel =
-
stream
default <T> Stream<T> stream(int isolationLevel, boolean readOnly, ObjectFactory<? extends T> objectFactory, String sql, Object... params) throws SQLException Query the database with aStream<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 characteristicSpliterator.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, ExRead-only query the database with aStream<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 characteristicSpliterator.NONNULL
.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Type Parameters:
Ex
- An arbitrary exception type that may be thrown- Throws:
SQLException
Ex
- See Also:
- isolationLevel =
-
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, ExRead-write query the database with aStream<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 characteristicSpliterator.NONNULL
.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Type Parameters:
Ex
- An arbitrary exception type that may be thrown- Throws:
SQLException
Ex
- See Also:
- isolationLevel =
-
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, ExQuery the database with aStream<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 characteristicSpliterator.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 aStream<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:
- isolationLevel =
-
streamOptionalUpdate
default <T> Stream<Optional<T>> streamOptionalUpdate(ObjectFactory<? extends T> objectFactory, String sql, Object... params) throws SQLException Read-write query the database with aStream<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:
- isolationLevel =
-
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 aStream<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, ExRead-only query the database with aStream<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:
- isolationLevel =
-
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, ExRead-write query the database with aStream<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:
- isolationLevel =
-
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, ExQuery the database with aStream<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 usequeryCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.Read-only query the database with aCollection<T>
return type. Class <T> must have a constructor that takes a single argument ofResultSet
.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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 useupdateCollection(java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.Read-write query the database with aCollection<T>
return type. Class <T> must have a constructor that takes a single argument ofResultSet
.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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 usequeryCollection(int, boolean, java.util.Collection, com.aoapps.dbc.ObjectFactory, java.lang.String, java.lang.Object...)
with a constructor lambdaClass::new
.Query the database with aCollection<T>
return type. Class <T> must have a constructor that takes a single argument ofResultSet
.- 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 aCollection<T>
return type, objects are created with the provided factory.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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.- 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 aCollection<T>
return type, objects are created with the provided factory.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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.- 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 aCollection<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.- Throws:
SQLException
-
queryCollection
default <T,C extends Collection<? super T>, C queryCollectionEx extends Throwable> (C collection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) throws SQLException, ExRead-only query the database with aCollection<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:
- isolationLevel =
-
executeObjectCollectionQuery
@Deprecated(forRemoval=true) default <T,C extends Collection<? super T>, C executeObjectCollectionQueryEx extends Exception> (C collection, Class<Ex> exClass, ObjectFactoryE<T, Ex> objectFactory, String sql, Object... params) throws SQLException, ExDeprecated, for removal: This API element is subject to removal in a future version.- Type Parameters:
Ex
- An arbitrary exception type that may be thrown- Throws:
SQLException
Ex
-
updateCollection
default <T,C extends Collection<? super T>, C updateCollectionEx extends Throwable> (C collection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) throws SQLException, ExRead-write query the database with aCollection<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:
- isolationLevel =
-
executeObjectCollectionUpdate
@Deprecated(forRemoval=true) default <T,C extends Collection<? super T>, C executeObjectCollectionUpdateEx extends Exception> (C collection, Class<Ex> exClass, ObjectFactoryE<T, Ex> objectFactory, String sql, Object... params) throws SQLException, ExDeprecated, for removal: This API element is subject to removal in a future version.- Type Parameters:
Ex
- An arbitrary exception type that may be thrown- Throws:
SQLException
Ex
-
queryCollection
default <T,C extends Collection<? super T>, C queryCollectionEx extends Throwable> (int isolationLevel, boolean readOnly, C collection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, ? extends Ex> objectFactory, String sql, Object... params) throws SQLException, ExQuery the database with aCollection<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>, C executeObjectCollectionQueryEx extends Exception> (int isolationLevel, boolean readOnly, C collection, Class<Ex> exClass, ObjectFactoryE<T, Ex> objectFactory, String sql, Object... params) throws SQLException, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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 SQLExceptionRead-only query the database with aCollection<T>
return type, objects are created with the provided factory.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Parameters:
newCollection
- given the row count, ornull
when unknown, creates the new collection- Throws:
SQLException
- See Also:
- isolationLevel =
-
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 SQLExceptionRead-write query the database with aCollection<T>
return type, objects are created with the provided factory.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Parameters:
newCollection
- given the row count, ornull
when unknown, creates the new collection- Throws:
SQLException
- See Also:
- isolationLevel =
-
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 SQLExceptionQuery the database with aCollection<T>
return type, objects are created with the provided factory.- Parameters:
newCollection
- given the row count, ornull
when unknown, creates the new collection- Throws:
SQLException
-
queryNewCollection
default <T,C extends Collection<? super T>, C queryNewCollectionEx extends Throwable> (Function<? super Integer, ? extends C> newCollection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, throws SQLException, Ex? extends Ex> objectFactory, String sql, Object... params) Read-only query the database with aCollection<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, ornull
when unknown, creates the new collection- Throws:
SQLException
Ex
- See Also:
- isolationLevel =
-
updateNewCollection
default <T,C extends Collection<? super T>, C updateNewCollectionEx extends Throwable> (Function<? super Integer, ? extends C> newCollection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, throws SQLException, Ex? extends Ex> objectFactory, String sql, Object... params) Read-write query the database with aCollection<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, ornull
when unknown, creates the new collection- Throws:
SQLException
Ex
- See Also:
- isolationLevel =
-
queryNewCollection
default <T,C extends Collection<? super T>, C queryNewCollectionEx extends Throwable> (int isolationLevel, boolean readOnly, Function<? super Integer, ? extends C> newCollection, Class<? extends Ex> exClass, ObjectFactoryE<? extends T, throws SQLException, Ex? extends Ex> objectFactory, String sql, Object... params) Query the database with aCollection<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, ornull
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 theResultSetCallable
once.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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.- Throws:
SQLException
-
updateCall
default <T> T updateCall(ResultSetCallable<? extends T> resultSetCallable, String sql, Object... params) throws SQLException Read-write query the database, calling theResultSetCallable
once.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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.- 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 theResultSetCallable
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.- 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, ExRead-only query the database, calling theResultSetCallableE
once.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Type Parameters:
Ex
- An arbitrary exception type that may be thrown- Throws:
SQLException
Ex
- See Also:
- isolationLevel =
-
executeQuery
@Deprecated(forRemoval=true) default <T,Ex extends Exception> T executeQuery(Class<Ex> exClass, ResultSetHandlerE<T, Ex> resultSetHandler, String sql, Object... params) throws SQLException, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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, ExRead-write query the database, calling theResultSetCallableE
once.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Type Parameters:
Ex
- An arbitrary exception type that may be thrown- Throws:
SQLException
Ex
- See Also:
- isolationLevel =
-
executeUpdate
@Deprecated(forRemoval=true) default <T,Ex extends Exception> T executeUpdate(Class<Ex> exClass, ResultSetHandlerE<T, Ex> resultSetHandler, String sql, Object... params) throws SQLException, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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, ExQuery the database, calling theResultSetCallableE
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, ExDeprecated, for removal: This API element is subject to removal in a future version.- 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 theResultSetRunnable
once.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
SQLException
- See Also:
- isolationLevel =
-
updateRun
default void updateRun(ResultSetRunnable resultSetRunnable, String sql, Object... params) throws SQLException Read-write query the database, calling theResultSetRunnable
once.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
SQLException
- See Also:
- isolationLevel =
-
queryRun
default void queryRun(int isolationLevel, boolean readOnly, ResultSetRunnable resultSetRunnable, String sql, Object... params) throws SQLException Query the database, calling theResultSetRunnable
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 theResultSetRunnableE
once.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Type Parameters:
Ex
- An arbitrary exception type that may be thrown- Throws:
SQLException
Ex
- See Also:
- isolationLevel =
-
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 theResultSetRunnableE
once.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Type Parameters:
Ex
- An arbitrary exception type that may be thrown- Throws:
SQLException
Ex
- See Also:
- isolationLevel =
-
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 theResultSetRunnableE
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-nullshort
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
- isolationLevel =
-
queryShortNullable
default Short queryShortNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullableShort
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
- isolationLevel =
-
queryShortOptional
default Optional<Short> queryShortOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullShort
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
- isolationLevel =
-
queryShortOptionalNullable
default Optional<Short> queryShortOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullableShort
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
- isolationLevel =
-
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. -
updateShort
default short updateShort(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nullshort
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
- isolationLevel =
-
updateShortNullable
default Short updateShortNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullableShort
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
- isolationLevel =
-
updateShortOptional
default Optional<Short> updateShortOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullShort
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
- isolationLevel =
-
updateShortOptionalNullable
default Optional<Short> updateShortOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullableShort
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
- isolationLevel =
-
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. -
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 aShort
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
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. -
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.Read-only query the database with aList<Short>
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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.Read-write query the database with aList<Short>
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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.Query the database with aList<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-nullString
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
- isolationLevel =
-
queryStringNullable
default String queryStringNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullableString
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
- isolationLevel =
-
queryStringOptional
default Optional<String> queryStringOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullString
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
- isolationLevel =
-
queryStringOptionalNullable
default Optional<String> queryStringOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullableString
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
- isolationLevel =
-
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. -
updateString
default String updateString(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nullString
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
- isolationLevel =
-
updateStringNullable
default String updateStringNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullableString
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
- isolationLevel =
-
updateStringOptional
default Optional<String> updateStringOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullString
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
- isolationLevel =
-
updateStringOptionalNullable
default Optional<String> updateStringOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullableString
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
- isolationLevel =
-
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. -
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 aString
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
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. -
queryStringList
Read-only query the database with aList<String>
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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.- Throws:
SQLException
-
updateStringList
Read-write query the database with aList<String>
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
SQLException
- See Also:
- isolationLevel =
-
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.- Throws:
SQLException
-
queryStringList
default List<String> queryStringList(int isolationLevel, boolean readOnly, String sql, Object... params) throws SQLException Query the database with aList<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.- Throws:
SQLException
-
streamString
Read-only query the database with aStream<String>
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
true
- Throws:
SQLException
- See Also:
- isolationLevel =
-
streamStringUpdate
Read-write query the database with aStream<String>
return type.- isolationLevel =
Connections.DEFAULT_TRANSACTION_ISOLATION
- readOnly =
false
- Throws:
SQLException
- See Also:
- isolationLevel =
-
streamString
default Stream<String> streamString(int isolationLevel, boolean readOnly, String sql, Object... params) throws SQLException Query the database with aStream<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-nullTimestamp
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
- isolationLevel =
-
queryTimestampNullable
default Timestamp queryTimestampNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-only query the database with a required nullableTimestamp
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
- isolationLevel =
-
queryTimestampOptional
default Optional<Timestamp> queryTimestampOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-only query the database with an optional non-nullTimestamp
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
- isolationLevel =
-
queryTimestampOptionalNullable
default Optional<Timestamp> queryTimestampOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-only query the database with an optional nullableTimestamp
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
- isolationLevel =
-
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. -
updateTimestamp
default Timestamp updateTimestamp(String sql, Object... params) throws NoRowException, NullDataException, ExtraRowException, SQLException Read-write query the database with a required non-nullTimestamp
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
- isolationLevel =
-
updateTimestampNullable
default Timestamp updateTimestampNullable(String sql, Object... params) throws NoRowException, ExtraRowException, SQLException Read-write query the database with a required nullableTimestamp
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
- isolationLevel =
-
updateTimestampOptional
default Optional<Timestamp> updateTimestampOptional(String sql, Object... params) throws NullDataException, ExtraRowException, SQLException Read-write query the database with an optional non-nullTimestamp
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
- isolationLevel =
-
updateTimestampOptionalNullable
default Optional<Timestamp> updateTimestampOptionalNullable(String sql, Object... params) throws ExtraRowException, SQLException Read-write query the database with an optional nullableTimestamp
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
- isolationLevel =
-
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. -
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 aTimestamp
return type.- Returns:
- The value,
null
when no row and!rowRequired
, ornull
when row with SQL NULL value andnullable
. - Throws:
NoRowException
- When has no row androwRequired
.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. -
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. -
update
Performs an update on the database and returns the number of rows affected.- Throws:
SQLException
-
largeUpdate
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.- Throws:
SQLException
-
queryBigDecimal(int, boolean, boolean, boolean, java.lang.String, java.lang.Object...)