Uses of Class
com.bristle.javalib.sql.ConnectionPoolUtil.NoDataFoundException

Packages that use ConnectionPoolUtil.NoDataFoundException

com.bristle.javalib.sql

Uses of ConnectionPoolUtil.NoDataFoundException in com.bristle.javalib.sql

Methods in com.bristle.javalib.sql that throw ConnectionPoolUtil.NoDataFoundException

boolean	ConnectionPoolUtil.executeSQLIfIntegerGreaterThanZero(String strSelect, String strSQLThen) Connect to the database, execute a SELECT statement to get an Integer value, and if it is greater than 0, execute a 2nd string of SQL, then disconnect, returning true if the Integer is greater than 0, using the default values for Connection, Logger, ConnectionPool, and DBConfig.
boolean	ConnectionPoolUtil.executeSQLIfIntegerGreaterThanZeroThenElse(String strSelect, String strSQLThen, String strSQLElse) Connect to the database, execute a SELECT statement to get an Integer value, and based on whether it is greater than 0, execute a 2nd or 3rd string of SQL, then disconnect, returning true if the Integer is greater than 0, using the default values for Connection, Logger, ConnectionPool, and DBConfig.
boolean	ConnectionPoolUtil.executeSQLIfIntegerNotGreaterThanZero(String strSelect, String strSQLThen) Connect to the database, execute a SELECT statement to get an Integer value, and if it is not greater than 0, execute a 2nd string of SQL, then disconnect, returning true if the Integer is not greater than 0, using the default values for Connection, Logger, ConnectionPool, and DBConfig.
static int	ConnectionPoolUtil.getIntValueFromDB(Connection conn, String strSQL, Logger logger, int intLogLevelOfOperation, ConnectionPool pool, ConnectionPool.DBConfig dbconfig) Connect to the database, get a single int value from the resultset returned by the specified SQL statement, and disconnect, returning the value.
int	ConnectionPoolUtil.getIntValueFromDB(String strSQL) Connect to the database, get a single int value from the resultset returned by the specified SQL statement, and disconnect, returning the value, using the default values for Connection, Logger, ConnectionPool, and DBConfig.
boolean	ConnectionPoolUtil.insertIfNotExistsMultiTable(String strSelectCount, String strTableName, String strCols, String strVals) Connect to the database, execute a SELECT COUNT(*) FROM statement to decide if a row exists and if not, execute an INSERT statement possibly into a different table, then disconnect, returning true if the row existed, using the default values for Connection, Logger, ConnectionPool, and DBConfig.
ConnectionPoolUtil.InsertOrUpdateResult	ConnectionPoolUtil.insertIfNotExistsMultiTableReturnPK(String strSelectPKExisting, String strSelectPKInserted, String strTableName, String strCols, String strVals) Connect to the database, execute a SELECT statement to get the primary key of an existing row, and if it doesn't exist, execute an INSERT statement possibly into a different table and execute a different SELECT statement to get a primary key, then disconnect, returning an InsertOrUpdateResult object, using the default values for Connection, Logger, ConnectionPool, and DBConfig.
ConnectionPoolUtil.InsertOrUpdateResult	ConnectionPoolUtil.insertIfNotExistsReturnPK(String strTableName, String strPKName, String strWhere, String strCols, String strVals) Connect to the database, execute a SELECT statement to get the primary key of an existing row, and if it doesn't exist, execute an INSERT statement into the table and re-execute the SELECT statement to get the primary key, then disconnect, returning an InsertOrUpdateResult object, using the default values for Connection, Logger, ConnectionPool, and DBConfig.
ConnectionPoolUtil.InsertOrUpdateResult	ConnectionPoolUtil.insertOrUpdateReturnPK(String strTableName, String strPKName, String strWhere, String strCols, String strVals, String strSetColsVals) Connect to the database, execute a SELECT statement to decide if a row exists and based on its existence, execute an INSERT or UPDATE statement, then disconnect, returning an InsertOrUpdateResult object, using the default values for Connection, Logger, ConnectionPool, and DBConfig.