org.enhydra.shark.toolagent
Class ExecuteSqlTool
java.lang.Object
org.enhydra.shark.toolagent.AbstractToolAgent
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
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 |
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 |
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
ExecuteSqlTool
public ExecuteSqlTool()
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