/** * Restricts the max results of the given {@link Query} if the current {@code tree} marks this {@code query} as * limited. */ private Query restrictMaxResultsIfNecessary(Query query) { if (tree.isLimiting()) { if (query.getMaxResults() != Integer.MAX_VALUE) { /* * In order to return the correct results, we have to adjust the first result offset to be returned if: * - a Pageable parameter is present * - AND the requested page number > 0 * - AND the requested page size was bigger than the derived result limitation via the First/Top keyword. */ if (query.getMaxResults() > tree.getMaxResults() && query.getFirstResult() > 0) { query.setFirstResult(query.getFirstResult() - (query.getMaxResults() - tree.getMaxResults())); } } query.setMaxResults(tree.getMaxResults()); } if (tree.isExistsProjection()) { query.setMaxResults(1); } return query; }
@Override public int getFirstResult() { return query.getFirstResult(); }
/** {@inheritDoc} */ @Override public int getFirstResult() { return query.getFirstResult(); }
finally { entityTransaction = entityManager.getTransaction(); entityTransaction.begin(); Query query = entityManager.createNamedQuery("findEmployeeByName"); supplierID = query.getFirstResult(); entityTransaction.commit(); entityManager.close(); }
@Override public int getFirstResult() { return delegate.getFirstResult(); }
@Override public int getFirstResult() { return query.getFirstResult(); }
@Override public int getFirstResult() { return query.getFirstResult(); }
@Override public int getFirstResult() { return underlyingQuery.getFirstResult(); }
@Override public int getFirstResult() { return underlyingQuery.getFirstResult(); }
@Override public int getFirstResult() { return query.getFirstResult(); }
public int getFirstResult() { return query.getFirstResult(); }
public int getFirstResult() { return query.getFirstResult(); }
public int getFirstResult() { return query.getFirstResult(); }
em.getTransaction().begin(); String get_employee_id = "SELECT emp.id FROM Employee as emp WHERE emp.bsn=:bsn"; Query employee_query = em.createQuery(get_employee_id); employee_query.setParameter("bsn", object.getEmployee().getBsn()); long id = employee_query.getFirstResult(); System.out.println("query returns employee id: " + id); em.getTransaction().commit();
public int getFirstResult() { try { if(callFlowAgent.isEnabled()) { callFlowAgent.entityManagerQueryStart(EntityManagerQueryMethod.GET_FIRST_RESULT); } return queryDelegate.getFirstResult(); } finally { if(callFlowAgent.isEnabled()) { callFlowAgent.entityManagerQueryEnd(); } } }
public static QueryKey create(String queryString, boolean softDeletion, boolean singleResult, javax.persistence.Query jpaQuery) { return new QueryKey(queryString, jpaQuery.getFirstResult(), jpaQuery.getMaxResults(), softDeletion, singleResult, getNamedParameters(jpaQuery), getPositionalParameters(jpaQuery)); }
public static QueryKey create(String queryString, boolean softDeletion, javax.persistence.Query jpaQuery) { return new QueryKey(queryString, jpaQuery.getFirstResult(), jpaQuery.getMaxResults(), softDeletion, false, getNamedParameters(jpaQuery), getPositionalParameters(jpaQuery)); }
/** * Restricts the max results of the given {@link Query} if the current {@code tree} marks this {@code query} as * limited. */ private Query restrictMaxResultsIfNecessary(Query query) { if (tree.isLimiting()) { if (query.getMaxResults() != Integer.MAX_VALUE) { /* * In order to return the correct results, we have to adjust the first result offset to be returned if: * - a Pageable parameter is present * - AND the requested page number > 0 * - AND the requested page size was bigger than the derived result limitation via the First/Top keyword. */ if (query.getMaxResults() > tree.getMaxResults() && query.getFirstResult() > 0) { query.setFirstResult(query.getFirstResult() - (query.getMaxResults() - tree.getMaxResults())); } } query.setMaxResults(tree.getMaxResults()); } if (tree.isExistsProjection()) { query.setMaxResults(1); } return query; }
public int getFirstResult() { try { if(callFlowAgent.isEnabled()) { callFlowAgent.entityManagerQueryStart(EntityManagerQueryMethod.GET_FIRST_RESULT); } Query delegate = getQueryDelegate(); return delegate.getFirstResult(); } finally { if(callFlowAgent.isEnabled()) { callFlowAgent.entityManagerQueryEnd(); } } }
public void addNamedQuery(String name, Query query) { DatabaseQuery unwrapped = (DatabaseQuery) query.unwrap(DatabaseQuery.class).clone(); if (((QueryImpl)query).lockMode != null){ ((ObjectLevelReadQuery)unwrapped).setLockModeType(((QueryImpl)query).lockMode.name(), session); } if (unwrapped.isReadQuery()){ ((ReadQuery)unwrapped).setInternalMax((((QueryImpl)query).getMaxResultsInternal())); if (query.getFirstResult() != QueryImpl.UNDEFINED){ ((ReadQuery)unwrapped).setFirstResult(query.getFirstResult()); } } this.getServerSession().addQuery(name, unwrapped, true); }