/** * Execute a query that returns a single result. */ public X getSingleResult() { _em.assertNotCloseInvoked(); setHint(QueryHints.HINT_RESULT_COUNT, 1); // for DB2 optimization boolean queryFetchPlanUsed = pushQueryFetchPlan(); try { List result = getResultList(); if (result == null || result.isEmpty()) throw new NoResultException(_loc.get("no-result", getQueryString()) .getMessage()); if (result.size() > 1) throw new NonUniqueResultException(_loc.get("non-unique-result", getQueryString(), result.size()).getMessage()); try { return (X)result.get(0); } catch (Exception e) { throw new NoResultException(_loc.get("no-result", getQueryString()) .getMessage()); } } finally { popQueryFetchPlan(queryFetchPlanUsed); } }
/** * Execute a query that returns a single result. */ public X getSingleResult() { _em.assertNotCloseInvoked(); setHint(QueryHints.HINT_RESULT_COUNT, 1); // for DB2 optimization boolean queryFetchPlanUsed = pushQueryFetchPlan(); try { List result = getResultList(); if (result == null || result.isEmpty()) throw new NoResultException(_loc.get("no-result", getQueryString()) .getMessage()); if (result.size() > 1) throw new NonUniqueResultException(_loc.get("non-unique-result", getQueryString(), result.size()).getMessage()); try { return (X)result.get(0); } catch (Exception e) { throw new NoResultException(_loc.get("no-result", getQueryString()) .getMessage()); } } finally { popQueryFetchPlan(queryFetchPlanUsed); } }
/** * Execute a query that returns a single result. */ public X getSingleResult() { _em.assertNotCloseInvoked(); setHint(QueryHints.HINT_RESULT_COUNT, 1); // for DB2 optimization boolean queryFetchPlanUsed = pushQueryFetchPlan(); try { List result = getResultList(); if (result == null || result.isEmpty()) throw new NoResultException(_loc.get("no-result", getQueryString()) .getMessage()); if (result.size() > 1) throw new NonUniqueResultException(_loc.get("non-unique-result", getQueryString(), result.size()).getMessage()); try { return (X)result.get(0); } catch (Exception e) { throw new NoResultException(_loc.get("no-result", getQueryString()) .getMessage()); } } finally { popQueryFetchPlan(queryFetchPlanUsed); } }
/** * Execute a query that returns a single result. */ public X getSingleResult() { _em.assertNotCloseInvoked(); setHint(QueryHints.HINT_RESULT_COUNT, 1); // for DB2 optimization boolean queryFetchPlanUsed = pushQueryFetchPlan(); try { List result = getResultList(); if (result == null || result.isEmpty()) throw new NoResultException(_loc.get("no-result", getQueryString()) .getMessage()); if (result.size() > 1) throw new NonUniqueResultException(_loc.get("non-unique-result", getQueryString(), result.size()).getMessage()); try { return (X)result.get(0); } catch (Exception e) { throw new NoResultException(_loc.get("no-result", getQueryString()) .getMessage()); } } finally { popQueryFetchPlan(queryFetchPlanUsed); } }