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