11:18 a.m.
Problem whith criteria search
-----------------------------
Key: JPA-27
URL: http://opensource.atlassian.com/projects/hibernate/browse/JPA-27
Project: Java Persistence API
Issue Type: Bug
Affects Versions: 1.0.0
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
11:39 a.m.
New subject: [Hibernate-JIRA] Commented: (JPA-27) Problem whith criteria search
[
http://opensource.atlassian.com/projects/hibernate/browse/JPA-27?page=com...
]
Samuel Rettore commented on JPA-27:
-----------------------------------
I tried to use it in another way
ParameterExpression<Date> dt = builder.parameter(Date.class);
setParameter(dt, dataSaldo, TemporalType.DATE).
And it worked! informs me would know because the date can not directly compare.
Problem whith criteria search
-----------------------------
Key: JPA-27
URL: http://opensource.atlassian.com/projects/hibernate/browse/JPA-27
Project: Java Persistence API
Issue Type: Bug
Affects Versions: 1.0.0
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
7:10 a.m.
New subject: [Hibernate-JIRA] Moved: (HHH-7024) Problem whith criteria search
[
https://hibernate.onjira.com/browse/HHH-7024?page=com.atlassian.jira.plug...
]
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
7:14 a.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-7024) Use of date literals with JPA criteria queries is broken
[
https://hibernate.onjira.com/browse/HHH-7024?page=com.atlassian.jira.plug...
]
Steve Ebersole edited comment on HHH-7024 at 2/6/12 7:13 AM:
-------------------------------------------------------------
The initial criteria and jpql queries you listed are *not* equivalent. The criteria form
is using a literal for the date, while the jpql query is using a parameter for the date.
was (Author: steve):
The initial criteria and jpql queries you listed are *not* equivalent. The criteria
form is using a literal for the date, while the jpql query is using a parameter for the
query.
Use of date literals with JPA criteria queries is broken
--------------------------------------------------------
Key: HHH-7024
URL: https://hibernate.onjira.com/browse/HHH-7024
Project: Hibernate ORM
Issue Type: Bug
Components: entity-manager
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
7:14 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-7024) Use of date literals with JPA criteria queries is broken
[
https://hibernate.onjira.com/browse/HHH-7024?page=com.atlassian.jira.plug...
]
Steve Ebersole updated HHH-7024:
--------------------------------
Component/s: entity-manager
Summary: Use of date literals with JPA criteria queries is broken (was: Problem
whith criteria search)
The initial criteria and jpql queries you listed are *not* equivalent. The criteria form
is using a literal for the date, while the jpql query is using a parameter for the query.
Use of date literals with JPA criteria queries is broken
--------------------------------------------------------
Key: HHH-7024
URL: https://hibernate.onjira.com/browse/HHH-7024
Project: Hibernate ORM
Issue Type: Bug
Components: entity-manager
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
4724
days inactive
4749
days old
hibernate-issues@lists.jboss.org
4 comments
2 participants
participants (2)
-
Samuel Rettore (JIRA) -
Steve Ebersole (JIRA)