5 Dec
2009
5 Dec
'09
1:30 p.m.
That tutorial is for creating a hibernate mapping for the Employee entity.
There are numerous little mistakes which will make it fail rather silently,
resulting in the "you haven't mapped employee" error.
Caleb James DeLisle
Lukasz Skowronski wrote:
----- 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
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs