Wiki source code of Custom Mapping
Version 2.2 by PeterLiverovsky on 2012/02/13
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | Custom Mappings allows to map a XWiki Class (XClass) to its own database table (as opposed to XClasses that are not mapped and that use the standard, predefined, XWiki table scheme). Custom mapping can be useful for improving performances (when expecting a class to have a large number of instances for example), or for sharing external data (enterprise data, or other software data for example) with XWiki. |
| 2 | |||
| 3 | Making use of custom mapping is a 3 step process: | ||
| 4 | 1. Define the actual Hibernate mapping for your XClass, in a ##hbm.xml## file (see the example below). This file should then be made available somewhere in the CLASSPATH (##WEB-INF/classes## or in your own JAR file that you put in ##WEB-INF/lib##).((( | ||
| 5 | |||
| 6 | Example Mapping file (##mailinglist.hbm.xml##): | ||
 |
1.2 | 7 | |
| |
1.1 | 8 | {{code language="xml"}} |
| 9 | <?xml version="1.0"?> | ||
| 10 | <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" | ||
| 11 | "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> | ||
| 12 | <hibernate-mapping> | ||
| 13 | <class entity-name="Mailing.MailingMemberClass" table="mailing"> | ||
| 14 | <id name="id" type="integer" unsaved-value="any"><column name="mam_id" not-null="true" /><generator class="assigned" /></id> | ||
| 15 | <property name="member" type="text"><column name="mam_member" /></property> | ||
| 16 | <property name="to" type="text"><column name="mam_to" /></property> | ||
| 17 | <property name="from" type="text"><column name="mam_from" /></property> | ||
| 18 | <property name="subject" type="text"><column name="mam_subject" /></property> | ||
| 19 | <property name="smtphost" type="text"><column name="mam_smtphost" /></property> | ||
| 20 | <property name="mailing" type="text"><column name="mam_mailing" /></property> | ||
| 21 | <property name="status" type="text"><column name="mam_status" /></property> | ||
| 22 | <property name="body" type="text"><column name="mam_body" /></property> | ||
| 23 | <property name="alternative" type="text"><column name="mam_alternative" /></property> | ||
| 24 | </class> | ||
| 25 | </hibernate-mapping> | ||
| 26 | {{/code}} | ||
| |
1.2 | 27 | |
| |
1.1 | 28 | ))) |
| 29 | 1. Reference your ##hbm.xml## file in the Hibernate configuration file located in ##WEB-INF/hibernate.cfg.xml##, by adding a ##mapping## element. For example:((( | ||
| 30 | {{code language="xml"}} | ||
| 31 | <mapping resource="/some/package/mailinglist.hbm.xml"/> | ||
| 32 | {{/code}} | ||
| 33 | ))) | ||
| 34 | 1. Last, the XClass for which the mapping has been written should be set as containing a custom mapping. Unfortunately there's currently no way to set this using the XWiki Enterprise UI so you'll have to set it programmatically. The following Groovy snippet will do the trick (Remember that for Groovy code to be executed, the page that contains the code should be saved by a user having the programming right allowed on that document). Note that this could also be done in a Java component.((( | ||
| 35 | {{code}} | ||
| 36 | {{groovy}} | ||
| 37 | classDoc = xwiki.getDocument("Mailing.MailingMemberClass") | ||
| 38 | classDoc2 = classDoc.document | ||
| 39 | println "Before: " | ||
| 40 | println classDoc2.xWikiClass.customMapping | ||
| 41 | classDoc2.xWikiClass.setCustomMapping("internal") | ||
 |
2.2 | 42 | xcontext.getContext().getWiki().saveDocument(classDoc2, xcontext.getContext()) |
| |
1.1 | 43 | classDoc = xwiki.getDocument("Mailing.MailingMemberClass") |
| 44 | println " After: " | ||
| 45 | println classDoc2.xWikiClass.customMapping | ||
| 46 | {{/groovy}} | ||
| 47 | {{/code}} | ||
| 48 | ))) | ||
| 49 | |||
| 50 | Once these 3 steps have been done, loading and saving of your XClass will go in the table you've defined in your custom Hibernate mapping file. |
