I have a table with @Entity(name = "\"user\"") , when I create a query to it I get exception:
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)
at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1825)
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:531)
... 112 more
Sample code for this bug is:
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();
I posted issue on tracker of Spring Data JPA, but they sent me to you (https://jira.spring.io/browse/DATAJPA-843) |