java - JPA named query cannot be resolved with Hibernate -
i have added new named query:
@entity(name = "books") @namedqueries({ @namedquery(name = "books.findbycategoryid", query = "select distinct b.* books b b.categoryid =:categoryid") }) public class book implements serializable { i use hibernate dao implementation:
@override public set<book> findbycategory(long categoryid) { return new linkedhashset<book>( sessionfactory.getcurrentsession(). getnamedquery("books.findbycategoryid"). setparameter("categoryid", categoryid).list()); } for reason in ide see: cannot resolve query 'books.findbycategoryid'. when start application i'm getting:
may 10, 2013 6:55:05 pm org.apache.catalina.core.standardcontext loadonstartup severe: servlet /springwebflow threw load() exception org.hibernate.hibernateexception: errors in named queries: books.findbycategoryid @ org.hibernate.internal.sessionfactoryimpl.<init>(sessionfactoryimpl.java:528) @ org.hibernate.cfg.configuration.buildsessionfactory(configuration.java:1760) @ org.hibernate.cfg.configuration.buildsessionfactory(configuration.java:1798)
the hibernate error: "errors in named queries: books.findbycategoryid" means have syntax issue query. message ide bit misleading. pointed out @piotr change "b.*" "b" in query.
the the hibernate query language doesn't mention wildcard.
Comments
Post a Comment