And things are getting better ! I've modified the mapping to explicitly use new sql server 2005 data type "varchar(max)" (instead of implicit use of "text" data type) Result is that normal xWiki case insensitive search (using sql) works without error (only on 2005)
Better solution would be to use (if exists) Hibernate dialect for SQL Server 2005 and do not modify mapping at all, but this is better than nothing. Here are both mappings: http://n2.nabble.com/file/n841498/xwiki.mssql2000_1.5.hbm.xml xwiki.mssql2000_1.5.hbm.xml http://n2.nabble.com/file/n841498/xwiki.mssql2005_1.5.hbm.xml xwiki.mssql2005_1.5.hbm.xml CY Liwoj wrote: > > I forget to mention one thing. > Before updating mssql mapping for 1.5 i was getting same error as > described > http://xwiki.markmail.org/message/y4ft577j7sd4xshp?q=xwiki%2Emssql%2Ehbm%2Exml&page=1 > here on user list > So I think updated mapping solves the issue > http://jira.xwiki.org/jira/browse/XWIKI-2623 > http://jira.xwiki.org/jira/browse/XWIKI-2623 > > Bye > > > Liwoj wrote: >> >> Hi >> >> I'm just managed to install xWiki 1.5 against Microsoft SQL Server 2005 >> It wasn't trivial so i have few things to say: >> >> 1) hbm.xml file (Hibernate mapping) file which is as a download on >> http://n2.nabble.com/file/n841396/xwiki.mssql_1.5.hbm.xml >> xwiki.mssql_1.5.hbm.xml >> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL >> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMSSQL >> is outdated. It works only for xWiki 1.4 and required some modifications >> (based on >> http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-core/src/main/resources/xwiki.hbm.xml >> http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-core/src/main/resources/xwiki.hbm.xml >> ) to work with 1.5 >> I'm attaching mapping to my post. >> >> 2) First note on MSSQL Installation guide mentioned before is not >> correct. Text types wasn't depreciated in MSSQL 2005, only marked as >> obsoleted. So attached mapping works ok on both MSSQL 2000&2005 >> >> HTH >> > > -- View this message in context: http://n2.nabble.com/-Solution--xWiki-1.5-on-MSSQL-2000---2005-tp841396p841498.html Sent from the XWiki- Dev mailing list archive at Nabble.com. _______________________________________________ devs mailing list devs@xwiki.org http://lists.xwiki.org/mailman/listinfo/devs
