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.CoordinatorJobBean; 025import org.apache.oozie.ErrorCode; 026import org.apache.oozie.util.ParamChecker; 027import org.apache.oozie.util.XLog; 028 029/** 030 * DB query executor to fetch columns 'user' and 'appName' from Coordinator Job table 031 */ 032public class CoordinatorJobGetForUserAppnameJPAExecutor implements JPAExecutor<CoordinatorJobBean> { 033 034 private String coordJobId = null; 035 036 public CoordinatorJobGetForUserAppnameJPAExecutor(String coordJobId) { 037 ParamChecker.notNull(coordJobId, "coordJobId"); 038 this.coordJobId = coordJobId; 039 } 040 041 /* 042 * (non-Javadoc) 043 * 044 * @see org.apache.oozie.executor.jpa.JPAExecutor#getName() 045 */ 046 @Override 047 public String getName() { 048 return "CoordinatorJobGetForUserAppnameJPAExecutor"; 049 } 050 051 /* 052 * (non-Javadoc) 053 * 054 * @see org.apache.oozie.executor.jpa.JPAExecutor#execute(javax.persistence. 055 * EntityManager) 056 */ 057 @Override 058 public CoordinatorJobBean execute(EntityManager em) throws JPAExecutorException { 059 try { 060 Query q = em.createNamedQuery("GET_COORD_JOB_FOR_USER_APPNAME"); 061 q.setParameter("id", coordJobId); 062 Object[] arr = (Object[]) q.getSingleResult(); 063 CoordinatorJobBean bean = new CoordinatorJobBean(); 064 if (arr[0] != null) { 065 bean.setUser((String) arr[0]); 066 } 067 if (arr[1] != null){ 068 bean.setAppName((String) arr[1]); 069 } 070 return bean; 071 } 072 catch (Exception e) { 073 throw new JPAExecutorException(ErrorCode.E0603, e.getMessage(), e); 074 } 075 } 076 077}