com.ibm.broker.config.appdev.nodes

Class DatabaseRetrieveNode

  • All Implemented Interfaces:
    java.io.Serializable, java.lang.Cloneable


    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
     
    See Also:
    Serialized Form
    • Field Detail

      • INPUT_TERMINAL_IN

        public final InputTerminal INPUT_TERMINAL_IN
      • OUTPUT_TERMINAL_KEYNOTFOUND

        public final OutputTerminal OUTPUT_TERMINAL_KEYNOTFOUND
      • OUTPUT_TERMINAL_FAILURE

        public final OutputTerminal OUTPUT_TERMINAL_FAILURE
      • OUTPUT_TERMINAL_OUT

        public final OutputTerminal OUTPUT_TERMINAL_OUT
    • Constructor Detail

      • DatabaseRetrieveNode

        public DatabaseRetrieveNode()
    • Method Detail

      • getQueryElementsTable

        public DatabaseRetrieveNode.QueryElementsTable getQueryElementsTable()
        Retrieve the Query elements table for the node DatabaseRetrieveNode
        Returns:
        QueryElementsTable instance which contains QueryElementsRow rows
      • getDataElementsTable

        public DatabaseRetrieveNode.DataElementsTable getDataElementsTable()
        Retrieve the Data elements table for the node DatabaseRetrieveNode
        Returns:
        DataElementsTable instance which contains DataElementsRow rows
      • getInputTerminals

        public InputTerminal[] getInputTerminals()
        Description copied from class: Node
        Gets the full list of available InputTerminals for this Node
        Specified by:
        getInputTerminals in class Node
        Returns:
        InputTerminal[]
      • getOutputTerminals

        public OutputTerminal[] getOutputTerminals()
        Description copied from class: Node
        Gets the full list of available OutputTerminals for this Node
        Specified by:
        getOutputTerminals in class Node
        Returns:
        OutputTerminal[]
      • getTypeName

        public java.lang.String getTypeName()
        Description copied from class: Node
        Gets the node type of this node
        Specified by:
        getTypeName in class Node
        Returns:
        String; the node type
      • setDataSourceName

        public DatabaseRetrieveNode setDataSourceName(java.lang.String value)
        Set the DatabaseRetrieveNode "Data source name" property
        Parameters:
        value - String ; the value to set the property "Data source name"
      • getDataSourceName

        public java.lang.String getDataSourceName()
        Get the DatabaseRetrieveNode "Data source name" property
        Returns:
        String; the value of the property "Data source name"
      • setCopyMessage

        public DatabaseRetrieveNode setCopyMessage(boolean value)
        Set the DatabaseRetrieveNode "Copy message" property
        Parameters:
        value - boolean ; the value to set the property "Copy message"
      • getCopyMessage

        public boolean getCopyMessage()
        Get the DatabaseRetrieveNode "Copy message" property
        Returns:
        boolean; the value of the property "Copy message"
      • setAllRows

        public DatabaseRetrieveNode setAllRows(boolean value)
        Set the DatabaseRetrieveNode "Multiple rows" property
        Parameters:
        value - boolean ; the value to set the property "Multiple rows"
      • getAllRows

        public boolean getAllRows()
        Get the DatabaseRetrieveNode "Multiple rows" property
        Returns:
        boolean; the value of the property "Multiple rows"
      • setSqlQuery

        public DatabaseRetrieveNode setSqlQuery(java.lang.String value)
        Set the DatabaseRetrieveNode "SQL statement" property
        Parameters:
        value - String ; the value to set the property "SQL statement"
      • getSqlQuery

        public java.lang.String getSqlQuery()
        Get the DatabaseRetrieveNode "SQL statement" property
        Returns:
        String; the value of the property "SQL statement"
      • setTableNameComboValues

        public DatabaseRetrieveNode setTableNameComboValues(java.lang.String value)
        Set the DatabaseRetrieveNode "TableNameComboValues" property
        Parameters:
        value - String ; the value to set the property "TableNameComboValues"
      • getTableNameComboValues

        public java.lang.String getTableNameComboValues()
        Get the DatabaseRetrieveNode "TableNameComboValues" property
        Returns:
        String; the value of the property "TableNameComboValues"
      • setColumnNameComboValues

        public DatabaseRetrieveNode setColumnNameComboValues(java.lang.String value)
        Set the DatabaseRetrieveNode "ColumnNameComboValues" property
        Parameters:
        value - String ; the value to set the property "ColumnNameComboValues"
      • getColumnNameComboValues

        public java.lang.String getColumnNameComboValues()
        Get the DatabaseRetrieveNode "ColumnNameComboValues" property
        Returns:
        String; the value of the property "ColumnNameComboValues"
      • setOperatorComboValues

        public DatabaseRetrieveNode setOperatorComboValues(java.lang.String value)
        Set the DatabaseRetrieveNode "OperatorComboValues" property
        Parameters:
        value - String ; the value to set the property "OperatorComboValues"
      • getOperatorComboValues

        public java.lang.String getOperatorComboValues()
        Get the DatabaseRetrieveNode "OperatorComboValues" property
        Returns:
        String; the value of the property "OperatorComboValues"
      • setValueTypeComboValues

        public DatabaseRetrieveNode setValueTypeComboValues(java.lang.String value)
        Set the DatabaseRetrieveNode "ValueTypeComboValues" property
        Parameters:
        value - String ; the value to set the property "ValueTypeComboValues"
      • getValueTypeComboValues

        public java.lang.String getValueTypeComboValues()
        Get the DatabaseRetrieveNode "ValueTypeComboValues" property
        Returns:
        String; the value of the property "ValueTypeComboValues"
      • setValueComboValues

        public DatabaseRetrieveNode setValueComboValues(java.lang.String value)
        Set the DatabaseRetrieveNode "ValueComboValues" property
        Parameters:
        value - String ; the value to set the property "ValueComboValues"
      • getValueComboValues

        public java.lang.String getValueComboValues()
        Get the DatabaseRetrieveNode "ValueComboValues" property
        Returns:
        String; the value of the property "ValueComboValues"
      • setColumnValueComboValues

        public DatabaseRetrieveNode setColumnValueComboValues(java.lang.String value)
        Set the DatabaseRetrieveNode "ColumnValueComboValues" property
        Parameters:
        value - String ; the value to set the property "ColumnValueComboValues"
      • getColumnValueComboValues

        public java.lang.String getColumnValueComboValues()
        Get the DatabaseRetrieveNode "ColumnValueComboValues" property
        Returns:
        String; the value of the property "ColumnValueComboValues"
      • setValidateAllValueConstraints

        public DatabaseRetrieveNode setValidateAllValueConstraints(boolean value)
        Set the DatabaseRetrieveNode "Include all value constraints" property
        Parameters:
        value - boolean ; the value to set the property "Include all value constraints"
      • getValidateAllValueConstraints

        public boolean getValidateAllValueConstraints()
        Get the DatabaseRetrieveNode "Include all value constraints" property
        Returns:
        boolean; the value of the property "Include all value constraints"
      • getNodeName

        public java.lang.String getNodeName()
        Description copied from class: Node
        Gets the label name of this node
          MessageFlow mf1 = patternInstanceManager.getMessageFlow("MyFlowProject", "mf1.msgflow");
          Node inputMQNode = mf1.getNodeByName("My Input Node");
          inputMQNode.setNodeName("Renamed Input Node");
         
        Overrides:
        getNodeName in class Node
        Returns:
        String; the node name