[hibernate-issues] [Hibernate-JIRA] Moved: (HHH-7024) Problem whith criteria search

[Steve Ebersole (JIRA)]

     [ https://hibernate.onjira.com/browse/HHH-7024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole moved JPA-27 to HHH-7024:
----------------------------------------

    Affects Version/s:     (was: 1.0.0)
                       4.0.1
                  Key: HHH-7024  (was: JPA-27)
              Project: Hibernate ORM  (was: Java Persistence API)

> Problem whith criteria search
> -----------------------------
>
>                 Key: HHH-7024
>                 URL: https://hibernate.onjira.com/browse/HHH-7024
>             Project: Hibernate ORM
>          Issue Type: Bug
>    Affects Versions: 4.0.1
>            Reporter: Samuel Rettore
>
> Two criteria to a search and no one uses criteria that works with JPQL criteria does not work seems to be the date field where the comparison does not work.
> Criteria- fail
> CriteriaBuilder builder = em.getCriteriaBuilder();
>             CriteriaQuery<SrhaplicacaoSaldo> criteriaQuery = builder.createQuery(SrhaplicacaoSaldo.class);
>             Root<SrhaplicacaoSaldo> root = criteriaQuery.from(SrhaplicacaoSaldo.class);
>             criteriaQuery.select(root);
>             criteriaQuery.where(builder.equal(root.get(SrhaplicacaoSaldo_.idaplicacao).
>                     get(Srhaplicacao_.idaplicacao), idaplicacao),
>                     builder.equal(root.get(SrhaplicacaoSaldo_.dataSaldo), dataSaldo));
>             criteriaQuery.orderBy(builder.desc(root.get(SrhaplicacaoSaldo_.dataSaldo)), 
>                     builder.desc(root.get(SrhaplicacaoSaldo_.idaplicacaosaldo)));
>             return em.createQuery(criteriaQuery).
>                     setMaxResults(1).
>                     getSingleResult();
> JPQ - OK
>         return (SrhaplicacaoSaldo) em.createQuery("Select a from SrhaplicacaoSaldo a where "
>                 + "a.idaplicacao.idaplicacao=:idaplicacao and a.dataSaldo=:dtsaldo order by a.dataSaldo,a.idaplicacaosaldo ").
>                 setParameter("idaplicacao", idaplicacao).
>                 setParameter("dtsaldo", dataSaldo).
>                 setMaxResults(1).
>                 getSingleResult();
> Tanks.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira