Package wt.query

Class CompoundQuerySpec

java.lang.Object
wt.query.CompoundQuerySpec
All Implemented Interfaces:
Externalizable, Serializable, Cloneable, StatementSpec, wt.query.CloneableStatementSpec, wt.query.CompoundComponentStatementSpec
public class CompoundQuerySpec extends Object implements wt.query.CloneableStatementSpec, wt.query.CompoundComponentStatementSpec, Externalizable
This class provides the functionality to build a compound query statement.

Any number of components can be added to the Compound Query (Two are required for a valid compound SQL statement). A single Set Operator can be specified.

The SQL statement is built from left to right using the components with the lowest index to the highest index. If precedence is significant, the components with equal precedence should be added to a separate instance and nested within another CompoundQuerySpec instance.

Supported API: true

Extendable: false

See Also:

  • Field Summary

    Fields inherited from interface wt.pds.StatementSpec

    ADVANCED_QUERY_ENABLED, USE_BIND

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    addComponent(StatementSpec a_statementSpec)
    This method adds a component statement.
    void
    appendOrderBy(OrderBy a_orderBy)
    Appends an Order By expression to the compund query.
    SetOperator
    getSetOperator()
    Gets the object for the association that plays role: setOperator.
    boolean
    isAdvancedQueryEnabled()
    Gets the value of the attribute: advancedQueryEnabled; Indicates if advanced query capabilities are enabled.
    boolean
    isIncludeNestedParantheses()
    Gets the value of the attribute: includeNestedParantheses; Indicates if parantheses should be included for nested statements.
    boolean
    isUseBind()
    Gets the value of the attribute: useBind; Indicates if bind parameters should be used for this statement.
    void
    setAdvancedQueryEnabled(boolean a_AdvancedQueryEnabled)
    Sets the value of the attribute: advancedQueryEnabled; Indicates if advanced query capabilities are enabled.
    void
    setIncludeNestedParantheses(boolean a_IncludeNestedParantheses)
    Sets the value of the attribute: includeNestedParantheses; Indicates if parantheses should be included for nested statements.
    void
    setSetOperator(SetOperator a_SetOperator)
    Sets the object for the association that plays role: setOperator.
    void
    setUseBind(boolean a_UseBind)
    Sets the value of the attribute: useBind; Indicates if bind parameters should be used for this statement.

    Methods inherited from class java.lang.Object

    equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

  • Method Details

    • isAdvancedQueryEnabled

      public boolean isAdvancedQueryEnabled()
      Gets the value of the attribute: advancedQueryEnabled; Indicates if advanced query capabilities are enabled. By design, this attribute is transient and its value is not passed between Java Virtual Machine (JVM) processes. The value should be set within the same JVM process that executes the statement.

      Supported API: true
      Specified by:
      isAdvancedQueryEnabled in interface StatementSpec
      Returns:
      boolean

    • setAdvancedQueryEnabled

      public void setAdvancedQueryEnabled(boolean a_AdvancedQueryEnabled)
      Sets the value of the attribute: advancedQueryEnabled; Indicates if advanced query capabilities are enabled. By design, this attribute is transient and its value is not passed between Java Virtual Machine (JVM) processes. The value should be set within the same JVM process that executes the statement.

      Supported API: true
      Specified by:
      setAdvancedQueryEnabled in interface StatementSpec
      Parameters:
      a_AdvancedQueryEnabled -

    • getSetOperator

      public SetOperator getSetOperator()
      Gets the object for the association that plays role: setOperator.

      Supported API: true
      Returns:
      SetOperator

    • setSetOperator

      public void setSetOperator(SetOperator a_SetOperator) throws WTPropertyVetoException
      Sets the object for the association that plays role: setOperator.

      Supported API: true
      Parameters:
      a_SetOperator -
      Throws:
      WTPropertyVetoException

    • addComponent

      public void addComponent(StatementSpec a_statementSpec)
      This method adds a component statement.

      Supported API: true
      Parameters:
      a_statementSpec - Component statement to add

    • appendOrderBy

      public void appendOrderBy(OrderBy a_orderBy) throws QueryException
      Appends an Order By expression to the compund query. The ColumnExpression contained in the OrderBy should have a column alias set.

      Supported API: true
      Parameters:
      a_orderBy - OrderBy object to append
      Throws:
      QueryException

    • isUseBind

      public boolean isUseBind()
      Gets the value of the attribute: useBind; Indicates if bind parameters should be used for this statement.

      Supported API: true
      Specified by:
      isUseBind in interface StatementSpec
      Returns:
      boolean

    • setUseBind

      public void setUseBind(boolean a_UseBind) throws WTPropertyVetoException
      Sets the value of the attribute: useBind; Indicates if bind parameters should be used for this statement.

      Supported API: true
      Specified by:
      setUseBind in interface StatementSpec
      Parameters:
      a_UseBind -
      Throws:
      WTPropertyVetoException

    • isIncludeNestedParantheses

      public boolean isIncludeNestedParantheses()
      Gets the value of the attribute: includeNestedParantheses; Indicates if parantheses should be included for nested statements. This should always be included, but an Oracle bug can occur for top level statements. This attribute can be used as a workaround.

      Supported API: true
      Returns:
      boolean

    • setIncludeNestedParantheses

      public void setIncludeNestedParantheses(boolean a_IncludeNestedParantheses)
      Sets the value of the attribute: includeNestedParantheses; Indicates if parantheses should be included for nested statements. This should always be included, but an Oracle bug can occur for top level statements. This attribute can be used as a workaround.

      Supported API: true
      Parameters:
      a_IncludeNestedParantheses -