Package com.softwaremining.sql

Class ACMDbDecorator

java.lang.Object

com.softwaremining.sql.ACMDbDecorator

public class ACMDbDecorator
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
static long	totalRuntime	for internal use only ...

Constructor Summary

Constructors

Constructor	Description
ACMDbDecorator(String dbProperties, Long sessionId, ISQLWrapper wrapper)

Method Summary

Modifier and Type	Method	Description
static void	commitAndReleaseConnection(Connection connection, Long _sessionId)
Connection	getConnection(Long sessionId)
DbFeatures	getDbFeatures()
Connection	getNewConnection()	Only used through ShadowTransaction server
String	getPrimaryKey(String tableName)
protected PreparedStatement	getStatement(String query, Long sessionId)
PreparedStatement	performExec(String query, List<Object> theParams)	Prepare a Query using parameters passed
PreparedStatement	performExecForObject(ISQLWrapper wrapper, String query, Object param)	prepare a SQL Statement using a single Parameter
int	performIntQuery(String query)	used in COUNT Statements ...
int	performIntQueryForObject(String query, Object param)	used in COUNT Statements ...
ResultSet	performReadQuery(String query, List<Object> theParams, int fetchSize)
ResultSet	performReadQuery(String query, List<Object> theParams, int fetchSize, boolean conditionIsLIKE)
ResultSet	performReadQueryForObject(String query, Object param, int resultSetFetchSize)

Methods inherited from class java.lang.Object

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

Field Details

totalRuntime

public static long totalRuntime

for internal use only ... profiling information

Constructor Details

ACMDbDecorator

public ACMDbDecorator(String dbProperties,
 Long sessionId,
 ISQLWrapper wrapper)

Method Details

getDbFeatures

public DbFeatures getDbFeatures()

getNewConnection

public Connection getNewConnection()

Only used through ShadowTransaction server

Returns:

getConnection

public Connection getConnection(Long sessionId)

getStatement

protected PreparedStatement getStatement(String query,
 Long sessionId)
                                  throws SQLException

Throws:

SQLException

performIntQuery

public int performIntQuery(String query)
                    throws SQLException

used in COUNT Statements ... e.g. SELECT COUNT(*) from TABLE

Parameters:

query -

Returns:

Throws:

SQLException

performIntQueryForObject

public int performIntQueryForObject(String query,
 Object param)
                             throws SQLException

used in COUNT Statements ... e.g. SELECT COUNT(*) from TABLE

Parameters:

query -

param -

Returns:

-

Throws:

SQLException

performReadQueryForObject

public ResultSet performReadQueryForObject(String query,
 Object param,
 int resultSetFetchSize)
                                    throws SQLException

Throws:

SQLException

performReadQuery

public ResultSet performReadQuery(String query,
 List<Object> theParams,
 int fetchSize)
                           throws SQLException

Throws:

SQLException

performReadQuery

public ResultSet performReadQuery(String query,
 List<Object> theParams,
 int fetchSize,
 boolean conditionIsLIKE)
                           throws SQLException

Throws:

SQLException

performExecForObject

public PreparedStatement performExecForObject(ISQLWrapper wrapper,
 String query,
 Object param)
                                       throws SQLException

prepare a SQL Statement using a single Parameter

Parameters:

query -

param - of Integer or String

Returns:

Throws:

SQLException

performExec

public PreparedStatement performExec(String query,
 List<Object> theParams)
                              throws SQLException

Prepare a Query using parameters passed

Parameters:

query - INSERT INTO Table1 (A , B) VALUES (? , ?)

theParams - - List of Integer or String

Returns:

preparedStatement

Throws:

SQLException

getPrimaryKey

public String getPrimaryKey(String tableName)
                     throws SQLException

Throws:

SQLException

commitAndReleaseConnection

public static void commitAndReleaseConnection(Connection connection,
 Long _sessionId)