Summary

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

Details

Page properties

Content

...	...	@@ -31,16 +31,20 @@
31	31	* 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):
32	32
33	33	{code:none}
34		-<property name="connection.url">jdbc:jtds:sqlserver://bl01svdwh01.bns&#45;group.com:1433/XWiki;tds=8.0;lastupdatecount=true</property>
	34	+<property name="connection.url">jdbc:jtds:sqlserver://<server-url>:1433/XWiki;tds=8.0;lastupdatecount=true</property>
35	35	<property name="connection.username">xwiki</property>
36	36	<property name="connection.password">xwiki</property>
37		- <property name="connection.driver&#95;class ">net.sourceforge.jtds.jdbc.Driver</property>
	37	+ <property name="connection.driver_class ">net.sourceforge.jtds.jdbc.Driver</property>
38	38	<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
	39	+ <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
	40	+ <property name="connection.pool_size">2</property>
	41	+ <property name="statement_cache.size">2</property>
39	39	<mapping resource="xwiki.mssql.hbm.xml"/>
40	40	<mapping resource="feeds.hbm.xml"/>
41	41
42	42	{code}
43	43
	47	+
44	44	1.1 Fix search function
45	45
46	46	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.