com.ibm.broker.config.appdev.nodes

Class DatabaseRouteNode

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


    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
     
    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_DEFAULT

        public final OutputTerminal OUTPUT_TERMINAL_DEFAULT
    • Constructor Detail

      • DatabaseRouteNode

        public DatabaseRouteNode()
    • Method Detail

      • getQueryElementsTable

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

        public DatabaseRouteNode.FilterTable getFilterTable()
        Retrieve the Filter table table for the node DatabaseRouteNode
        Returns:
        FilterTable instance which contains FilterTableRow 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[]
      • getOutputTerminal

        public OutputTerminal getOutputTerminal(java.lang.String terminalName)
        Description copied from class: Node
        Gets the output terminal for the node. If the terminal is a dynamic terminal this will create the terminal and return it.
        Overrides:
        getOutputTerminal in class Node
        Parameters:
        terminalName - String; the internal terminal name
        Returns:
        an 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 DatabaseRouteNode setDataSourceName(java.lang.String value)
        Set the DatabaseRouteNode "Data source name" property
        Parameters:
        value - String ; the value to set the property "Data source name"
      • getDataSourceName

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

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

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

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

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

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

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

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

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

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

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

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

        public java.lang.String getValueComboValues()
        Get the DatabaseRouteNode "ValueComboValues" property
        Returns:
        String; the value of the property "ValueComboValues"
      • 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