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

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -