Re: [xwiki-users] Upgrade fails!

27 Feb 2009


      Sergiu Dumitriu-2 wrote:
...
[...]
Can you send me the old xwiki.hbm.xml file you had in the 0.9 instance?
I think there's a change in the mapping that's not documented.
Ah yes: here it comes (WEB-INF/classes/xwiki.hbm.xml): 

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping auto-import="true">

    <!-- com.xpn.xwiki.doc.XWikiDocument root -->
    <class name="com.xpn.xwiki.doc.XWikiDocument" table="xwikidoc">
        <id name="id" type="long" unsaved-value="any">
            <column name="XWD_ID" not-null="true"/>
            <generator class="assigned" />
        </id>
        <property name="fullName" type="string">
            <column name="XWD_FULLNAME" length="255" not-null="true"/>
        </property>

        <property name="name" type="string">
            <column name="XWD_NAME" length="255" not-null="true"/>
        </property>

        <property name="language" type="string">
            <column name="XWD_LANGUAGE" length="5" />
        </property>

        <property name="defaultLanguage" type="string">
            <column name="XWD_DEFAULT_LANGUAGE" length="5" />
        </property>

        <property name="translation" type="integer">
            <column name="XWD_TRANSLATION"  not-null="true" />
        </property>

        <property name="date" type="timestamp">
            <column name="XWD_DATE" not-null="true"/>
        </property>

        <property name="creationDate" type="timestamp">
            <column name="XWD_CREATION_DATE" />
        </property>

        <property name="author" type="string">
            <column name="XWD_AUTHOR" length="255"/>
        </property>

        <property name="creator" type="string">
            <column name="XWD_CREATOR" length="255"/>
        </property>

        <property name="web" type="string">
            <column name="XWD_WEB" length="255" not-null="true"/>
        </property>

        <property name="content" type="string">
            <column name="XWD_CONTENT" length="200000" not-null="true"/>
        </property>

        <property name="archive" type="string">
            <column name="XWD_ARCHIVE" length="200000" not-null="true"/>
        </property>

        <property name="version" type="string">
            <column name="XWD_VERSION" length="255" not-null="true"/>
        </property>

        <property name="parent" type="string">
            <column name="XWD_PARENT" length="511"/>
        </property>
    </class>

    <class name="com.xpn.xwiki.doc.XWikiAttachment" table="xwikiattachment">
        <id name="id" type="long" unsaved-value="any">
            <column name="XWA_ID" not-null="true"/>
            <generator class="assigned" />
        </id>

        <property name="docId" type="long">
            <column name="XWA_DOC_ID" />
        </property>

        <property name="filename" type="string">
            <column name="XWA_FILENAME" length="255" not-null="true"/>
        </property>

        <property name="filesize" type="integer">
            <column name="XWA_SIZE" />
        </property>

        <property name="date" type="timestamp">
            <column name="XWA_DATE" not-null="true" />
        </property>

        <property name="author" type="string">
            <column name="XWA_AUTHOR" length="255"/>
        </property>

        <property name="version" type="string">
            <column name="XWA_VERSION" length="255" not-null="true"/>
        </property>

        <property name="comment" type="string">
            <column name="XWA_COMMENT" length="255" />
        </property>
    </class>

    <class name="com.xpn.xwiki.doc.XWikiAttachmentContent"
table="xwikiattachment_content">
        <id name="id" type="long" unsaved-value="any">
            <column name="XWA_ID" not-null="true"/>
            <generator class="assigned" />
        </id>

        <property name="content" type="binary">
            <column name="XWA_CONTENT" length="4000000" not-null="true"/>
        </property>
    </class>

    <class name="com.xpn.xwiki.doc.XWikiAttachmentArchive"
table="xwikiattachment_archive">
        <id name="id" type="long" unsaved-value="any">
            <column name="XWA_ID" not-null="true"/>
            <generator class="assigned" />
        </id>
        <property name="archive" type="binary">
            <column name="XWA_ARCHIVE" length="4000000" />
        </property>
    </class>

    <class name="com.xpn.xwiki.objects.classes.PropertyClass"
