Package com.softwaremining.sql

Class SPProcessor

java.lang.Object

com.softwaremining.sql.ESQLProcessor

com.softwaremining.sql.SPProcessor

All Implemented Interfaces:

SQLHandlerInterface

public class SPProcessor
extends ESQLProcessor

Field Summary

Fields inherited from class com.softwaremining.sql.ESQLProcessor

lastQuery, logger, preparedStatement, totalRuntime, totalRuntime_prepareFromFile, userDefinedConnection

Fields inherited from interface com.softwaremining.sql.SQLHandlerInterface

HANDLER_CONTINUE, HANDLER_GO_TO, HANDLER_METHOD_CALL, HANDLER_NOT_INTIALIZED, HANDLER_PERFORM, HANDLER_STOP, HANDLER_THROW, SQL_SCHEMA_PROP

Constructor Summary

Constructors

Constructor	Description
SPProcessor(ESQLBaseService owner)	Constructor
SPProcessor(ESQLBaseService owner, ISMBean sqlca)	constructor -

Method Summary

Modifier and Type	Method	Description
int	executeQuery()	Execute SQL Query.
protected void	prepareHelper(String sql)	prepare the underlying 'statement' or 'preparedStatement'
void	setOutParameter(int position, ISMObject valueHolder)	Bind output input parameters for prepared query
void	storedProcedureMode(boolean storedProcedureMode)

Methods inherited from class com.softwaremining.sql.ESQLProcessor

assignOutParameter, clearOutParameters, close, commit, createPreparedStatement, deleteRow, executeUpdate, executeUpdateThrowingSQLExpeption, fetch, forceCommit, forceRollback, formatSQL, getConnection, getDbPropertiesURI, getESQLBaseService, getPreparedStatement, getResultset, getRowCount, getSQLCA, isStatusAfterEndOfResultset, isStatusCursorNotOpenError, isStatusDuplicateInsert, isStatusError, isStatusMultipleEntries, isStatusNoEntry, isStatusNormal, isStatusNullReturn, isStatusOpenCloseError, isStatusTimeout, isStatusTimeoutNoTimeout, next, nextRow, openCursor, prepare, prepare, prepareSQLFromFile, prepareSQLFromFile, processSQLException, processSQLException, releaseConnection, releaseResources, resetSqlca, rollback, setBatchSize, setClearOutParametersOnGet, setConnection, setDbPropertiesURI, setFetchSize, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameter, setInParameterOn49Group, setInParameterOn49Group, setOutParameter, setOutParameter, setOutParameter, setOutParameterOn49Group, setOutParameterOn49Group, setOutParameterOn49Group, setOutParameterOn49Group, setSQLCA, setWithHold, updateColumnValue, updateColumnValue, updateColumnValue, updateColumnValue, updateColumnValue, updateColumnValue, updateColumnValue, updateColumnValue, updateColumnValue, updateRow

Methods inherited from class java.lang.Object

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

Constructor Details

SPProcessor

public SPProcessor(ESQLBaseService owner)

Constructor

Parameters:

owner -

SPProcessor

public SPProcessor(ESQLBaseService owner,
 ISMBean sqlca)

constructor -

Parameters:

owner -

sqlca -

Method Details

storedProcedureMode

public void storedProcedureMode(boolean storedProcedureMode)

executeQuery

public int executeQuery()
                 throws CBLException

Execute SQL Query. (used for "Select Statement" or for OPENing CURSORS ).

Overrides:

executeQuery in class ESQLProcessor

Throws:

CBLException

prepareHelper

protected void prepareHelper(String sql)
                      throws CBLException

prepare the underlying 'statement' or 'preparedStatement'

Overrides:

prepareHelper in class ESQLProcessor

Parameters:

sql -

Throws:

CBLException

setOutParameter

public void setOutParameter(int position,
 ISMObject valueHolder)

Bind output input parameters for prepared query

Parameters:

position - int

valueHolder - ACMObject