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 <calebdelisle(a)lavabit.com>
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
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs