com.webmethods.portal.service.sql

Interface IStoredProcedure

public interface IStoredProcedure

Interface IStoredProcedure

Method Summary

Modifier and Type	Method and Description
ResultSet	executeQuery(ISqlWorker worker, Object[] args) Executes stored procedure and returns result set
Object[]	executeQuery(ISqlWorker worker, Object[] args, int[] outTypes) Executes stored procedure and return object array
int	executeUpdate(ISqlWorker worker, Object[] args) Executes update
String	getName() Returns the name of the stored procedure.
String	getPackageName() Returns optional package name for stored procedure.
void	setDatabaseRuntime(IDatabaseRuntime runtime)

Method Detail

getName

String getName()

Returns the name of the stored procedure. This name should match the name of the native stored procedure

Returns:

getPackageName

String getPackageName()

Returns optional package name for stored procedure. Package name is only used for databases which support packages (Oracle, DB2)

Returns:

executeQuery

ResultSet executeQuery(ISqlWorker worker,
                       Object[] args)
                throws SQLException,
                       ServerBusyException,
                       DeadlockException

Executes stored procedure and returns result set

Parameters:

worker - instance of ISqlWorker class that stored procedure should use to execute queries and manage transactional state

args - input arguments to the stored procedure

Returns:

stored procedure may return java.sql.ResultSet or Object[] for output parameters

Throws:

SQLException

ServerBusyException

DeadlockException

executeQuery

Object[] executeQuery(ISqlWorker worker,
                      Object[] args,
                      int[] outTypes)
               throws SQLException,
                      ServerBusyException,
                      DeadlockException

Executes stored procedure and return object array

Parameters:

worker -

args -

outTypes -

Returns:

Throws:

SQLException

ServerBusyException

DeadlockException

executeUpdate

int executeUpdate(ISqlWorker worker,
                  Object[] args)
           throws SQLException,
                  ServerBusyException,
                  DeadlockException

Executes update

Parameters:

worker -

args -

Returns:

number of updated records

Throws:

SQLException

ServerBusyException

DeadlockException

setDatabaseRuntime

void setDatabaseRuntime(IDatabaseRuntime runtime)