When I invoke this in ejb:

  | query = "select book from Book book join book.title t join t.authors a 
where (upper(a.firstName)||' '||upper(a.lastName)=upper(:auth) or 
upper(a.lastName)||' '||upper(a.firstName)=upper(:auth)) and upper(t.title) 
like '%upper(:title)%' and book.price between :pr and :pr2";
  |                     return 
manager.createQuery(query).setParameter("title",title).setParameter("auth",author).setParameter("pr",priceFrom).setParameter("pr2",priceTo).getResultList();
  | 

i get the exception:
Caused by: javax.ejb.EJBException: javax.persistence.PersistenceExcepti
ibernate.HibernateException: could not locate named parameter [title]

Anyone knows what's wrong?

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3953300#3953300

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3953300

Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to