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.ActivityInstanceAttributes;
050: import org.obe.client.api.repository.RepositoryException;
051: import org.obe.server.j2ee.ejb.Sequence;
052: import org.obe.spi.model.ActivityInstance;
053: import org.obe.spi.model.AttributedEntity;
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 ActivityInstanceDAO extends AttributedEntityDAO {
063: private static final Log _logger = LogFactory
064: .getLog(ActivityInstanceDAO.class);
065: private static final String TABLE = "OBEACTIVITYINSTANCE";
066: private static final String PRIMARY_KEY = "ACTIVITYINSTANCEID";
067: private static final int KEY_INCREMENT = 100;
068: private static final Sequence SEQUENCE = new Sequence(TABLE,
069: KEY_INCREMENT);
070: private static final ActivityInstanceDAO _theInstance = new ActivityInstanceDAO();
071:
072: public static ActivityInstanceDAO getInstance() {
073: return _theInstance;
074: }
075:
076: // Prevent instantiation.
077: private ActivityInstanceDAO() {
078: }
079:
080: protected Log getLogger() {
081: return _logger;
082: }
083:
084: /*package*/String getNewId() throws RepositoryException {
085: return String.valueOf(getNewId(SEQUENCE));
086: }
087:
088: /*package*/int count(WMFilter filter) throws SQLException,
089: RepositoryException {
090:
091: return count(TABLE, AttributedEntity.ACTIVITY_INSTANCE_TYPE,
092: PRIMARY_KEY, ActivityInstance.propertyDescriptors,
093: null, filter);
094: }
095:
096: /*package*/List findByFilter(String processDefinitionId,
097: String activityDefinitionId, WMFilter filter)
098: throws SQLException, RepositoryException {
099:
100: int count = 0;
101: if (processDefinitionId != null)
102: count++;
103: if (activityDefinitionId != null)
104: count++;
105: if (filter != null)
106: count++;
107: WMFilter[] filters = new WMFilter[count];
108:
109: int n = 0;
110: if (processDefinitionId != null) {
111: filters[n++] = new WMFilter(
112: ActivityInstanceAttributes.PROCESS_DEFINITION_ID,
113: WMFilter.EQ, processDefinitionId);
114: }
115: if (activityDefinitionId != null) {
116: filters[n++] = new WMFilter(
117: ActivityInstanceAttributes.ACTIVITY_DEFINITION_ID,
118: WMFilter.EQ, activityDefinitionId);
119: }
120: if (filter != null)
121: filters[n++] = filter;
122: return findByFilter(TABLE,
123: AttributedEntity.ACTIVITY_INSTANCE_TYPE, PRIMARY_KEY,
124: ActivityInstance.propertyDescriptors, null, filters);
125: }
126: }
|