table="xwikiclassesprop">
        <composite-id unsaved-value="any">
            <key-property name="id" column="XWP_ID" type="integer" />
            <key-property name="name" column="XWP_NAME" type="string" />
        </composite-id>
        <property name="prettyName" type="string">
            <column name="XWP_PRETTYNAME" length="255"/>
        </property>
        <property name="classType" type="string">
            <column name="XWP_CLASSTYPE" length="255"/>
        </property>
        <property name="unmodifiable" type="boolean">
            <column name="XWP_UNMODIFIABLE" />
        </property>
        <property name="number" type="integer">
            <column name="XWP_NUMBER" />
        </property>

        <joined-subclass name="com.xpn.xwiki.objects.classes.NumberClass"
table="xwikinumberclasses">
            <key>
                <column name="XWN_ID"  />
                <column name="XWN_NAME"  />
            </key>
            <property name="size" type="integer">
                <column name="XWN_SIZE" />
            </property>
            <property name="numberType" type="string">
                <column name="XWN_NUMBERTYPE" length="20" />
            </property>
        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.classes.StringClass"
table="xwikistringclasses">
            <key>
                <column name="XWS_ID"  />
                <column name="XWS_NAME"  />
            </key>
            <property name="size" type="integer">
                <column name="XWS_SIZE" />
            </property>

        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.classes.DateClass"
table="xwikidateclasses">
            <key>
                <column name="XWS_ID"  />
                <column name="XWS_NAME"  />
            </key>
            <property name="size" type="integer">
                <column name="XWS_SIZE" />
            </property>
            <property name="emptyIsToday" type="integer">
                <column name="XWS_EMPTY_IS_TODAY" />
            </property>

            <property name="dateFormat" type="string">
                <column name="XWS_DATE_FORMAT" length="255"/>
            </property>

        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.classes.PasswordClass"
table="xwikistringclasses">
            <key>
                <column name="XWS_ID"  />
                <column name="XWS_NAME"  />
            </key>
            <property name="size" type="integer">
                <column name="XWS_SIZE" />
            </property>

        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.classes.TextAreaClass"
table="xwikistringclasses">
            <key>
                <column name="XWS_ID"  />
                <column name="XWS_NAME"  />
            </key>
            <property name="size" type="integer">
                <column name="XWS_SIZE" />
            </property>
            <property name="rows" type="integer">
                <column name="XWS_ROWS" />
            </property>
        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.classes.BooleanClass"
table="xwikibooleanclasses">
            <key>
                <column name="XWN_ID"  />
                <column name="XWN_NAME"  />
            </key>
            <property name="displayType" type="string">
                <column name="XWN_DISPLAYTYPE" length="20" />
            </property>
        </joined-subclass>

        <joined-subclass
name="com.xpn.xwiki.objects.classes.StaticListClass"
table="xwikislistclasses">
            <key>
                <column name="XWL_ID"  />
                <column name="XWL_NAME"  />
            </key>
            <property name="displayType" type="string">
                <column name="XWL_DISPLAYTYPE" length="20" />
            </property>

            <property name="multiSelect" type="boolean">
                <column name="XWL_MULTISELECT" />
            </property>

            <property name="size" type="integer">
                <column name="XWL_SIZE" />
            </property>

            <property name="relationalStorage" type="boolean">
                <column name="XWL_RELATIONAL" />
            </property>

            <property name="values" type="string">
                <column name="XWL_VALUES" length="2000" />
            </property>

        </joined-subclass>


        <joined-subclass name="com.xpn.xwiki.objects.classes.DBListClass"
table="xwikidblistclasses">
            <key>
                <column name="XWL_ID"  />
                <column name="XWL_NAME"  />
            </key>
            <property name="displayType" type="string">
                <column name="XWL_DISPLAYTYPE" length="20" />
            </property>

            <property name="multiSelect" type="boolean">
                <column name="XWL_MULTISELECT" />
            </property>

            <property name="size" type="integer">
                <column name="XWL_SIZE" />
            </property>

            <property name="relationalStorage" type="boolean">
                <column name="XWL_RELATIONAL" />
            </property>

            <property name="sql" type="string">
                <column name="XWL_SQL" length="2000" />
            </property>

        </joined-subclass>

    </class>

    <class name="com.xpn.xwiki.objects.classes.BaseClass"
