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