<
From version < 2.1 >
edited by Vincent Massol
on 2007/12/06
To version < 2.2 >
edited by Vincent Massol
on 2007/12/10
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -2,9 +2,8 @@
2 2  
3 3  #info("This has been tested only on MSSQL 2000. MSSQL 2005 will probably not work due to the depreciation of the text types.")
4 4  
5 -#warning("Case&#45;insensitive search does not work with this database; see below for more info. You may want to use the the [Lucene search page>Code.LuceneSearchPage]")
5 +#warning("Case&#45;insensitive search does not work with this database; see below for more info. You may want to use the the [Lucene search>code:Applications.SearchApplication]")
6 6  
7 -\\
8 8  1.1 Create the xwiki user and database
9 9  
10 10  * Use the Enterprise Manager to create a database named 'XWiki' and a user named 'xwiki'.
... ... @@ -11,30 +11,24 @@
11 11  * Set xwiki's password to 'xwiki'.
12 12  * Give database ownership of the database XWiki to the user xwiki.
13 13  
14 -\\
15 15  1.1 Install the JDBC driver
16 16  
17 17  * Download the [jtds jdbc driver>http://jtds.sourceforge.net/] and install the jar file into your servers lib directory (for JBoss this could be ~~server\\\default\\\lib\\\~~, for Tomcat this might be ~~common\\\lib\\\~~)
18 18  * Alternatively, you can use the [JDBC driver provided by Microsoft>http://www.microsoft.com/downloads/details.aspx?familyid=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en], however this has not been tested.
19 19  
20 -\\
21 21  1.1 When compiling from source
22 22  
23 23  * Add {attach:xwiki.mssql.hbm.sql|xwiki.mssql.hbm.xml} to ~~xwiki&#45;core\\\src\\\main\\\resources\\\~~ and recompile everything.
24 24  
25 -\\
26 26  1.1 When using a downloaded .war
27 27  
28 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.
29 29  
30 -\\
31 31  1.1 XWiki configuration
32 32  
33 33  * 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):
34 34  
35 -\\
36 -
37 -{code}
30 +{code:none}
38 38  <property name="connection.url">jdbc:jtds:sqlserver://bl01svdwh01.bns&#45;group.com:1433/XWiki;tds=8.0;lastupdatecount=true</property>
39 39   <property name="connection.username">xwiki</property>
40 40   <property name="connection.password">xwiki</property>
... ... @@ -45,11 +45,8 @@
45 45  
46 46  {code}
47 47  
48 -\\
49 -
50 -\\
51 51  1.1 Fix search function
52 52  
53 53  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.
54 54  
55 -Alternatively, you may want to use the [Lucene search page>Code.LuceneSearchPage] instead of the default search.
45 +Alternatively, you may want to use the [Lucene search>code:Applications.SearchApplications] instead of the default search.

Get Connected