@Override public Sku readFirstSku() { TypedQuery<Sku> query = em.createNamedQuery("BC_READ_FIRST_SKU", Sku.class); return query.getSingleResult(); }
@Stateless public class CommentService { @PersistenceContext(unitName = "pu") private EntityManager em; public void create(Comment t) { em.merge(t); } public Collection<Comment> getAll() { Query q = em.createNamedQuery("Comment.findAll"); Collection<Comment> entities = q.getResultList(); return entities; } }
@Override public List<AdminUser> readAdminUserByEmail(String emailAddress) { TypedQuery<AdminUser> query = em.createNamedQuery("BC_READ_ADMIN_USER_BY_EMAIL", AdminUser.class); query.setParameter("email", emailAddress); return query.getResultList(); } }
@SuppressWarnings("unchecked") public List<CustomerPhone> readAllCustomerPhonesByCustomerId(Long customerId) { Query query = em.createNamedQuery("BC_READ_ALL_CUSTOMER_PHONES_BY_CUSTOMER_ID"); query.setParameter("customerId", customerId); return query.getResultList(); }
@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; }
@Override public int executeUpdate(String queryName, Map<String, Object> params) { check(); Query query = this.em.createNamedQuery(queryName); if (params != null) { for (Map.Entry<String, Object> paramEntry : params.entrySet()) { query.setParameter(paramEntry.getKey(), paramEntry.getValue()); } } return query.executeUpdate(); }
@Test public void test_jpql_api_hibernate_named_query_example() { doInJPA( this::entityManagerFactory, entityManager -> { //tag::jpql-api-hibernate-named-query-example[] Phone phone = entityManager .createNamedQuery( "get_phone_by_number", Phone.class ) .setParameter( "number", "123-456-7890" ) .getSingleResult(); //end::jpql-api-hibernate-named-query-example[] assertNotNull( phone ); }); }
List<BlogPost> allPosts = q.getResultList(); Assert.assertNotNull(allPosts); Assert.assertFalse(allPosts.isEmpty()); q.setParameter("postId", 1); allPosts = q.getResultList(); Assert.assertNotNull(allPosts); Assert.assertFalse(allPosts.isEmpty()); q.setParameter("body", "Kundera - Knight in the shining armor!"); allPosts = q.getResultList(); Assert.assertNotNull(allPosts); Assert.assertFalse(allPosts.isEmpty()); q.setParameter("body", p1.getBody()); q.setParameter("tags", p1.getTags()); q.setParameter("likedBy", p1.getLikedBy()); q.setParameter("comments", p1.getComments()); int updatedRecords = q.executeUpdate(); q = em.createNamedQuery("select.post.2"); allPosts = q.getResultList(); Assert.assertNotNull(allPosts); int deleteCount = q.executeUpdate(); Assert.assertEquals(2, deleteCount);
String orderLockKey = getOrderLockKey(); Query q = em.createNamedQuery("BC_ORDER_LOCK_READ"); q.setParameter("orderId", order.getId()); q.setParameter("key", orderLockKey); q.setHint(QueryHints.HINT_CACHEABLE, false); Long count = (Long) q.getSingleResult(); q = em.createNamedQuery("BC_ORDER_LOCK_ACQUIRE"); q.setParameter("orderId", order.getId()); q.setParameter("currentTime", System.currentTimeMillis()); q.setParameter("key", orderLockKey); q.setParameter("timeout", orderLockTimeToLive==-1L?orderLockTimeToLive:System.currentTimeMillis() - orderLockTimeToLive); q.setHint(QueryHints.HINT_CACHEABLE, false); int rowsAffected = q.executeUpdate();
@GET @Produces("application/xml") public Employee[] get() { return em.createNamedQuery("Employee.findAll", Employee.class).getResultList().toArray(new Employee[0]); } }
@Override public ChallengeQuestion readChallengeQuestionById(long challengeQuestionId) { Query query = em.createNamedQuery("BC_READ_CHALLENGE_QUESTION_BY_ID"); query.setParameter("question_id", challengeQuestionId); List<ChallengeQuestion> challengeQuestions = query.getResultList(); return challengeQuestions == null || challengeQuestions.isEmpty() ? null : challengeQuestions.get(0); }
@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(); }
@Override public List<OrderMultishipOption> readOrderItemOrderMultishipOptions(final Long orderItemId) { TypedQuery<OrderMultishipOption> query = em.createNamedQuery("BC_READ_MULTISHIP_OPTIONS_BY_ORDER_ITEM_ID", OrderMultishipOption.class); query.setParameter("orderItemId", orderItemId); return query.getResultList(); }
@Override public void deleteSaga(Class<?> sagaType, String sagaIdentifier, Set<AssociationValue> associationValues) { EntityManager entityManager = entityManagerProvider.getEntityManager(); try { entityManager.createNamedQuery(DELETE_ASSOCIATIONS_NAMED_QUERY) .setParameter("sagaId", sagaIdentifier) .executeUpdate(); entityManager.createNamedQuery(DELETE_SAGA_NAMED_QUERY) .setParameter("id", sagaIdentifier) .executeUpdate(); } catch (EntityNotFoundException e) { logger.info("Could not delete {} {}, it appears to have already been deleted.", sagaEntryEntityName(), sagaIdentifier); } if (useExplicitFlush) { entityManager.flush(); } }
public ApiToken findApiToken(String token) { try { return em.createNamedQuery("ApiToken.findByTokenString", ApiToken.class) .setParameter("tokenString", token) .getSingleResult(); } catch (NoResultException ex) { return null; } }
List<BlogPost> allPosts = q.getResultList(); Assert.assertNotNull(allPosts); Assert.assertFalse(allPosts.isEmpty()); q.setParameter("postId", 1); allPosts = q.getResultList(); Assert.assertNotNull(allPosts); Assert.assertFalse(allPosts.isEmpty()); q.setParameter("body", "Kundera - Knight in the shining armor!"); allPosts = q.getResultList(); Assert.assertNotNull(allPosts); Assert.assertFalse(allPosts.isEmpty()); q.setParameter("body", p1.getBody()); q.setParameter("tags", p1.getTags()); q.setParameter("likedBy", p1.getLikedBy()); q.setParameter("comments", p1.getComments()); int updatedRecords = q.executeUpdate(); q = em.createNamedQuery("select.post.2"); allPosts = q.getResultList(); Assert.assertNotNull(allPosts); int deleteCount = q.executeUpdate(); Assert.assertEquals(2, deleteCount);
@Test public void test_sql_jpa_multiple_scalar_values_dto_named_query_example() { doInJPA( this::entityManagerFactory, entityManager -> { //tag::sql-jpa-multiple-scalar-values-dto-named-query-example[] List<PersonNames> personNames = entityManager.createNamedQuery( "find_person_name_and_nickName_dto" ) .getResultList(); //end::sql-jpa-multiple-scalar-values-dto-named-query-example[] assertEquals(3, personNames.size()); }); }
TypedQuery<SampleEntity> query = em.createNamedQuery(namedQuery, SampleEntity.class); query.getSingleResult();
@SuppressWarnings("unchecked") public List<State> findStates(String countryAbbreviation) { Query query = em.createNamedQuery("BC_FIND_STATES_BY_COUNTRY_ABBREVIATION"); query.setParameter("countryAbbreviation", countryAbbreviation); query.setHint(QueryHints.HINT_CACHEABLE, true); return query.getResultList(); }
public Role readRoleByName(String name) { Query query = em.createNamedQuery("BC_READ_ROLE_BY_NAME"); query.setParameter("name", name); return (Role) query.getSingleResult(); }