Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -5,8 +5,8 @@
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.")
6	6
7	7	#warning("Case-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]")
8		-\\
9	9
	9	+\\
10	10	1.1 Create the xwiki user and database
11	11
12	12	* Use the Enterprise Manager to create a database named 'XWiki' and a user named 'xwiki'.
...	...	@@ -13,23 +13,27 @@
13	13	* Set xwiki's password to 'xwiki'.
14	14	* Give database ownership of the database XWiki to the user xwiki.
15	15
	16	+\\
16	16	1.1 Install the JDBC driver
17	17
18	18	* 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\\\~~)
19	19	* 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.
20	20
	22	+\\
21	21	1.1 When compiling from source
22		-* Add xwiki.mssql.hbm.sql to ~~xwiki-core\\\src\\\main\\\resources\\\~~ and recompile everything.
23	23
	25	+* Add xwiki.mssql.hbm.sql to ~~xwiki-core\\\src\\\main\\\resources\\\~~ and recompile everything.
	26	+
	27	+\\
24	24	1.1 When using a binary (e.g. a downloaded .war)
	29	+
25	25	* 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.
26	26
	32	+\\
27	27	1.1 XWiki configuration
28	28
29		-* Tell XWiki to use MSSQL. To do this, edit the ~~WEB-INF/hibernate.cfg.xml~~ file where you have expanded the XWiki WAR file. Replace the matching properties with the following ones (or uncomment them if they are present):
	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):
30	30
31		-\\
32		-
33	33	{code}
34	34	<!&#45;&#45; MSSQL configuration &#45;&#45;>
35	35	<property name="connection.url">jdbc:jtds:sqlserver://bl01svdwh01.bns&#45;group.com:1433/XWiki;tds=8.0;lastupdatecount=true</property>
...	...	@@ -42,7 +42,7 @@
42	42
43	43	{code}
44	44
45		-
	49	+\\
46	46	1.1 Fix search function
47	47
48	48	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.