Uses of Class
org.waarp.common.database.exception.WaarpDatabaseSqlException

Packages that use WaarpDatabaseSqlException

Package	Description
org.waarp.common.database	Classes implementing Database access
org.waarp.common.database.data	Classes implementing Database Data model
org.waarp.common.database.model	Classes implementing Database Model (H2, Oracle, PostgreSQL, MySQL, MariaDB)

Uses of WaarpDatabaseSqlException in org.waarp.common.database

Methods in org.waarp.common.database that throw WaarpDatabaseSqlException

Modifier and Type	Method and Description
void	DbAdmin.commit() Commit on connection (since in autocommit, should not be used)
void	DbSession.commit() Commit everything
void	DbPreparedStatement.createPrepareStatement(String requestarg) Create a preparedStatement from request
void	DbPreparedStatement.executeQuery() Execute a Select preparedStatement
int	DbPreparedStatement.executeUpdate() Execute the Update/Insert/Delete preparedStatement
boolean	DbRequest.getNext() Move the cursor to the next result
boolean	DbPreparedStatement.getNext() Move the cursor to the next result
int	DbRequest.query(String query) Execute a UPDATE/INSERT/DELETE statement and returns the number of row.
void	DbSession.recreateLongTermPreparedStatements() Due to a reconnection, recreate all associated long term PreparedStatements
void	DbPreparedStatement.recreatePreparedStatement() In case of closing database connection, it is possible to reopen a long term preparedStatement as it was at creation.
void	DbSession.releaseSavepoint(Savepoint savepoint) Release the savepoint
void	DbSession.rollback(Savepoint savepoint) Rollback from the savepoint or the last set if null
Savepoint	DbSession.savepoint() Make a savepoint
void	DbRequest.select(String select) Execute a SELECT statement and set of Result.
void	DbRequest.select(String select, int timeout) Execute a SELECT statement and set of Result.

Constructors in org.waarp.common.database that throw WaarpDatabaseSqlException

Constructor and Description
DbPreparedStatement(DbSession ls, String request) Create a DbPreparedStatement from DbSession object and a request
DbPreparedStatement(DbSession ls, String request, int nbFetch) Create a DbPreparedStatement from DbSession object and a request

Uses of WaarpDatabaseSqlException in org.waarp.common.database.data

Methods in org.waarp.common.database.data that throw WaarpDatabaseSqlException

Modifier and Type	Method and Description
static DbDataModel	DbDataModel.getFromStatement(DbPreparedStatement preparedStatement) For instance from Commander when getting updated information
static void	AbstractDbData.getTrueValue(ResultSet rs, DbValue value) Get one value into DbValue from ResultSet
static DbPreparedStatement	DbDataModel.getUpdatedPrepareStament(DbSession session)
protected void	AbstractDbData.getValue(DbPreparedStatement preparedStatement, DbValue value) Get one value into DbValue from DbPreparedStatement
String	DbValue.getValueAsString()
protected void	AbstractDbData.getValues(DbPreparedStatement preparedStatement, DbValue[] values) Get several values into DbValue from DbPreparedStatement
protected abstract void	AbstractDbData.setFromArray() Internal function to retrieve data from Array to pull data from database
protected void	DbDataModel.setFromArray()
void	AbstractDbData.setFromJson(com.fasterxml.jackson.databind.node.ObjectNode node, boolean ignorePrimaryKey) Set the values from the Json node to the current object (no database access)
static void	AbstractDbData.setTrueValue(PreparedStatement ps, DbValue value, int rank) Set Value into PreparedStatement
protected void	AbstractDbData.setValue(DbPreparedStatement preparedStatement, DbValue value) Set one value to a DbPreparedStatement
void	DbValue.setValueFromString(String svalue)
protected void	AbstractDbData.setValues(DbPreparedStatement preparedStatement, DbValue[] values) Set several values to a DbPreparedStatement

Uses of WaarpDatabaseSqlException in org.waarp.common.database.model

Methods in org.waarp.common.database.model that throw WaarpDatabaseSqlException

Modifier and Type	Method and Description
long	DbModel.nextSequence(DbSession dbSession)
long	DbModelOracle.nextSequence(DbSession dbSession)
long	DbModelPostgresql.nextSequence(DbSession dbSession)
long	DbModelMysql.nextSequence(DbSession dbSession)
long	DbModelH2.nextSequence(DbSession dbSession)
long	EmptyDbModel.nextSequence(DbSession dbSession)
long	DbModelMariadb.nextSequence(DbSession dbSession)