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 022 import javax.persistence.EntityManager; 023 import javax.persistence.Query; 024 025 import org.apache.oozie.ErrorCode; 026 import org.apache.oozie.WorkflowJobBean; 027 import org.apache.oozie.client.WorkflowJob; 028 import org.apache.oozie.util.DateUtils; 029 import org.apache.oozie.util.ParamChecker; 030 031 /** 032 * Retrieve the workflow job bean for sla service 033 */ 034 public class WorkflowJobGetForSLAJPAExecutor implements JPAExecutor<WorkflowJobBean> { 035 036 private String wfJobId; 037 038 public WorkflowJobGetForSLAJPAExecutor(String wfJobId) { 039 ParamChecker.notNull(wfJobId, "wfJobId"); 040 this.wfJobId = wfJobId; 041 } 042 043 @Override 044 public String getName() { 045 return "WorkflowJobGetForSLAJPAExecutor"; 046 } 047 048 @Override 049 public WorkflowJobBean execute(EntityManager em) throws JPAExecutorException { 050 try { 051 Query q = em.createNamedQuery("GET_WORKFLOW_FOR_SLA"); 052 q.setParameter("id", wfJobId); 053 Object[] obj = (Object[]) q.getSingleResult(); 054 return getBeanFromArray(obj); 055 } 056 catch (Exception e) { 057 throw new JPAExecutorException(ErrorCode.E0603, e.getMessage(), e); 058 } 059 } 060 061 private WorkflowJobBean getBeanFromArray(Object[] arr) { 062 WorkflowJobBean wjb = new WorkflowJobBean(); 063 if (arr[0] != null) { 064 wjb.setId((String) arr[0]); 065 } 066 if (arr[1] != null) { 067 wjb.setStatus(WorkflowJob.Status.valueOf((String) arr[1])); 068 } 069 if (arr[2] != null) { 070 wjb.setStartTime(DateUtils.toDate((Timestamp) arr[2])); 071 } 072 if (arr[3] != null) { 073 wjb.setEndTime(DateUtils.toDate((Timestamp) arr[3])); 074 } 075 return wjb; 076 } 077 }