Changes for page Microsoft SQL Server Installation
Last modified by Thomas Mortagne on 2023/10/10
From version 1.6
edited by Tobias2Roth2
on 2007/11/14
on 2007/11/14
Change comment:
Upload new attachment <a href="/xwiki/bin/downloadrev/AdminGuide/InstallationMSSQL/xwiki.mssql.hbm.xml?rev=1.1">xwiki.mssql.hbm.xml</a>
To version 1.7
edited by Tobias2Roth2
on 2007/11/14
on 2007/11/14
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,5 +3,3 @@ 1 -*This page is currently being edited. Please come back in an hour to see the final version* 2 - 3 3 1 Microsoft SQL Server Installation 4 4 5 5 #info("This has been tested only on MSSQL 2000. MSSQL 2005 will probably not work due to the depreciation of the text types.") ... ... @@ -22,12 +22,12 @@ 22 22 \\ 23 23 1.1 When compiling from source 24 24 25 -* Add xwiki.mssql.hbm.sql to ~~xwiki-core\\\src\\\main\\\resources\\\~~ and recompile everything. 23 +* Add {attach:xwiki.mssql.hbm.sql|xwiki.mssql.hbm.xml} to ~~xwiki-core\\\src\\\main\\\resources\\\~~ and recompile everything. 26 26 27 27 \\ 28 -1.1 When using a binary (e.g. adownloaded .war)26 +1.1 When using a downloaded .war 29 29 30 -* Save the file xwiki.mssql.hbm.sql as ~~WEB-INF/classes/xwiki.mssql.hbm.xml~~ (creating the ~~classes~~ directory if needed). This directory can be found inside the XWiki war, which is either a directory or a zip file. 28 +* Save the file {attach:xwiki.mssql.hbm.sql|xwiki.mssql.hbm.xml} as ~~WEB-INF/classes/xwiki.mssql.hbm.xml~~ (creating the ~~classes~~ directory if needed). This directory can be found inside the XWiki war, which is either a directory or a zip file. 31 31 32 32 \\ 33 33 1.1 XWiki configuration ... ... @@ -34,9 +34,10 @@ 34 34 35 35 * Tell XWiki to use MSSQL. To do this, edit the ~~WEB-INF/hibernate.cfg.xml~~ file. Replace the matching properties with the following ones (or uncomment them if they are present): 36 36 35 +\\ 36 + 37 37 {code} 38 -<!-- MSSQL configuration --> 39 - <property name="connection.url">jdbc:jtds:sqlserver://bl01svdwh01.bns-group.com:1433/XWiki;tds=8.0;lastupdatecount=true</property> 38 +<property name="connection.url">jdbc:jtds:sqlserver://bl01svdwh01.bns-group.com:1433/XWiki;tds=8.0;lastupdatecount=true</property> 40 40 <property name="connection.username">xwiki</property> 41 41 <property name="connection.password">xwiki</property> 42 42 <property name="connection.driver_class ">net.sourceforge.jtds.jdbc.Driver</property> ... ... @@ -47,6 +47,8 @@ 47 47 {code} 48 48 49 49 \\ 49 + 50 +\\ 50 50 1.1 Fix search function 51 51 52 52 If you try to do a search, via [Main.WebSearch], you will get an error. This is because the UPPER() function doesn not work on TEXT or NTEXT as used by MSSQL 2000 for blobs. The only solution I have found is to remove all the calls to upper() in [Main.WebSearch]. This is however not very practical, because it makes search case-sensitive.