Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-4664

MSSQL-Mapping XE 2.0.3

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Minor
    • None
    • 2.0.3
    • Model
    • None
    • XE 2.0.3, MS Server 2003, MSSQL 2005
    • XWiki MSSQL
    • Unknown

    Description

      Updating XE from 1.7.1 to 2.0.3 with an MSSQL Database we found, that with the provided Mapping-File (xwiki.mssql.hbm.xml) works but is not full functional e.g. SQL-Error for Search-Tab in new WYSIWYG-Editor.

      In our Evaluation we found, that the problem is the use of datatype "text" in mssql (does not allow "select distinct") and that it should be changed to "varchar(max)".

      We created a new "xwiki.mssql.hbm.xml" and an update script for existing (upgraded) data bases which we could contribute (but i think i'm not allowed to add files to issues).

      Still MSSQL-Support should not be provided if its not tested sufficiently e.g. in the Index xwikiindex and xwikiorphansview still are not working.

      Attachments

        Issue Links

          Activity

            People

              sdumitriu Sergiu Dumitriu
              hel Helmut Lehner
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: