Class ExecuteStoredProcedure

  • All Implemented Interfaces:
    com.lexmark.saperion.remote.common.operations.Operation<com.lexmark.saperion.remote.common.operations.Void,​SaBasicException,​LegacyConnection>, java.io.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:
    longINT
    integerINT
    shortINT
    byteINT
    doubleFLOAT
    floatFLOAT
    StringNVARCHAR
    booleanINT - 1 for true, 0 for false
    DateDATETIME2
    CalendarDATETIME2
    See Also:
    Serialized Form
    • Constructor Summary

      Constructors 
      Constructor Description
      ExecuteStoredProcedure​(java.lang.String name, java.lang.String dataSource, java.io.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​(java.lang.String name, java.lang.String dataSource, java.util.List<java.io.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.
    • Constructor Detail

      • ExecuteStoredProcedure

        public ExecuteStoredProcedure​(java.lang.String name,
                                      java.lang.String dataSource,
                                      java.util.List<java.io.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​(java.lang.String name,
                                      java.lang.String dataSource,
                                      java.io.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 Detail

      • voidInvoke

        protected void voidInvoke()
                           throws java.lang.Exception
        Description copied from class: VoidOperation
        Invokes this void operation.
        Specified by:
        voidInvoke in class VoidOperation
        Throws:
        java.lang.Exception - exception when invoking this operation
      • toString

        public java.lang.String toString()
        Overrides:
        toString in class com.lexmark.saperion.remote.common.operations.AbstractOperation<com.lexmark.saperion.remote.common.operations.Void,​SaBasicException,​LegacyConnection>