table="xwikiclasses">
        <id name="id" type="integer" unsaved-value="any">
            <column name="XWO_ID" not-null="true" />
            <generator class="assigned" />
        </id>
        <property name="name" type="string">
            <column name="XWO_NAME" not-null="true" length="255"/>
        </property>
    </class>


    <class name="com.xpn.xwiki.objects.BaseProperty"
table="xwikiproperties">
        <composite-id unsaved-value="any">
            <key-property name="id" column="XWP_ID" type="integer" />
            <key-property name="name" column="XWP_NAME" type="string" />
        </composite-id>
        <property name="classType" type="string">
            <column name="XWP_CLASSTYPE" length="255"/>
        </property>

        <joined-subclass name="com.xpn.xwiki.objects.IntegerProperty"
table="xwikiintegers">
            <key>
                <column name="XWI_ID"  />
                <column name="XWI_NAME"  />
            </key>
            <property name="value" type="integer">
                <column name="XWI_VALUE" />
            </property>
        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.LongProperty"
table="xwikilongs">
            <key>
                <column name="XWL_ID"  />
                <column name="XWL_NAME"  />
            </key>
            <property name="value" type="long">
                <column name="XWL_VALUE" />
            </property>
        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.FloatProperty"
table="xwikifloats">
            <key>
                <column name="XWF_ID"  />
                <column name="XWF_NAME"  />
            </key>
            <property name="value" type="float">
                <column name="XWF_VALUE" />
            </property>
        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.DoubleProperty"
table="xwikidoubles">
            <key>
                <column name="XWD_ID"  />
                <column name="XWD_NAME"  />
            </key>
            <property name="value" type="double">
                <column name="XWD_VALUE" />
            </property>
        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.StringProperty"
table="xwikistrings">
            <key>
                <column name="XWS_ID"  />
                <column name="XWS_NAME"  />
            </key>
            <property name="value" type="string">
                <column name="XWS_VALUE" length="255" />
            </property>
        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.DateProperty"
table="xwikidates">
            <key>
                <column name="XWS_ID"  />
                <column name="XWS_NAME"  />
            </key>
            <property name="value" type="timestamp">
                <column name="XWS_VALUE" />
            </property>
        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.LargeStringProperty"
table="xwikilargestrings">
            <key>
                <column name="XWL_ID"  />
                <column name="XWL_NAME"  />
            </key>
            <property name="value" type="string">
                <column name="XWL_VALUE" length="60000" />
            </property>
        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.StringListProperty"
table="xwikilargestrings">
            <key>
                <column name="XWL_ID"  />
                <column name="XWL_NAME"  />
            </key>
            <property name="textValue" type="string">
                <column name="XWL_VALUE" length="60000" />
            </property>
        </joined-subclass>

        <joined-subclass name="com.xpn.xwiki.objects.DBStringListProperty"
table="xwikilists">
            <key>
                <column name="XWL_ID"  />
                <column name="XWL_NAME"  />
            </key>
            <list name="list" table="xwikilistitems" batch-size="10">
                <key>
                    <column name="XWL_ID"  />
                    <column name="XWL_NAME"  />
                </key>
                <index column="XWL_NUMBER"/>
                <element column="XWL_VALUE" type="string" />
            </list>
        </joined-subclass>
    </class>
    <class name="com.xpn.xwiki.objects.BaseObject" table="xwikiobjects">
        <id name="id" type="integer" unsaved-value="any">
            <column name="XWO_ID" not-null="true" />
            <generator class="assigned" />
        </id>
        <property name="number" type="integer">
            <column name="XWO_NUMBER" not-null="false" />
        </property>
        <property name="name" type="string">
            <column name="XWO_NAME" not-null="true" length="255"/>
        </property>
        <property name="className" type="string">
            <column name="XWO_CLASSNAME" not-null="true" length="255"/>
        </property>
    </class>

    <class name="com.xpn.xwiki.stats.impl.DocumentStats"
