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 package org.apache.oozie.executor.jpa; 019 020 import java.sql.Timestamp; 021 import java.util.ArrayList; 022 import java.util.List; 023 024 import javax.persistence.EntityManager; 025 import javax.persistence.Query; 026 027 import org.apache.oozie.ErrorCode; 028 import org.apache.oozie.util.ParamChecker; 029 030 public class CoordActionsGetReadyGroupbyJobIDJPAExecutor implements JPAExecutor<List<String>>{ 031 private long checkAgeSecs = 0; 032 033 public CoordActionsGetReadyGroupbyJobIDJPAExecutor(final long checkAgeSecs) { 034 ParamChecker.notNull(checkAgeSecs, "checkAgeSecs"); 035 this.checkAgeSecs = checkAgeSecs; 036 } 037 038 /* (non-Javadoc) 039 * @see org.apache.oozie.executor.jpa.JPAExecutor#getName() 040 */ 041 @Override 042 public String getName() { 043 return "CoordActionsGetReadyGroupbyJobIDJPAExecutor"; 044 } 045 046 /* (non-Javadoc) 047 * @see org.apache.oozie.executor.jpa.JPAExecutor#execute(javax.persistence.EntityManager) 048 */ 049 @Override 050 public List<String> execute(EntityManager em) throws JPAExecutorException { 051 List<String> jobids = new ArrayList<String>(); 052 try { 053 Query q = em.createNamedQuery("GET_READY_ACTIONS_GROUP_BY_JOBID"); 054 Timestamp ts = new Timestamp(System.currentTimeMillis() - checkAgeSecs * 1000); 055 q.setParameter(1, ts); 056 List<Object[]> list = q.getResultList(); 057 058 for (Object[] arr : list) { 059 if (arr != null && arr[0] != null) { 060 jobids.add((String) arr[0]); 061 } 062 } 063 064 return jobids; 065 } 066 catch (IllegalStateException e) { 067 throw new JPAExecutorException(ErrorCode.E0601, e.getMessage(), e); 068 } 069 } 070 071 }