org.ow2.proactive.scheduler.examples.connectionpooling

Class DBConnectionPoolsHolder

java.lang.Object

org.ow2.proactive.scheduler.examples.connectionpooling.DBConnectionPoolsHolder

public class DBConnectionPoolsHolder
extends Object

Since:

28/12/2018

Method Summary

Modifier and Type	Method and Description
ResultSet	executeQuery(DBConnectionDetails dbConnectionDetails, String queryStr)
CachedRowSet	executeStoredProcedure(DBConnectionDetails dbConnectionDetails, String storedProcName, Object... params) Executes a stored procedure query with the given name and parameters.
int	executeStoredProcedureUpdate(DBConnectionDetails dbConnectionDetails, String storedProcName, Object... params) Executes a stored procedure update with the given name and parameters.
int	executeUpdate(DBConnectionDetails dbConnectionDetails, String updateStr)
static DBConnectionPoolsHolder	getInstance()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

getInstance

public static DBConnectionPoolsHolder getInstance()

executeQuery

public ResultSet executeQuery(DBConnectionDetails dbConnectionDetails,
                              String queryStr)

Parameters:

dbConnectionDetails -

queryStr -

Returns:

a cached result set for a given query to an external DB

executeUpdate

public int executeUpdate(DBConnectionDetails dbConnectionDetails,
                         String updateStr)

Parameters:

dbConnectionDetails -

updateStr -

Returns:

either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing

executeStoredProcedure

public CachedRowSet executeStoredProcedure(DBConnectionDetails dbConnectionDetails,
                                           String storedProcName,
                                           Object... params)

Executes a stored procedure query with the given name and parameters. This store procedure must return a set of row results

Parameters:

dbConnectionDetails - The connection details for the database.

storedProcName - The name of the stored procedure.

params - The parameters to be passed to the stored procedure.

Returns:

A CachedRowSet containing the result set of the stored procedure execution.

executeStoredProcedureUpdate

public int executeStoredProcedureUpdate(DBConnectionDetails dbConnectionDetails,
                                        String storedProcName,
                                        Object... params)

Executes a stored procedure update with the given name and parameters. This call returns an integer containing the number of rows updated or -1 if no table was updated.

Parameters:

dbConnectionDetails - The connection details for the database.

storedProcName - The name of the stored procedure.

params - The parameters to be passed to the stored procedure.

Returns:

The number of rows modified by this update