table="xwikistatsdoc">
        <id name="id" type="integer" unsaved-value="any">
            <column name="XWS_ID" not-null="true" />
            <generator class="assigned" />
        </id>

        <property name="number" type="integer">
            <column name="XWS_NUMBER" not-null="false" />
        </property>
        <property name="name" type="string">
            <column name="XWS_NAME" not-null="true" length="255"/>
        </property>
        <property name="className" type="string">
            <column name="XWS_CLASSNAME" not-null="true" length="255"/>
        </property>

        <property name="action" type="string">
            <column name="XWS_ACTION" not-null="true" length="255"/>
        </property>

        <property name="pageViews" type="integer">
            <column name="XWS_PAGE_VIEWS" not-null="false" />
        </property>

        <property name="uniqueVisitors" type="integer">
            <column name="XWS_UNIQUE_VISITORS" not-null="false" />
        </property>

        <property name="period" type="integer">
            <column name="XWS_PERIOD" not-null="false" />
        </property>

        <property name="visits" type="integer">
            <column name="XWS_VISITS" not-null="false" />
        </property>
    </class>

    <class name="com.xpn.xwiki.stats.impl.RefererStats"
table="xwikistatsreferer">
        <id name="id" type="integer" unsaved-value="any">
            <column name="XWR_ID" not-null="true" />
            <generator class="assigned" />
        </id>

        <property name="number" type="integer">
            <column name="XWR_NUMBER" not-null="false" />
        </property>
        <property name="name" type="string">
            <column name="XWR_NAME" not-null="true" length="255"/>
        </property>
        <property name="className" type="string">
            <column name="XWR_CLASSNAME" not-null="true" length="255"/>
        </property>

        <property name="referer" type="string">
            <column name="XWR_REFERER" not-null="true" length="255"/>
        </property>

        <property name="pageViews" type="integer">
            <column name="XWR_PAGE_VIEWS" not-null="false" />
        </property>

        <property name="period" type="integer">
            <column name="XWR_PERIOD" not-null="false" />
        </property>
    </class>


    <class name="com.xpn.xwiki.stats.impl.VisitStats"
table="xwikistatsvisit">
        <id name="id" type="integer" unsaved-value="any">
            <column name="XWV_ID" not-null="true" />
            <generator class="assigned" />
        </id>

        <property name="number" type="integer">
            <column name="XWV_NUMBER" not-null="false" />
        </property>
        <property name="name" type="string">
            <column name="XWV_NAME" not-null="true" length="255"/>
        </property>
        <property name="className" type="string">
            <column name="XWV_CLASSNAME" not-null="true" length="255"/>
        </property>

        <property name="IP" type="string">
            <column name="XWV_IP" not-null="true" length="32"/>
        </property>

        <property name="userAgent" type="string">
            <column name="XWV_USER_AGENT" not-null="true" length="255"/>
        </property>

        <property name="cookie" type="string">
            <column name="XWV_COOKIE" not-null="true" length="255"/>
        </property>

        <property name="uniqueID" type="string">
            <column name="XWV_UNIQUE_ID" not-null="true" length="255"/>
        </property>

        <property name="pageViews" type="integer">
            <column name="XWV_PAGE_VIEWS" not-null="false" />
        </property>

        <property name="pageSaves" type="integer">
            <column name="XWV_PAGE_SAVES" not-null="false" />
        </property>

        <property name="downloads" type="integer">
            <column name="XWV_DOWNLOADS" not-null="false" />
        </property>

        <property name="startDate" type="timestamp">
            <column name="XWV_START_DATE" not-null="false" />
        </property>

        <property name="endDate" type="timestamp">
            <column name="XWV_END_DATE" not-null="false" />
        </property>
    </class>

</hibernate-mapping>

-- 
View this message in context: http://n2.nabble.com/Upgrade-fails%21-tp2378958p2394349.html
Sent from the XWiki- Users mailing list archive at Nabble.com.

Re: [xwiki-users] Upgrade fails!

Stefan Gundlach