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
