Package com.saperion.operations

Class ExecuteStoredProcedure

java.lang.Object

com.lexmark.saperion.remote.common.operations.AbstractOperation<T,SaBasicException,LegacyConnection>

com.saperion.operations.LegacyOperation<com.lexmark.saperion.remote.common.operations.Void>

com.saperion.operations.VoidOperation

com.saperion.operations.ExecuteStoredProcedure

All Implemented Interfaces:

com.lexmark.saperion.remote.common.operations.Operation<com.lexmark.saperion.remote.common.operations.Void,SaBasicException,LegacyConnection>, Serializable

public class ExecuteStoredProcedure
extends VoidOperation

Executes a stored procedure on the database. Allows neither return value nor var parameters. Input parameters are allowed and are mapped as follows:

long	INT
integer	INT
short	INT
byte	INT
double	FLOAT
float	FLOAT
String	NVARCHAR
boolean	INT - 1 for true, 0 for false
Date	DATETIME2
Calendar	DATETIME2

See Also:

• Serialized Form

Constructor Summary

Constructors

Constructor	Description
ExecuteStoredProcedure(String name, String dataSource, Serializable... parameters)	Creates a new instance of ExecuteStoredProcedure that executes the given stored procedure on the database given by the data-source with the given parameters.
ExecuteStoredProcedure(String name, String dataSource, List<Serializable> parameters)	Creates a new instance of ExecuteStoredProcedure that executes the given stored procedure on the database given by the data-source with the given parameters.

Method Summary

Modifier and Type	Method	Description
String	toString()
protected void	voidInvoke()	Invokes this void operation.

Methods inherited from class com.saperion.operations.VoidOperation

afterInvoke, getResult, invoke

Methods inherited from class com.saperion.operations.LegacyOperation

beforeInvoke, beforeInvoke, getClientToken, mapEcmException, mapException

Methods inherited from class com.lexmark.saperion.remote.common.operations.AbstractOperation

toArrayList, toCaseInsensitiveMap, toHashMap

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.lexmark.saperion.remote.common.operations.Operation

audit, dispatchEvent, isAuditable, isEventDispatcher

Constructor Details

ExecuteStoredProcedure

public ExecuteStoredProcedure(String name,
 String dataSource,
 List<Serializable> parameters)

Creates a new instance of ExecuteStoredProcedure that executes the given stored procedure on the database given by the data-source with the given parameters.

Parameters:

name - The name of the procedure to execute

dataSource - The name of the data-source on whose database the procedure will be executed

parameters - The parameters given to the stored procedure. For type-mapping see ExecuteStoredProcedure

ExecuteStoredProcedure

public ExecuteStoredProcedure(String name,
 String dataSource,
 Serializable... parameters)

Creates a new instance of ExecuteStoredProcedure that executes the given stored procedure on the database given by the data-source with the given parameters.

Parameters:

name - The name of the procedure to execute

dataSource - The name of the data-source on whose database the procedure will be executed

parameters - The parameters given to the stored procedure. For type-mapping see ExecuteStoredProcedure

Method Details

voidInvoke

protected void voidInvoke()
                   throws Exception

Description copied from class: VoidOperation

Invokes this void operation.

Specified by:

voidInvoke in class VoidOperation

Throws:

Exception - exception when invoking this operation

toString

public String toString()

Overrides:

toString in class com.lexmark.saperion.remote.common.operations.AbstractOperation<com.lexmark.saperion.remote.common.operations.Void,SaBasicException,LegacyConnection>