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