----- Original Message ----- From: "farouk korteby"
* *But when i try to execute this query *
{{groovy}} xc = xcontext.getContext(); for(String name : xc.getWiki().search("SELECT e.familyName from Employee e",xc )); println(name); } {{/groovy}}
*i get this exception :* Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with sql SELECT familyName from Employee Wrapped Exception: Employee is not mapped [SELECT familyName from Employee] at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:2142) (...) at com.xpn.xwiki.XWiki.search(XWiki.java:1569)
Yeah, that's a trap for novices, it was a little gotcha for me few days ago ;) The search parameter is called sql but in fact when you're using Hibernate store you're supposed to supply hql query, not the sql. And this is quite misleading since in Hibernate we can execute both hql and sql queries. I think you'd have to create Hibernate mapping for Employee entity to use XWiki.search method. I'm not sure how to pass sql query to the Hibernate store. Kind regards Lukasz