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. The message is propagated to the terminal for which the filter expression is true. These expressions might incorporate acquired database column names.
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 |
protected static java.lang.String |
NODE_GRAPHIC_16 |
protected static java.lang.String |
NODE_GRAPHIC_32 |
protected static java.lang.String |
NODE_TYPE_NAME |
OutputTerminal |
OUTPUT_TERMINAL_DEFAULT |
OutputTerminal |
OUTPUT_TERMINAL_FAILURE |
OutputTerminal |
OUTPUT_TERMINAL_KEYNOTFOUND |
protected static java.lang.String |
PROPERTY_COLUMNNAMECOMBOVALUES |
protected static java.lang.String |
PROPERTY_DATASOURCENAME |
protected static java.lang.String |
PROPERTY_DISTRIBUTIONMODE |
protected static java.lang.String |
PROPERTY_OPERATORCOMBOVALUES |
protected static java.lang.String |
PROPERTY_SQLQUERY |
protected static java.lang.String |
PROPERTY_TABLENAMECOMBOVALUES |
protected static java.lang.String |
PROPERTY_VALUECOMBOVALUES |
protected static java.lang.String |
PROPERTY_VALUETYPECOMBOVALUES |
copyright, dynamicInputTerminals, dynamicOutputTerminals, nodePropertyTables, udpSupport
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
|
protected java.lang.String |
getGraphic16() |
protected java.lang.String |
getGraphic32() |
InputTerminal[] |
getInputTerminals()
Gets the full list of available InputTerminals for this Node
|
java.lang.String |
getNodeName()
Gets the label name of this node
|
protected NodeProperty[] |
getNodeProperties()
Returns the list of simple properties which are available to set on this node
No instance values are set here.
|
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
|
addAdditionalProperty, addMonitorEvent, addNsmapping, clone, createNewInputTerminal, createNewInputTerminal, createNewOutputTerminal, createNewOutputTerminal, findPropertyByName, getAllNodeProperties, getInputTerminal, getInputTerminal, getInstanceNodeProperties, getLocation, getLongDescription, getMandatoryPropertyNames, getMonitorEvents, getNodeId, getNodePropertyTables, getNsmappingtables, getOutputTerminal, getPropertyDefaultValue, getPropertyNames, getPropertyValue, getRotate, getShortDescription, getUUID, isUdpSupport, removeMonitorEvent, removeNsmapping, setLocation, setLocation, setLongDescription, setMonitorEvents, setNodeId, setNodeName, setNsmappingtables, setProperty, setRotate, setShortDescription, toString
protected static final java.lang.String NODE_TYPE_NAME
protected static final java.lang.String NODE_GRAPHIC_16
protected static final java.lang.String NODE_GRAPHIC_32
protected static final java.lang.String PROPERTY_DATASOURCENAME
protected static final java.lang.String PROPERTY_SQLQUERY
protected static final java.lang.String PROPERTY_TABLENAMECOMBOVALUES
protected static final java.lang.String PROPERTY_COLUMNNAMECOMBOVALUES
protected static final java.lang.String PROPERTY_OPERATORCOMBOVALUES
protected static final java.lang.String PROPERTY_VALUETYPECOMBOVALUES
protected static final java.lang.String PROPERTY_VALUECOMBOVALUES
protected static final java.lang.String PROPERTY_DISTRIBUTIONMODE
public final InputTerminal INPUT_TERMINAL_IN
public final OutputTerminal OUTPUT_TERMINAL_KEYNOTFOUND
public final OutputTerminal OUTPUT_TERMINAL_DEFAULT
public final OutputTerminal OUTPUT_TERMINAL_FAILURE
protected NodeProperty[] getNodeProperties()
Node
getNodeProperties
in class Node
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
terminalName
- String; the internal terminal namepublic java.lang.String getTypeName()
Node
getTypeName
in class Node
protected java.lang.String getGraphic16()
protected java.lang.String getGraphic32()
public DatabaseRouteNode setDataSourceName(java.lang.String value)
value
- String ; the value to set the property "Data source name"public java.lang.String getDataSourceName()
public DatabaseRouteNode setSqlQuery(java.lang.String value)
value
- String ; the value to set the property "SQL statement"public java.lang.String getSqlQuery()
public DatabaseRouteNode setTableNameComboValues(java.lang.String value)
value
- String ; the value to set the property "TableNameComboValues"public java.lang.String getTableNameComboValues()
public DatabaseRouteNode setColumnNameComboValues(java.lang.String value)
value
- String ; the value to set the property "ColumnNameComboValues"public java.lang.String getColumnNameComboValues()
public DatabaseRouteNode setOperatorComboValues(java.lang.String value)
value
- String ; the value to set the property "OperatorComboValues"public java.lang.String getOperatorComboValues()
public DatabaseRouteNode setValueTypeComboValues(java.lang.String value)
value
- String ; the value to set the property "ValueTypeComboValues"public java.lang.String getValueTypeComboValues()
public DatabaseRouteNode setValueComboValues(java.lang.String value)
value
- String ; the value to set the property "ValueComboValues"public java.lang.String getValueComboValues()
public DatabaseRouteNode setDistributionMode(DatabaseRouteNode.ENUM_DATABASEROUTE_DISTRIBUTIONMODE value)
value
- ENUM_DATABASEROUTE_DISTRIBUTIONMODE ; 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