Hibernate might have been updated since I wrote the tutorial, I'll try the
tutorial myself.
Caleb James DeLisle
farouk korteby wrote:
> the some result :
> *code *:
> {{groovy}}
> xc = xcontext.getContext();
> for(String name : xc.getWiki().getHibernateStore().search("SELECT
> e.familyName from EmployeeClass as e", 0,0, xc)){
> println(name);
> }
> {{/groovy}}
>
> *exception result* :
>
> Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3:
> Exception while searching documents with sql SELECT e.familyName from
> EmployeeClass as e
> Wrapped Exception: EmployeeClass is not mapped [SELECT e.familyName
> from EmployeeClass as e]
> 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 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.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:229)
> at
> org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)
> at
> org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
> at
> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
> at
> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:137)
> at Script3.run(Script3.groovy:2)
> at
> org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:305)
> ... 97 more
>
> I use another way to do successfully qeries with this plugin
> http://xwikisql.gradsoft.ua/docs/XWikiSqlPluginGuide.html
>
> I think there are a bug "Dynamic Custom Mapping" in XE 2.0.3, I'll try to
> add him in JIRA.
>
> Thank you.
>
> 2009/12/5 Caleb James DeLisle <[email protected]>
>
>> I'm running out of ideas, but it seems as if there are spaces being added
>> to EmployeeClass
>> and to familyName. These would definitly break the query.
>>
>> Maybe possibly it's velocity to blame, I only tested the tutorial in groovy
>> so why not try:
>>
>> {{groovy}}
>> xc = xcontext.getContext();
>> for(String name : xc.getWiki().getHibernateStore().search("SELECT
>> e.familyName from EmployeeClass as e", 0,0, xc));
>> println(name);
>> }
>> {{/groovy}}
>>
>> I also have it going directally to XWikiHibernateStore to run the query.
>>
>> Caleb James DeLisle
>>
>> farouk korteby wrote:
>>> I tried with "select e.familyName from XWiki.EmployeeClass as e" but i
>> get
>>> the some exception :
>>>
>>> Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3:
>>> Exception while searching documents with sql SELECT e.familyName from
>>> XWiki.EmployeeClass e
>>> Wrapped Exception: XWiki.EmployeeClass is not mapped family Name from
>>> XWiki.Employee Class e?
>>> <
>> http://127.0.0.1:8080/xwiki/bin/edit/SELECT+e.familyName+from+XWiki/EmployeeClass+e?parent=XWiki.QueryEmployee
>>> 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)
>>> … 97 more
>>>
>>> is there a way to get the list of mapped classes in XWiki or Hibernate
>> APIs
>>> ?
>>>
>>>
>>> 2009/12/5 Caleb James DeLisle <[email protected]>
>>>
>>>> You are so close, it is successfully putting data into the custom mapped
>>>> table and
>>>> presumably taking it out. The entire problem has to be in the query.
>>>> Can you confirm that the EmployeeClass document is in the space XWiki?
>>>> You might try "select e.familyName from XWiki.EmployeeClass as e"
>>>>
>>>> Caleb James DeLisle
>>>>
>>>> farouk korteby wrote:
>>>>> *
>>>>> i find all configuration correct, u can verify also. (i use XE 2.0.3)
>>>>>
>>>>> can i get a API to list all mapped tables in hibernate ?
>>>>>
>>>>> 1- My xwiki.cfg*
>>>>> #-# Allow or disable custom mapping for particular XClasses. Custom
>>>> mapping
>>>>> may increase the performance of certain
>>>>> #-# queries when large number of objects from particular classes are
>> used
>>>> in
>>>>> the wiki.
>>>>> *xwiki.store.hibernate.custommapping=1*
>>>>> #-# Dynamic custom mapping.
>>>>> *xwiki.store.hibernate.custommapping.dynamic=1*
>>>>> *
>>>>> *
>>>>> *2- My data in custom mapping table*
>>>>> see the image attached bellow
>>>>>
>>>>> *3- Simple Query without custom mapping*
>>>>> *
>>>>> *
>>>>> *code *:
>>>>> *#set($sql = "select doc.fullName from XWikiDocument as doc, BaseObject
>>>> as
>>>>> obj where obj.name=doc.fullName and
>> obj.className='XWiki.EmployeeClass'
>>>> ")*
>>>>> *
>>>>> *
>>>>> *#foreach($EmployeeDoc in $xwiki.search($sql))*
>>>>> ** $familyName*
>>>>> *#end*
>>>>> *
>>>>> *
>>>>> *Result :*
>>>>>
>>>>>
>>>>> - XWiki.EmployeeTemplate
>>>>> - Main.Employee1
>>>>> - Main.Employee2
>>>>>
>>>>>
>>>>> *4- Query with custom mapping*
>>>>> *
>>>>> *
>>>>> *
>>>>> code :
>>>>> #set($xc = $context.getContext())
>>>>> #set($sql = "SELECT e.familyName from EmployeeClass e")
>>>>> #set($familyNames = $xc.getWiki().search($sql , $xc))
>>>>> #foreach($familyName in $familyNames)
>>>>> * $familyName
>>>>> #end
>>>>>
>>>>> Result :
>>>>>
>>>>> Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3:
>>>>> Exception while searching documents with sql SELECT e.familyName from
>>>>> EmployeeClass e
>>>>> Wrapped Exception: EmployeeClass is not mapped family Name from
>>>>> Employee Class e?
>>>>> <
>> http://127.0.0.1:8080/xwiki/bin/edit/SELECT+e/familyName+from+EmployeeClass+e?parent=XWiki.QueryEmployee
>>>>> 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)
>>>>> … 97 more
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> *
>>>>> 2009/12/5 Caleb James DeLisle <[email protected]>
>>>>>
>>>>>> 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
>>>>>>
>>>>>
>>>>>
>>>>>
>> ------------------------------------------------------------------------
>>>>> _______________________________________________
>>>>> devs mailing list
>>>>> [email protected]
>>>>> http://lists.xwiki.org/mailman/listinfo/devs
>>>> _______________________________________________
>>>> devs mailing list
>>>> [email protected]
>>>> http://lists.xwiki.org/mailman/listinfo/devs
>>>>
>>>
>>>
>> _______________________________________________
>> devs mailing list
>> [email protected]
>> http://lists.xwiki.org/mailman/listinfo/devs
>>
>
>
>
_______________________________________________
devs mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/devs
