001: /*--
002:
003: Copyright (C) 2002-2005 Adrian Price.
004: All rights reserved.
005:
006: Redistribution and use in source and binary forms, with or without
007: modification, are permitted provided that the following conditions
008: are met:
009:
010: 1. Redistributions of source code must retain the above copyright
011: notice, this list of conditions, and the following disclaimer.
012:
013: 2. Redistributions in binary form must reproduce the above copyright
014: notice, this list of conditions, and the disclaimer that follows
015: these conditions in the documentation and/or other materials
016: provided with the distribution.
017:
018: 3. The names "OBE" and "Open Business Engine" must not be used to
019: endorse or promote products derived from this software without prior
020: written permission. For written permission, please contact
021: adrianprice@sourceforge.net.
022:
023: 4. Products derived from this software may not be called "OBE" or
024: "Open Business Engine", nor may "OBE" or "Open Business Engine"
025: appear in their name, without prior written permission from
026: Adrian Price (adrianprice@users.sourceforge.net).
027:
028: THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
029: WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
030: OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
031: DISCLAIMED. IN NO EVENT SHALL THE AUTHOR(S) BE LIABLE FOR ANY DIRECT,
032: INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
033: (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
034: SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
035: HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,
036: STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING
037: IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
038: POSSIBILITY OF SUCH DAMAGE.
039:
040: For more information on OBE, please see
041: <http://obe.sourceforge.net/>.
042:
043: */
044:
045: package org.obe.server.j2ee.repository;
046:
047: import org.apache.commons.logging.Log;
048: import org.apache.commons.logging.LogFactory;
049: import org.obe.client.api.model.ProcessInstanceAttributes;
050: import org.obe.client.api.repository.RepositoryException;
051: import org.obe.server.j2ee.ejb.Sequence;
052: import org.obe.spi.model.AttributedEntity;
053: import org.obe.xpdl.model.workflow.WorkflowProcess;
054: import org.wfmc.wapi.WMFilter;
055:
056: import java.sql.SQLException;
057: import java.util.List;
058:
059: /**
060: * @author Adrian Price
061: */
062: /*package*/final class ProcessInstanceDAO extends AttributedEntityDAO {
063: private static final Log _logger = LogFactory
064: .getLog(ProcessInstanceDAO.class);
065: private static final String TABLE = "OBEPROCESSINSTANCE";
066: private static final String PRIMARY_KEY = "PROCESSINSTANCEID";
067: private static final int KEY_INCREMENT = 100;
068: private static final Sequence SEQUENCE = new Sequence(TABLE,
069: KEY_INCREMENT);
070: private static final ProcessInstanceDAO _theInstance = new ProcessInstanceDAO();
071:
072: /*package*/
073: static ProcessInstanceDAO getInstance() {
074: return _theInstance;
075: }
076:
077: // Prevent instantiation.
078: private ProcessInstanceDAO() {
079: }
080:
081: protected Log getLogger() {
082: return _logger;
083: }
084:
085: /*package*/String getNewId() throws RepositoryException {
086: return String.valueOf(getNewId(SEQUENCE));
087: }
088:
089: protected int count(String processDefinitionId, WMFilter filter)
090: throws SQLException, RepositoryException {
091:
092: // TODO: look up the WorkflowProcess.
093: WorkflowProcess workflow = null;
094:
095: return count(TABLE, AttributedEntity.PROCESS_INSTANCE_TYPE,
096: PRIMARY_KEY,
097: ProcessInstanceAttributes.SYSTEM_PROPERTIES, workflow,
098: createFilters(processDefinitionId, filter));
099: }
100:
101: /*package*/List findByFilter(String processDefinitionId,
102: WMFilter filter) throws SQLException, RepositoryException {
103:
104: // TODO: look up the WorkflowProcess.
105: WorkflowProcess workflow = null;
106:
107: return findByFilter(TABLE,
108: AttributedEntity.PROCESS_INSTANCE_TYPE, PRIMARY_KEY,
109: ProcessInstanceAttributes.SYSTEM_PROPERTIES, workflow,
110: createFilters(processDefinitionId, filter));
111: }
112:
113: private WMFilter[] createFilters(String processDefinitionId,
114: WMFilter filter) {
115:
116: WMFilter[] filters = null;
117: if (processDefinitionId != null || filter != null) {
118: filters = new WMFilter[] {
119: processDefinitionId == null ? null
120: : new WMFilter(
121: ProcessInstanceAttributes.PROCESS_DEFINITION_ID,
122: WMFilter.EQ, processDefinitionId),
123: filter };
124: }
125: return filters;
126: }
127: }
|