Skip navigation links

oracle.bpel.services.workflow.repos
Class Ordering

java.lang.Object
oracle.bpel.services.workflow.repos.Ordering

All Implemented Interfaces:

java.io.Serializable

public class Ordering

extends java.lang.Object

implements java.io.Serializable

See Also:

Serialized Form

Field Summary

static java.lang.String	ASCENDING_ORDER Ascending order
static java.lang.String	ASCSTRING For ascending order
static java.lang.String	DESCENDING_ORDER Descending order
static java.lang.String	DESCSTRING For descending order

Constructor Summary

Ordering(Column column, boolean isAscending, boolean isNullFirst)
Constructor to create the Ordering.

Ordering(java.util.List<OrderingClauseType> clauses)
Constructs an Ordering object from a list of OrderingClauseType objects.

Method Summary

void	addClause(Column column, boolean isAscending, boolean isNullFirst) To add the more orderby columns.
java.lang.String	getOrderBy() Deprecated. since 11.1.1.2.0
java.util.List<java.lang.String>	getOrderColumns() Returns the list of columns in the orderby part of the resulting SQL statement
java.util.List<OrderingClauseType>	getOrderingClauseList() getOrderingClauseList returns the ordering clause list
java.lang.String	toString() Returns String representation of the Ordering object.

Methods inherited from class java.lang.Object

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

Field Detail

ASCSTRING

public static final java.lang.String ASCSTRING

For ascending order

See Also:

Constant Field Values

DESCSTRING

public static final java.lang.String DESCSTRING

For descending order

See Also:

Constant Field Values

ASCENDING_ORDER

public static final java.lang.String ASCENDING_ORDER

Ascending order

See Also:

Constant Field Values

DESCENDING_ORDER

public static final java.lang.String DESCENDING_ORDER

Descending order

See Also:

Constant Field Values

Constructor Detail

Ordering

public Ordering(java.util.List<OrderingClauseType> clauses)

Constructs an Ordering object from a list of OrderingClauseType objects. If an OrderingClauseType object specifies a column, it must also specify a table name.

Parameters:

clauses - a List of OrderingClauseType objects.

Ordering

public Ordering(Column column,
                boolean isAscending,
                boolean isNullFirst)
         throws WorkflowException

Constructor to create the Ordering. This column gets added to the SQL statement that gets executed with the options specified.

Parameters:

column - Name Column to order by

isAscending - true if the order isAscending else false

isNullFirst - true if the order contains null value first else false

Throws:

java.lang.Exception

WorkflowException

Method Detail

addClause

public void addClause(Column column,
                      boolean isAscending,
                      boolean isNullFirst)
               throws WorkflowException

To add the more orderby columns. This order gets added to the SQL statement that gets executed.

Parameters:

column - Name Column to order by

isAscending - true if the order isAscending else false

isNullFirst - true if the order contains null value first else false

Throws:

java.lang.Exception

WorkflowException

getOrderBy

@Deprecated
public java.lang.String getOrderBy()

Deprecated. since 11.1.1.2.0

Deprecated. Conversion of Ordering to database port-specific SQL statement is handled internally by the persistency service.

Returns:

String a deprecated Order by sql string, for Oracle databases only.

toString

public java.lang.String toString()

Returns String representation of the Ordering object. This representation is for informational purposes only. It should NOT be used to form part of a SQL statement.

Overrides:

toString in class java.lang.Object

Returns:

String representation of the Ordering object.

getOrderColumns

public java.util.List<java.lang.String> getOrderColumns()

Returns the list of columns in the orderby part of the resulting SQL statement

Returns:

getOrderingClauseList

public java.util.List<OrderingClauseType> getOrderingClauseList()

getOrderingClauseList returns the ordering clause list

Skip navigation links