public class DatabaseRetrieveNode extends Node
DatabaseRetrieveNode instance
The DatabaseRetrieve 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 new or existing locations within the incoming logical trees or a modified copy of the message tree can be made
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 |
---|---|
class |
DatabaseRetrieveNode.DataElementsRow
DataElementsRow is used by DataElementsTable instance
|
class |
DatabaseRetrieveNode.DataElementsTable
DataElementsTable instance contains DataElementsRow rows
|
static class |
DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEFAILUREACTION
ENUM_DATABASERETRIEVE_VALIDATEFAILUREACTION
|
static class |
DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEFIXUP
ENUM_DATABASERETRIEVE_VALIDATEFIXUP
|
static class |
DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEMASTER
ENUM_DATABASERETRIEVE_VALIDATEMASTER
|
class |
DatabaseRetrieveNode.QueryElementsRow
QueryElementsRow is used by QueryElementsTable instance
|
class |
DatabaseRetrieveNode.QueryElementsTable
QueryElementsTable instance contains QueryElementsRow rows
|
Node.RotationKind
Modifier and Type | Field and Description |
---|---|
InputTerminal |
INPUT_TERMINAL_IN |
OutputTerminal |
OUTPUT_TERMINAL_FAILURE |
OutputTerminal |
OUTPUT_TERMINAL_KEYNOTFOUND |
OutputTerminal |
OUTPUT_TERMINAL_OUT |
Constructor and Description |
---|
DatabaseRetrieveNode() |
Modifier and Type | Method and Description |
---|---|
boolean |
getAllRows()
Get the DatabaseRetrieveNode "Multiple rows" property
|
java.lang.String |
getColumnNameComboValues()
Get the DatabaseRetrieveNode "ColumnNameComboValues" property
|
java.lang.String |
getColumnValueComboValues()
Get the DatabaseRetrieveNode "ColumnValueComboValues" property
|
boolean |
getCopyMessage()
Get the DatabaseRetrieveNode "Copy message" property
|
DatabaseRetrieveNode.DataElementsTable |
getDataElementsTable()
Retrieve the Data elements table for the node DatabaseRetrieveNode
|
java.lang.String |
getDataSourceName()
Get the DatabaseRetrieveNode "Data source name" property
|
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 DatabaseRetrieveNode "OperatorComboValues" property
|
OutputTerminal[] |
getOutputTerminals()
Gets the full list of available OutputTerminals for this Node
|
DatabaseRetrieveNode.QueryElementsTable |
getQueryElementsTable()
Retrieve the Query elements table for the node DatabaseRetrieveNode
|
java.lang.String |
getSqlQuery()
Get the DatabaseRetrieveNode "SQL statement" property
|
java.lang.String |
getTableNameComboValues()
Get the DatabaseRetrieveNode "TableNameComboValues" property
|
java.lang.String |
getTypeName()
Gets the node type of this node
|
boolean |
getValidateAllValueConstraints()
Get the DatabaseRetrieveNode "Include all value constraints" property
|
DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEFAILUREACTION |
getValidateFailureAction()
Get the DatabaseRetrieveNode "Failure action" property
|
DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEFIXUP |
getValidateFixup()
Get the DatabaseRetrieveNode "Fix" property
|
DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEMASTER |
getValidateMaster()
Get the DatabaseRetrieveNode "Validate" property
|
java.lang.String |
getValueComboValues()
Get the DatabaseRetrieveNode "ValueComboValues" property
|
java.lang.String |
getValueTypeComboValues()
Get the DatabaseRetrieveNode "ValueTypeComboValues" property
|
DatabaseRetrieveNode |
setAllRows(boolean value)
Set the DatabaseRetrieveNode "Multiple rows" property
|
DatabaseRetrieveNode |
setColumnNameComboValues(java.lang.String value)
Set the DatabaseRetrieveNode "ColumnNameComboValues" property
|
DatabaseRetrieveNode |
setColumnValueComboValues(java.lang.String value)
Set the DatabaseRetrieveNode "ColumnValueComboValues" property
|
DatabaseRetrieveNode |
setCopyMessage(boolean value)
Set the DatabaseRetrieveNode "Copy message" property
|
DatabaseRetrieveNode |
setDataSourceName(java.lang.String value)
Set the DatabaseRetrieveNode "Data source name" property
|
DatabaseRetrieveNode |
setOperatorComboValues(java.lang.String value)
Set the DatabaseRetrieveNode "OperatorComboValues" property
|
DatabaseRetrieveNode |
setSqlQuery(java.lang.String value)
Set the DatabaseRetrieveNode "SQL statement" property
|
DatabaseRetrieveNode |
setTableNameComboValues(java.lang.String value)
Set the DatabaseRetrieveNode "TableNameComboValues" property
|
DatabaseRetrieveNode |
setValidateAllValueConstraints(boolean value)
Set the DatabaseRetrieveNode "Include all value constraints" property
|
DatabaseRetrieveNode |
setValidateFailureAction(DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEFAILUREACTION value)
Set the DatabaseRetrieveNode "Failure action" property
|
DatabaseRetrieveNode |
setValidateFixup(DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEFIXUP value)
Set the DatabaseRetrieveNode "Fix" property
|
DatabaseRetrieveNode |
setValidateMaster(DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEMASTER value)
Set the DatabaseRetrieveNode "Validate" property
|
DatabaseRetrieveNode |
setValueComboValues(java.lang.String value)
Set the DatabaseRetrieveNode "ValueComboValues" property
|
DatabaseRetrieveNode |
setValueTypeComboValues(java.lang.String value)
Set the DatabaseRetrieveNode "ValueTypeComboValues" property
|
addNsmapping, clone, findPropertyByName, getInputTerminal, getInputTerminal, getInstanceNodeProperties, getLocation, getLongDescription, getMandatoryPropertyNames, getNodePropertyTables, getNsmappingtables, getOutputTerminal, 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_OUT
public final OutputTerminal OUTPUT_TERMINAL_KEYNOTFOUND
public final OutputTerminal OUTPUT_TERMINAL_FAILURE
public DatabaseRetrieveNode.QueryElementsTable getQueryElementsTable()
public DatabaseRetrieveNode.DataElementsTable getDataElementsTable()
public InputTerminal[] getInputTerminals()
Node
getInputTerminals
in class Node
public OutputTerminal[] getOutputTerminals()
Node
getOutputTerminals
in class Node
public java.lang.String getTypeName()
Node
getTypeName
in class Node
public DatabaseRetrieveNode setDataSourceName(java.lang.String value)
value
- String ; the value to set the property "Data source name"public java.lang.String getDataSourceName()
public DatabaseRetrieveNode setCopyMessage(boolean value)
value
- boolean ; the value to set the property "Copy message"public boolean getCopyMessage()
public DatabaseRetrieveNode setAllRows(boolean value)
value
- boolean ; the value to set the property "Multiple rows"public boolean getAllRows()
public DatabaseRetrieveNode setSqlQuery(java.lang.String value)
value
- String ; the value to set the property "SQL statement"public java.lang.String getSqlQuery()
public DatabaseRetrieveNode setTableNameComboValues(java.lang.String value)
value
- String ; the value to set the property "TableNameComboValues"public java.lang.String getTableNameComboValues()
public DatabaseRetrieveNode setColumnNameComboValues(java.lang.String value)
value
- String ; the value to set the property "ColumnNameComboValues"public java.lang.String getColumnNameComboValues()
public DatabaseRetrieveNode setOperatorComboValues(java.lang.String value)
value
- String ; the value to set the property "OperatorComboValues"public java.lang.String getOperatorComboValues()
public DatabaseRetrieveNode setValueTypeComboValues(java.lang.String value)
value
- String ; the value to set the property "ValueTypeComboValues"public java.lang.String getValueTypeComboValues()
public DatabaseRetrieveNode setValueComboValues(java.lang.String value)
value
- String ; the value to set the property "ValueComboValues"public java.lang.String getValueComboValues()
public DatabaseRetrieveNode setColumnValueComboValues(java.lang.String value)
value
- String ; the value to set the property "ColumnValueComboValues"public java.lang.String getColumnValueComboValues()
public DatabaseRetrieveNode setValidateMaster(DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEMASTER value)
value
- ENUM_DATABASERETRIEVE_VALIDATEMASTER ; the value to set the property "Validate"public DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEMASTER getValidateMaster()
public DatabaseRetrieveNode setValidateFailureAction(DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEFAILUREACTION value)
value
- ENUM_DATABASERETRIEVE_VALIDATEFAILUREACTION ; the value to set the property "Failure action"public DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEFAILUREACTION getValidateFailureAction()
public DatabaseRetrieveNode setValidateAllValueConstraints(boolean value)
value
- boolean ; the value to set the property "Include all value constraints"public boolean getValidateAllValueConstraints()
public DatabaseRetrieveNode setValidateFixup(DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEFIXUP value)
value
- ENUM_DATABASERETRIEVE_VALIDATEFIXUP ; the value to set the property "Fix"public DatabaseRetrieveNode.ENUM_DATABASERETRIEVE_VALIDATEFIXUP getValidateFixup()
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