I have a table with @Entity(name = "\"user\"") , when I create a query to it I get exception:
{code:java}
Caused by: org.hibernate.QueryException: unexpected char: '"' [select generatedAlias0 from "user" as generatedAlias0 where generatedAlias0.phoneNumber=:param0 ]
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:234)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:142)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:76)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:150)
at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java: 298 302 )
at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java: 236 240 )
at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java: 1825 1894 )
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:531)
... 112 87 more
{code}
Sample code for this bug is:
{code:java}
CriteriaBuilder cb = entityManager.getCriteriaBuilder();
CriteriaQuery<User> cq = cb.createQuery(User.class);
Root<User> from = cq.from(User.class);
CriteriaQuery<User> select =cq.select(from);
TypedQuery<User> typedQuery = entityManager.createQuery(select);
List<User> resultlist= typedQuery.getResultList();
{code}
I posted issue on tracker of Spring Data JPA, but they sent me to you (https://jira.spring.io/browse/DATAJPA-843) |
|