Changes for page Microsoft SQL Server Installation

Summary

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

Details

Page properties

Content

...	...	@@ -1,2 +1,41 @@
1	1
2	2	*This page is currently being edited. Please come back in an hour to see the final version*
	3	+
	4	+1 Microsoft SQL Server Installation
	5	+
	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	+
	9	+1.1 Create the xwiki user and database
	10	+* Use the Enterprise Manager to create a database named 'XWiki' and a user named 'xwiki'.
	11	+* Set xwiki's password to 'xwiki'.
	12	+* Give database ownership of the database XWiki to the user xwiki.
	13	+
	14	+1.1 Install the driver
	15	+
	16	+1.1 When compiling from source
	17	+
	18	+1.1 When using a binary (e.g. a downloaded .war)
	19	+
	20	+1.1 XWiki configuration
	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):
	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>
	31	+
	32	+<mapping resource="xwiki.db2.hbm.xml"/>
	33	+<mapping resource="feeds.hbm.xml"/>
	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	+
	37	+1.1 Fix search function
	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.
	40	+
	41	+Alternatively, you may want to use the [Lucene search page>Code.LuceneSearchPage] instead of the default search.