Last modified by Thomas Mortagne on 2023/10/10

<
From version < 3.3 >
edited by Helmut Nagy
on 2008/04/04
To version < 5.2 >
edited by Sergiu Dumitriu
on 2008/05/07
>
Change comment: Fix minor typo

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.hel
1 +XWiki.Sergiu
Content
... ... @@ -31,16 +31,20 @@
31 31  * Tell XWiki to use MSSQL. To do this, edit the ~~WEB&#45;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.

Get Connected