com.syncsoft.plainsql
Class ProcedureResult

java.lang.Object
  com.syncsoft.plainsql.ProcedureResult

public class ProcedureResult
extends java.lang.Object

An object that represents all the outputs from a stored procedure execution inluding all result sets and output parameters (which are also returned into the variables provided during execution of course.

Constructor Summary

ProcedureResult(PlainProc procName, java.lang.Object... procParameters)
Create a procedure result structure.

Method Summary

java.lang.Object	getOutParameter(int outParameter) Get value of an output parameter
java.sql.ParameterMetaData	getParameterMetaData()
java.util.ArrayList<java.lang.Object>	getParameterValues()
RowSet	getRowSet(int rowSetNumber) Get a specific rowset from the procedure output
int	getRowSetCount()
java.util.ArrayList<RowSet>	getRowSets()

Methods inherited from class java.lang.Object

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

Constructor Detail

ProcedureResult

public ProcedureResult(PlainProc procName,
                       java.lang.Object... procParameters)
                throws java.sql.SQLException

Create a procedure result structure. This effectively means executing the procedure and storing all result sets and output variable values in the ProcedureResult object. So it could be a little heavhy on memory

Parameters:

procName - name of the stored procedure

procParameters - array of parameters to the stored procedure

Throws:

java.sql.SQLException

Method Detail

getOutParameter

public java.lang.Object getOutParameter(int outParameter)
                                 throws java.sql.SQLException

Get value of an output parameter

Parameters:

outParameter - - parameter number (starting at 1)

Returns:

Throws:

java.sql.SQLException

getRowSet

public RowSet getRowSet(int rowSetNumber)
                 throws java.sql.SQLException

Get a specific rowset from the procedure output

Parameters:

rowSetNumber - rowset identifier (starting from 1)

Returns:

Throws:

java.sql.SQLException

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()

Returns:

Returns the parameterMetaData for the procedure.

getParameterValues

public java.util.ArrayList<java.lang.Object> getParameterValues()

Returns:

Returns an arraylist of parameter values. Only OUT or INOUT parameters will have a value.

getRowSets

public java.util.ArrayList<RowSet> getRowSets()

Returns:

Returns an array of rowSets representing all the result sets returned by the procedure call

getRowSetCount

public int getRowSetCount()

Returns:

Returns the rowSetCount.