<
From version < 1.6 >
edited by Tobias2Roth2
on 2007/11/14
To version < 1.7 >
edited by Tobias2Roth2
on 2007/11/14
>
Change comment: There is no comment for this version

Summary

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&#45;core\\\src\\\main\\\resources\\\~~ and recompile everything.
23 +* Add {attach:xwiki.mssql.hbm.sql|xwiki.mssql.hbm.xml} to ~~xwiki&#45;core\\\src\\\main\\\resources\\\~~ and recompile everything.
26 26  
27 27  \\
28 -1.1 When using a binary (e.g. a downloaded .war)
26 +1.1 When using a downloaded .war
29 29  
30 -* Save the file xwiki.mssql.hbm.sql as ~~WEB&#45;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&#45;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&#45;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 -<!&#45;&#45; MSSQL configuration &#45;&#45;>
39 - <property name="connection.url">jdbc:jtds:sqlserver://bl01svdwh01.bns&#45;group.com:1433/XWiki;tds=8.0;lastupdatecount=true</property>
38 +<property name="connection.url">jdbc:jtds:sqlserver://bl01svdwh01.bns&#45;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&#95;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&#45;sensitive.

Get Connected