com.oracle.bpel.client.util
Class WhereConditionHelper

java.lang.Object
com.oracle.bpel.client.util.WhereConditionHelper

public class WhereConditionHelper

extends java.lang.Object

Simple utility class to help users construct where condition clauses. Many queries require in-depth knowledge of the Orabpel process domain database schema; the goal of this class is to fabricate several canned query "stubs" that may be joined together to help the user form their desired where condition.

For example, to select for all the tasks that are open:

 WhereCondition cond = WhereConditionHelper.whereOpenActivities();
 cond.append( "and" ).append( WhereConditionHelper.whereTaskActivities() );
 

Since:

1.0

See Also:

WhereCondition

Constructor Summary

WhereConditionHelper()

Method Summary

static WhereCondition	whereActivitiesCancelled() Constructs a where condition that searches for cancelled activities.
static WhereCondition	whereActivitiesClosed() Constructs a where condition that searches for closed activities.
static WhereCondition	whereActivitiesCompleted() Constructs a where condition that searches for completed activities.
static WhereCondition	whereActivitiesDueBy(java.util.Date dueDate) Constructs a where condition that searches for activities that will expire by the specified date.
static WhereCondition	whereActivitiesLabel(java.lang.String label) Constructs a where condition that searches for activities with the specified label.
static WhereCondition	whereActivitiesOpen() Constructs a where condition that searches for open activities.
static WhereCondition	whereActivitiesPastDue() Constructs a where condition that searches for activities that have already been expired.
static WhereCondition	whereActivitiesRecoverable()
static WhereCondition	whereActivitiesStale() Constructs a where condition that searches for activities that have been marked as stale.
static WhereCondition	whereCallbackMessagesRecoverable()
static WhereCondition	whereInstancesCancelled() Constructs a where condition that searches for cancelled instances.
static WhereCondition	whereInstancesClosed() Constructs a where condition that searches for closed instances.
static WhereCondition	whereInstancesCompleted() Constructs a where condition that searches for completed instances.
static WhereCondition	whereInstancesOpen() Constructs a where condition that searches for open instances.
static WhereCondition	whereInstancesStale() Constructs a where condition that searches for stale instances.
static WhereCondition	whereInvokeMessagesRecoverable()
static WhereCondition	whereTaskAssignee(java.lang.String assignee) Constructs a where condition that searches for tasks that have been assigned to the specified assignee.
static WhereCondition	whereTaskCreator(java.lang.String creator) Constructs a where condition that searches for tasks that have been created by the specified creator.
static WhereCondition	whereTasksActive()
static WhereCondition	whereTasksCancelled()
static WhereCondition	whereTasksCompleted()
static WhereCondition	whereTasksExpired()

Methods inherited from class java.lang.Object

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

Constructor Detail

WhereConditionHelper

public WhereConditionHelper()

Method Detail

whereInstancesOpen

public static WhereCondition whereInstancesOpen()

Constructs a where condition that searches for open instances. An instance is open if it contains at least one active activity.

whereInstancesClosed

public static WhereCondition whereInstancesClosed()

Constructs a where condition that searches for closed instances. An instance is closed if it does not contain any active activities.

whereInstancesCompleted

public static WhereCondition whereInstancesCompleted()

Constructs a where condition that searches for completed instances. An instance is completed if all its activities are closed.

whereInstancesCancelled

public static WhereCondition whereInstancesCancelled()

Constructs a where condition that searches for cancelled instances. An instance can only be cancelled with an administrative command.

whereInstancesStale

public static WhereCondition whereInstancesStale()

Constructs a where condition that searches for stale instances.

When a BPEL process is deployed on top of an existing (that is, deployed) BPEL process with the same process identifier and revision tag, all instances created from the old BPEL process are marked as stale and cannot be acted upon any longer.

Instances belonging to undeployed processes are also marked as stale.

whereActivitiesOpen

public static WhereCondition whereActivitiesOpen()

Constructs a where condition that searches for open activities. An activity is open if it is waiting to be completed by a performer; this also includes suspended activities.

whereActivitiesClosed

public static WhereCondition whereActivitiesClosed()

Constructs a where condition that searches for closed activities. An activity is closed if it has been completed, cancelled or aborted.

whereActivitiesCompleted

public static WhereCondition whereActivitiesCompleted()

Constructs a where condition that searches for completed activities. An activity that finishes normally is considered to be complete. An activity that finishes abnormally (through a fault or an administrative action) is not considered to be complete.

whereActivitiesCancelled

public static WhereCondition whereActivitiesCancelled()

Constructs a where condition that searches for cancelled activities. An activity can be cancelled if another activity faults and causes an enclosing block to kill the activity.

whereActivitiesStale

public static WhereCondition whereActivitiesStale()

Constructs a where condition that searches for activities that have been marked as stale. When an instance is marked as stale, all open activities belonging to that instance are marked as stale.

whereActivitiesDueBy

public static WhereCondition whereActivitiesDueBy(java.util.Date dueDate)

Constructs a where condition that searches for activities that will expire by the specified date. Only open activities are searched.

whereActivitiesPastDue

public static WhereCondition whereActivitiesPastDue()

Constructs a where condition that searches for activities that have already been expired. An activity can have an expiration date that is past the current system time and has not been expired. The process domain will periodically scan the database for activities that should be expired; if the activity has not been picked up yet the activity expiration date could be past due. Only open activities are searched.

whereActivitiesLabel

public static WhereCondition whereActivitiesLabel(java.lang.String label)

Constructs a where condition that searches for activities with the specified label.

whereActivitiesRecoverable

public static WhereCondition whereActivitiesRecoverable()

whereInvokeMessagesRecoverable

public static WhereCondition whereInvokeMessagesRecoverable()

whereCallbackMessagesRecoverable

public static WhereCondition whereCallbackMessagesRecoverable()

whereTasksActive

public static WhereCondition whereTasksActive()

whereTasksCompleted

public static WhereCondition whereTasksCompleted()

whereTasksCancelled

public static WhereCondition whereTasksCancelled()

whereTasksExpired

public static WhereCondition whereTasksExpired()

whereTaskAssignee

public static WhereCondition whereTaskAssignee(java.lang.String assignee)

Constructs a where condition that searches for tasks that have been assigned to the specified assignee.

whereTaskCreator

public static WhereCondition whereTaskCreator(java.lang.String creator)

Constructs a where condition that searches for tasks that have been created by the specified creator.