public class DatabaseRouteNode extends Node
DatabaseRouteNode instance
The DatabaseRoute node is used to query and retrieve a single row from one or more tables within a database through JDBC. Selected column values can be inserted into filter expressions, used to propagate the incoming message down one or more dynamic output terminals. Which terminal is propagated to depends on filter expression resolving to true. These expressions may incoporate acqired database column values.
Change Activity: -------- ----------- ------------- ------------------------------------ Reason: Date: Originator: Comments: -------- ----------- ------------- ------------------------------------ xxxxx.x 2010-08-10 dstorey creation xxxxx.x xxxx-xx-xx generated 7.0.0.2 Release
Modifier and Type | Class and Description |
---|---|
static class |
DatabaseRouteNode.ENUM_DATABASEROUTE_DISTRIBUTIONMODE
ENUM_DATABASEROUTE_DISTRIBUTIONMODE
|
class |
DatabaseRouteNode.FilterTable
FilterTable instance contains FilterTableRow rows
|
class |
DatabaseRouteNode.FilterTableRow
FilterTableRow is used by FilterTable instance
|
class |
DatabaseRouteNode.QueryElementsRow
QueryElementsRow is used by QueryElementsTable instance
|
class |
DatabaseRouteNode.QueryElementsTable
QueryElementsTable instance contains QueryElementsRow rows
|
Node.RotationKind
Modifier and Type | Field and Description |
---|---|
InputTerminal |
INPUT_TERMINAL_IN |
OutputTerminal |
OUTPUT_TERMINAL_DEFAULT |
OutputTerminal |
OUTPUT_TERMINAL_FAILURE |
OutputTerminal |
OUTPUT_TERMINAL_KEYNOTFOUND |
Constructor and Description |
---|
DatabaseRouteNode() |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
getColumnNameComboValues()
Get the DatabaseRouteNode "ColumnNameComboValues" property
|
java.lang.String |
getDataSourceName()
Get the DatabaseRouteNode "Data source name" property
|
DatabaseRouteNode.ENUM_DATABASEROUTE_DISTRIBUTIONMODE |
getDistributionMode()
Get the DatabaseRouteNode "Distribution mode" property
|
DatabaseRouteNode.FilterTable |
getFilterTable()
Retrieve the Filter table table for the node DatabaseRouteNode
|
InputTerminal[] |
getInputTerminals()
Gets the full list of available InputTerminals for this Node
|
java.lang.String |
getNodeName()
Gets the label name of this node
|
java.lang.String |
getOperatorComboValues()
Get the DatabaseRouteNode "OperatorComboValues" property
|
OutputTerminal |
getOutputTerminal(java.lang.String terminalName)
Gets the output terminal for the node.
|
OutputTerminal[] |
getOutputTerminals()
Gets the full list of available OutputTerminals for this Node
|
DatabaseRouteNode.QueryElementsTable |
getQueryElementsTable()
Retrieve the Query elements table for the node DatabaseRouteNode
|
java.lang.String |
getSqlQuery()
Get the DatabaseRouteNode "SQL statement" property
|
java.lang.String |
getTableNameComboValues()
Get the DatabaseRouteNode "TableNameComboValues" property
|
java.lang.String |
getTypeName()
Gets the node type of this node
|
java.lang.String |
getValueComboValues()
Get the DatabaseRouteNode "ValueComboValues" property
|
java.lang.String |
getValueTypeComboValues()
Get the DatabaseRouteNode "ValueTypeComboValues" property
|
DatabaseRouteNode |
setColumnNameComboValues(java.lang.String value)
Set the DatabaseRouteNode "ColumnNameComboValues" property
|
DatabaseRouteNode |
setDataSourceName(java.lang.String value)
Set the DatabaseRouteNode "Data source name" property
|
DatabaseRouteNode |
setDistributionMode(DatabaseRouteNode.ENUM_DATABASEROUTE_DISTRIBUTIONMODE value)
Set the DatabaseRouteNode "Distribution mode" property
|
DatabaseRouteNode |
setOperatorComboValues(java.lang.String value)
Set the DatabaseRouteNode "OperatorComboValues" property
|
DatabaseRouteNode |
setSqlQuery(java.lang.String value)
Set the DatabaseRouteNode "SQL statement" property
|
DatabaseRouteNode |
setTableNameComboValues(java.lang.String value)
Set the DatabaseRouteNode "TableNameComboValues" property
|
DatabaseRouteNode |
setValueComboValues(java.lang.String value)
Set the DatabaseRouteNode "ValueComboValues" property
|
DatabaseRouteNode |
setValueTypeComboValues(java.lang.String value)
Set the DatabaseRouteNode "ValueTypeComboValues" property
|
addNsmapping, clone, findPropertyByName, getInputTerminal, getInputTerminal, getInstanceNodeProperties, getLocation, getLongDescription, getMandatoryPropertyNames, getNodePropertyTables, getNsmappingtables, getOutputTerminal, getPropertyDefaultValue, getPropertyNames, getPropertyValue, getRotate, getShortDescription, isUdpSupport, removeNsmapping, setLocation, setLocation, setLongDescription, setNodeName, setNsmappingtables, setProperty, setRotate, setShortDescription, toString
public final InputTerminal INPUT_TERMINAL_IN
public final OutputTerminal OUTPUT_TERMINAL_FAILURE
public final OutputTerminal OUTPUT_TERMINAL_KEYNOTFOUND
public final OutputTerminal OUTPUT_TERMINAL_DEFAULT
public DatabaseRouteNode.QueryElementsTable getQueryElementsTable()
public DatabaseRouteNode.FilterTable getFilterTable()
public InputTerminal[] getInputTerminals()
Node
getInputTerminals
in class Node
public OutputTerminal[] getOutputTerminals()
Node
getOutputTerminals
in class Node
public OutputTerminal getOutputTerminal(java.lang.String terminalName)
Node
getOutputTerminal
in class Node
public java.lang.String getTypeName()
Node
getTypeName
in class Node
public DatabaseRouteNode setDataSourceName(java.lang.String value)
String
- value; the value to set the property "Data source name"public java.lang.String getDataSourceName()
public DatabaseRouteNode setSqlQuery(java.lang.String value)
String
- value; the value to set the property "SQL statement"public java.lang.String getSqlQuery()
public DatabaseRouteNode setTableNameComboValues(java.lang.String value)
String
- value; the value to set the property "TableNameComboValues"public java.lang.String getTableNameComboValues()
public DatabaseRouteNode setColumnNameComboValues(java.lang.String value)
String
- value; the value to set the property "ColumnNameComboValues"public java.lang.String getColumnNameComboValues()
public DatabaseRouteNode setOperatorComboValues(java.lang.String value)
String
- value; the value to set the property "OperatorComboValues"public java.lang.String getOperatorComboValues()
public DatabaseRouteNode setValueTypeComboValues(java.lang.String value)
String
- value; the value to set the property "ValueTypeComboValues"public java.lang.String getValueTypeComboValues()
public DatabaseRouteNode setValueComboValues(java.lang.String value)
String
- value; the value to set the property "ValueComboValues"public java.lang.String getValueComboValues()
public DatabaseRouteNode setDistributionMode(DatabaseRouteNode.ENUM_DATABASEROUTE_DISTRIBUTIONMODE value)
ENUM_DATABASEROUTE_DISTRIBUTIONMODE
- value; the value to set the property "Distribution mode"public DatabaseRouteNode.ENUM_DATABASEROUTE_DISTRIBUTIONMODE getDistributionMode()
public java.lang.String getNodeName()
Node
MessageFlow mf1 = patternInstanceManager.getMessageFlow("MyFlowProject", "mf1.msgflow"); Node inputMQNode = mf1.getNodeByName("My Input Node"); inputMQNode.setNodeName("Renamed Input Node");
getNodeName
in class Node