001/** 002 * Licensed to the Apache Software Foundation (ASF) under one 003 * or more contributor license agreements. See the NOTICE file 004 * distributed with this work for additional information 005 * regarding copyright ownership. The ASF licenses this file 006 * to you under the Apache License, Version 2.0 (the 007 * "License"); you may not use this file except in compliance 008 * with the License. You may obtain a copy of the License at 009 * 010 * http://www.apache.org/licenses/LICENSE-2.0 011 * 012 * Unless required by applicable law or agreed to in writing, software 013 * distributed under the License is distributed on an "AS IS" BASIS, 014 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 015 * See the License for the specific language governing permissions and 016 * limitations under the License. 017 */ 018 019package org.apache.oozie.executor.jpa; 020 021import javax.persistence.EntityManager; 022import javax.persistence.Query; 023 024import org.apache.oozie.ErrorCode; 025import org.apache.oozie.util.ParamChecker; 026 027/** 028 * Load the number of pending actions for a status for a coordinator job. 029 */ 030public class CoordActionsPendingFalseStatusCountGetJPAExecutor implements JPAExecutor<Integer> { 031 032 private String coordJobId = null; 033 private String status = null; 034 035 public CoordActionsPendingFalseStatusCountGetJPAExecutor(String coordJobId, String status) { 036 ParamChecker.notNull(coordJobId, "coordJobId"); 037 ParamChecker.notNull(status, "status"); 038 this.coordJobId = coordJobId; 039 this.status = status; 040 } 041 042 @Override 043 public String getName() { 044 return "CoordActionsPendingFalseStatusCountGetJPAExecutor"; 045 } 046 047 @Override 048 public Integer execute(EntityManager em) throws JPAExecutorException { 049 try { 050 Query q = em.createNamedQuery("GET_COORD_ACTIONS_PENDING_FALSE_STATUS_COUNT"); 051 q.setParameter("jobId", coordJobId); 052 q.setParameter("status", status); 053 Long count = (Long) q.getSingleResult(); 054 return Integer.valueOf(count.intValue()); 055 } 056 catch (Exception e) { 057 throw new JPAExecutorException(ErrorCode.E0603, e.getMessage(), e); 058 } 059 } 060 061}