Try looking at an employee object, with the object editor if there is something wrong with the mapping, it will likely throw an error rather than give you the information you inputted.
If you used exactly the same fields in the class as the tutorial and you ran the groovy script and clicked "To inject custom mapping for this class, click here" here. (an I assume you did since you have xwikicustom_xwiki_employee table) then your mapping should be fine. Are you sure you stopped the server and changed # xwiki.store.hibernate.custommapping.dynamic=0 to =1 then restarted it. (this mistake busted me a few times ;) ) Caleb James DeLisle farouk korteby wrote: > Yes, i get xwikicustom_xwiki_employee table > and SELECT * FROM xwikicustom_xwiki_employee; query show me a liste of > my employees. > > But i think the mastake is in the mapping. > > 2009/12/5 Caleb James DeLisle <[email protected]> > >> Can you get a list of tables in your database? There should be a table >> called >> xwikicustom_xwiki_employee >> >> Did you run the test command from the sql console? >> SELECT * FROM xwikicustom_xwiki_employee; >> >> >> Caleb James DeLisle >> >> >> farouk korteby wrote: >>> *Hi,* >>> * >>> * >>> *I try to implement this tutorial : * >>> http://dev.xwiki.org/xwiki/bin/view/Drafts/DynamicCustomMapping* >>> >>> * >>> *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.store.XWikiHibernateStore.search(XWikiHibernateStore.java:2072) >>> at >>> >> com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:2061) >>> at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:581) >>> at com.xpn.xwiki.XWiki.search(XWiki.java:1569) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) >>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) >>> at java.lang.reflect.Method.invoke(Unknown Source) >>> at >>> >> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389) >>> at >>> >> org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378) >>> at >>> >> org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270) >>> ... 100 more >>> >>> *Any ideas ?* >>> >>> >> _______________________________________________ >> devs mailing list >> [email protected] >> http://lists.xwiki.org/mailman/listinfo/devs >> > > > _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
