public User getUserByUsernameOrNull(String username) { try{ Query q = em.createNamedQuery(User.getUserByUsername); q.setParameter("username", username); return (User) q.getSingleResult(); } catch(NoResultException e) { return null; } }
@Override public CustomerPayment readCustomerPaymentByToken(String token) { Query query = em.createNamedQuery("BC_READ_CUSTOMER_PAYMENT_BY_TOKEN"); query.setParameter("token", token); CustomerPayment payment = null; try{ payment = (CustomerPayment) query.getSingleResult(); } catch (NoResultException e) { //do nothing } return payment; }
/** * Return the user having the passed email. */ public User getByEmail(String email) { return (User) entityManager.createQuery( "from User where email = :email") .setParameter("email", email) .getSingleResult(); }
public static long countLoanSharks() { return ((Number) entityManager().createQuery("select count(o) from LoanShark o").getSingleResult()).longValue(); }
Object p3 = prepareMongoInstance("3", 15); Query findQuery = em.createQuery("Select p from PersonMongo p"); List<PersonMongo> allPersons = findQuery.getResultList(); Assert.assertNotNull(allPersons); Assert.assertTrue(allPersons.isEmpty()); findQuery = em.createQuery("Select p from PersonMongo p where p.personName = vivek"); allPersons = findQuery.getResultList(); Assert.assertNotNull(allPersons); assertFindWithoutWhereClause(em, "PersonMongo", PersonMongo.class); findQuery = em.createQuery("Select p from PersonMongo p where p.day = :day"); findQuery.setParameter("day", Day.FRIDAY); allPersons = findQuery.getResultList(); Assert.assertNotNull(allPersons); PersonMongo result = (PersonMongo) (query.getSingleResult()); Assert.assertNotNull(result); Assert.assertEquals(Month.JAN, result.getMonth()); try result = (PersonMongo) (query.getSingleResult()); Assert.fail("Should have gone to catch block!");
@Override public ExecutionError get(String errorId) { if (!isActive()) { return null; } return (ExecutionError) call((EntityManager em) -> { return em.createQuery("from ExecutionErrorInfo where errorId =:errorId") .setParameter("errorId", errorId) .getSingleResult(); }); }
@Override public StaticAssetStorage readStaticAssetStorageByStaticAssetId(Long id) { Query query = em.createNamedQuery("BC_READ_STATIC_ASSET_STORAGE_BY_STATIC_ASSET_ID"); query.setParameter("id", id); return (StaticAssetStorage) query.getSingleResult(); }
private static boolean hasData(EntityManager entityManager) { return (((Long) entityManager.createQuery( "select count(a) from Address a" ).getSingleResult()) + ((Long) entityManager.createQuery( "select count(p) from Person p" ).getSingleResult())) > 0; } }
String sql = "SELECT USER.* FROM USER_ AS USER WHERE ID = ?"; Query query = em.createNativeQuery(sql, User.class); query.setParameter(1, id); User user = (User) query.getSingleResult();
Query q = this.em.createQuery(hql); q.setParameter("pid", productId); Product p = (Product)q.getSingleResult();
public Role readRoleByName(String name) { Query query = em.createNamedQuery("BC_READ_ROLE_BY_NAME"); query.setParameter("name", name); return (Role) query.getSingleResult(); }
private boolean hasData() { return (((Long) entityManager.createQuery("select count(a) from Address a").getSingleResult()) + ((Long) entityManager.createQuery("select count(p) from Person p").getSingleResult())) > 0; }
continue; query.setParameter(name, params.get(name)); return (T) query.getSingleResult();
Query q = this.em.createQuery(hql); q.setParameter("cm", store.getId()); q.setParameter("se", seUrl); Content content = (Content)q.getSingleResult();
@Override public SearchIntercept findInterceptByTerm(String term) { Query query = em.createNamedQuery("BC_READ_SEARCH_INTERCEPT_BY_TERM"); query.setParameter("searchTerm", term); SearchIntercept result; try { result = (SearchIntercept) query.getSingleResult(); } catch (NoResultException e) { result = null; } return result; }
@SuppressWarnings("unchecked") public <T> T getSingleResult() { Query q = JPA.em().createQuery(jpql); JPA.bind(q, namedArgs, args); return (T) q.getSingleResult(); }
@Test public void testStoredProcedureReturnValue() { try { doInJPA( this::entityManagerFactory, entityManager -> { BigDecimal phoneCount = (BigDecimal) entityManager .createNativeQuery("SELECT fn_count_phones(:personId) FROM DUAL") .setParameter("personId", 1) .getSingleResult(); assertEquals(BigDecimal.valueOf(2), phoneCount); }); } catch (Exception e) { e.printStackTrace(); } } }
Query q = this.em.createQuery(hql); q.setParameter("lid", regionList); q.setParameter("dt", new Date()); q.setParameter("seUrl", seUrl); p = (Product)q.getSingleResult(); } catch(javax.persistence.NoResultException ignore) {
protected AuditTaskImpl getAuditTask(EntityManager em, long taskId) { try { AuditTaskImpl auditTaskImpl = (AuditTaskImpl) em.createNamedQuery("getAuditTaskById").setParameter("taskId", taskId).getSingleResult(); return auditTaskImpl; } catch (NoResultException | NonUniqueResultException e) { return null; } } }
@Override public Long findTaskIdByContentId( Long contentId ) { check(); CriteriaBuilder builder = this.em.getCriteriaBuilder(); CriteriaQuery<Long> query = builder.createQuery(Long.class); Root<TaskImpl> taskRoot = query.from(TaskImpl.class); Root<ContentImpl> contentRoot = query.from(ContentImpl.class); query.select(taskRoot.get(TaskImpl_.id)); Predicate taskContentJoinPred = builder.equal( contentRoot.get(ContentImpl_.id), taskRoot.get(TaskImpl_.taskData).get(TaskDataImpl_.outputContentId)); Predicate contentIdPred = builder.equal( contentRoot.get(ContentImpl_.id), contentId); query.where(builder.and(taskContentJoinPred, contentIdPred)); Query choppedLiver = em.createQuery(query); return (Long) choppedLiver.getSingleResult(); }