Changes for page Microsoft SQL Server Installation

Summary

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

Details

Page properties

Content

...	...	@@ -1,18 +2,23 @@
1		-
2	2	*This page is currently being edited. Please come back in an hour to see the final version*
3	3
4	4	1 Microsoft SQL Server Installation
5	5
6	6	#info("This has been tested only on MSSQL 2000. MSSQL 2005 will probably not work due to the depreciation of the text types.")
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	8
	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	1.1 Create the xwiki user and database
	11	+
10	10	* Use the Enterprise Manager to create a database named 'XWiki' and a user named 'xwiki'.
11	11	* Set xwiki's password to 'xwiki'.
12	12	* Give database ownership of the database XWiki to the user xwiki.
13	13
14		-1.1 Install the driver
	16	+1.1 Install the JDBC driver
15	15
	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	+* 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	+
16	16	1.1 When compiling from source
17	17
18	18	1.1 When using a binary (e.g. a downloaded .war)
...	...	@@ -19,23 +19,28 @@
19	19
20	20	1.1 XWiki configuration
21	21
22		-* 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):
	27	+* 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):
	28	+
	29	+\\
	30	+
23	23	{code}
24		-<property name="connection.url">jdbc:db2:xwiki</property>
25		-<property name="connection.username">xwiki</property>
26		-<property name="connection.password">xwiki</property>
27		-<property name="connection.driver_class">com.ibm.db2.jcc.DB2Driver</property>
28		-<property name="dialect">org.hibernate.dialect.DB2Dialect</property>
29		-<property name="connection.pool_size">2</property>
30		-<property name="statement_cache.size">2</property>
	32	+<!&#45;&#45; MSSQL configuration &#45;&#45;>
	33	+ <property name="connection.url">jdbc:jtds:sqlserver://bl01svdwh01.bns&#45;group.com:1433/XWiki;tds=8.0;lastupdatecount=true</property>
	34	+ <property name="connection.username">xwiki</property>
	35	+ <property name="connection.password">xwiki</property>
	36	+ <property name="connection.driver&#95;class ">net.sourceforge.jtds.jdbc.Driver</property>
	37	+ <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
	38	+ <mapping resource="xwiki.mssql.hbm.xml"/>
	39	+ <mapping resource="feeds.hbm.xml"/>
31	31
32		-<mapping resource="xwiki.db2.hbm.xml"/>
33		-<mapping resource="feeds.hbm.xml"/>
34	34	{code}
35		-* The file ~~xwiki.db2.hbm.xml~~ is not currently shipped with XWiki, so it must be added to the installation. The easiest way to do this is to create the file as ~~WEB-INF/classes/xwiki.db2.hbm.xml~~ (creating the ~~classes~~ directory if needed) and restarting XWiki.
36	36
	43	+\\
	44	+
	45	+* The file ~~xwiki.mssql.hbm.xml~~ is not currently shipped with XWiki, so it must be added to the installation. The easiest way to do this is to create the file as ~~WEB&#45;INF/classes/xwiki.db2.hbm.xml~~ (creating the ~~classes~~ directory if needed) and restarting XWiki.
	46	+
37	37	1.1 Fix search function
38	38
39		-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.
	49	+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.
40	40
41	41	Alternatively, you may want to use the [Lucene search page>Code.LuceneSearchPage] instead of the default search.