Changes for page Microsoft SQL Server Installation

Summary

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

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.Tobias2Roth2
	1	+XWiki.VincentMassol

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. a downloaded .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		-<!&#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.