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%2Ex... 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-c... http://svn.xwiki.org/svnroot/xwiki/platform/core/tags/xwiki-core-1.5/xwiki-c... ) 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-tp841396p8414... Sent from the XWiki- Dev mailing list archive at Nabble.com.