org.enhydra.shark.toolagent
Class ExecuteSqlTool

java.lang.Object
  extended by org.enhydra.shark.toolagent.AbstractToolAgent
      extended by org.enhydra.shark.toolagent.ExecuteSqlTool
All Implemented Interfaces:
ToolAgent

public class ExecuteSqlTool
extends AbstractToolAgent

Tool agent for SQL statements execution. Parameters are mapped by name and there are two possible combinations: first: statement(full expression for execute)+ data_source + row_count ( updated rows number - optional) OR second: prepared_statement + data_source + row_count (optional) + parameters for prepared_statement In tne case when only the "statement" is given, tool doesn't take care about unknown paramerers. "statement" must be full and valid. When "prepered_statement" is used all needed parameters must be set in the same order as "prepared_statement" expects them.

Version:
1.0
Author:
Svjetlana Milidrag

Field Summary
static java.lang.String DATA_SOURCE
           
protected  java.lang.String dataSrc
           
static java.lang.String PREPARED_STATEMENT
           
static java.lang.String ROW_COUNT
           
protected  java.lang.String rowCount
           
protected  java.lang.String statement
           
static java.lang.String STATEMENT
           
 
Fields inherited from class org.enhydra.shark.toolagent.AbstractToolAgent
APP_MODE_EXT_ATTR_NAME, APP_NAME_EXT_ATTR_NAME, appInfo, appMode, appName, assId, COMMA_SEPARATOR_STR, cus, extAttributes, handle, parameters, procInstId, SEMICOLON_SEPARATOR_STR, shandle, status, tashandle, toolInfo, wmci
 
Fields inherited from interface org.enhydra.shark.api.internal.toolagent.ToolAgent
APP_STATUS_ACTIVE, APP_STATUS_FINISHED, APP_STATUS_INVALID, APP_STATUS_RUNNING, APP_STATUS_TERMINATED, APP_STATUS_WAITING
 
Constructor Summary
ExecuteSqlTool()
           
 
Method Summary
protected  void initParameters(java.sql.PreparedStatement stmt)
           
protected  void initStatement(java.sql.Connection conn)
           
 void invokeApplication(WMSessionHandle _shandle, long _handle, WMEntity _appInfo, WMEntity _toolInfo, java.lang.String _applicationName, java.lang.String _procInstId, java.lang.String _assId, AppParameter[] _parameters, java.lang.Integer _appMode)
           
 
Methods inherited from class org.enhydra.shark.toolagent.AbstractToolAgent
configure, connect, copyParams, disconnect, getInfo, getParameterByName, getParameterString, getParameterStringArray, getReturnParameters, readParamsFromExtAttributes, requestAppStatus, terminateApp
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

STATEMENT

public static final java.lang.String STATEMENT
See Also:
Constant Field Values

PREPARED_STATEMENT

public static final java.lang.String PREPARED_STATEMENT
See Also:
Constant Field Values

DATA_SOURCE

public static final java.lang.String DATA_SOURCE
See Also:
Constant Field Values

ROW_COUNT

public static final java.lang.String ROW_COUNT
See Also:
Constant Field Values

statement

protected java.lang.String statement

dataSrc

protected java.lang.String dataSrc

rowCount

protected java.lang.String rowCount
Constructor Detail

ExecuteSqlTool

public ExecuteSqlTool()
Method Detail

invokeApplication

public void invokeApplication(WMSessionHandle _shandle,
                              long _handle,
                              WMEntity _appInfo,
                              WMEntity _toolInfo,
                              java.lang.String _applicationName,
                              java.lang.String _procInstId,
                              java.lang.String _assId,
                              AppParameter[] _parameters,
                              java.lang.Integer _appMode)
                       throws ApplicationNotStarted,
                              ApplicationNotDefined,
                              ApplicationBusy,
                              ToolAgentGeneralException
Specified by:
invokeApplication in interface ToolAgent
Overrides:
invokeApplication in class AbstractToolAgent
Throws:
ApplicationNotStarted
ApplicationNotDefined
ApplicationBusy
ToolAgentGeneralException

initStatement

protected void initStatement(java.sql.Connection conn)
                      throws java.lang.Exception
Throws:
java.lang.Exception

initParameters

protected void initParameters(java.sql.PreparedStatement stmt)
                       throws java.lang.Exception
Throws:
java.lang.Exception