| java.lang.Object
 com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore
All known Subclasses: com.opensymphony.workflow.spi.jdbc.MySQLWorkflowStore,
| JDBCWorkflowStore | | public class JDBCWorkflowStore implements WorkflowStore(Code) | | JDBC implementation.
The following properties are all required:
- datasource - the JNDI location for the DataSource that is to be used.
- entry.sequence - SQL query that returns the next ID for a workflow entry
- entry.table - table name for workflow entry
- entry.id - column name for workflow entry ID field
- entry.name - column name for workflow entry name field
- entry.state - column name for workflow entry state field
- step.sequence - SQL query that returns the next ID for a workflow step
- history.table - table name for steps in history
- current.table - table name for current steps
- step.id - column name for step ID field
- step.entryId - column name for workflow entry ID field (foreign key relationship to [entry.table].[entry.id])
- step.stepId - column name for step workflow definition step field
- step.actionId - column name for step action field
- step.owner - column name for step owner field
- step.caller - column name for step caller field
- step.startDate - column name for step start date field
- step.dueDate - column name for optional step due date field
- step.finishDate - column name for step finish date field
- step.status - column name for step status field
- currentPrev.table - table name for the previous IDs for current steps
- historyPrev.table - table name for the previous IDs for history steps
- step.previousId - column name for step ID field (foreign key relation to [history.table].[step.id] or [current.table].[step.id])
author:
Pat Lightbody |
| Method Summary | |
| protected void | addPreviousSteps(Connection conn, long id, long[] previousIds)
| | public boolean | checkIfORExists(NestedExpression nestedExpression)
| | protected void | cleanup(Connection connection, Statement statement, ResultSet result)
| | public Step | createCurrentStep(long entryId, int wfStepId, String owner, Date startDate, Date dueDate, String status, long[] previousIds)
| | protected long | createCurrentStep(Connection conn, long entryId, int wfStepId, String owner, Date startDate, Date dueDate, String status)
| | public WorkflowEntry | createEntry(String workflowName)
| | void | doNestedNaturalJoin(WorkflowExpressionQuery e, NestedExpression nestedExpression, StringBuffer columns, StringBuffer where, StringBuffer whereComp, List values, List queries, StringBuffer orderBy)
| | public List | findCurrentSteps(long entryId)
| | public WorkflowEntry | findEntry(long theEntryId)
| | public List | findHistorySteps(long entryId)
| | protected Connection | getConnection()
| | protected long | getNextEntrySequence(Connection c)
| | protected long | getNextStepSequence(Connection c)
| | public PropertySet | getPropertySet(long entryId)
| | public void | init(Map props)
| | public Step | markFinished(Step step, int actionId, Date finishDate, String status, String caller)
| | public void | moveToHistory(Step step)
| | public List | query(WorkflowExpressionQuery e)
| | public List | query(WorkflowQuery query)
| | public void | setEntryState(long id, int state)
|
| closeConnWhenDone | | protected boolean closeConnWhenDone(Code) | | |
| getPropertySet | | public PropertySet getPropertySet(long entryId)(Code) | | |
|
|