Last modified by Thomas Mortagne on 2023/10/10

<
From version < 11.1 >
edited by Thomas Mortagne
on 2010/09/03
To version < 12.2 >
edited by Vincent Massol
on 2010/12/10
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.ThomasMortagne
1 +XWiki.VincentMassol
Content
... ... @@ -2,7 +2,7 @@
2 2  
3 3  #info("This has been tested on MSSQL 2000 and MSSQL 2005 (text types are only deprecated in MSSQL 2005, this tutorial won't work when they'll be dropped)")
4 4  
5 -#warning("Case&#45;insensitive search does not work with this database; see below for more info. You may want to use the the [Lucene search>code:Applications.SearchApplication]")
5 +#warning("Case&#45;insensitive search does not work with this database; see below for more info. You may want to use the the [Lucene search>extensions:Extension.Search Application]")
6 6  
7 7  1.1 Create the xwiki user and database
8 8  
... ... @@ -24,18 +24,17 @@
24 24  * 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):
25 25  
26 26  {code:xml}
27 - <property name="connection.url">jdbc:jtds:sqlserver://<server-url>:1433/XWiki;tds=8.0;lastupdatecount=true</property>
28 - <property name="connection.username">xwiki</property>
29 - <property name="connection.password">xwiki</property>
30 - <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
31 - <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
32 - <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
33 - <property name="connection.pool_size">2</property>
34 - <property name="statement_cache.size">2</property>
35 - <mapping resource="xwiki.mssql.hbm.xml"/>
36 - <mapping resource="feeds.hbm.xml"/>
37 - <mapping resource="activitystream.hbm.xml"/>
38 -
27 +<property name="connection.url">jdbc:jtds:sqlserver://<server-url>:1433/XWiki;tds=8.0;lastupdatecount=true</property>
28 +<property name="connection.username">xwiki</property>
29 +<property name="connection.password">xwiki</property>
30 +<property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
31 +<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
32 +<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
33 +<property name="connection.pool_size">2</property>
34 +<property name="statement_cache.size">2</property>
35 +<mapping resource="xwiki.mssql.hbm.xml"/>
36 +<mapping resource="feeds.hbm.xml"/>
37 +<mapping resource="activitystream.hbm.xml"/>
39 39  {code}
40 40  
41 41  
... ... @@ -46,7 +46,7 @@
46 46  
47 47  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.
48 48  
49 -Alternatively, you may want to use the [Lucene search>code:Applications.SearchApplication] instead of the default search.
48 +Alternatively, you may want to use the [Lucene search>extensions:Extension.Search Application] instead of the default search.
50 50  
51 51  1.1.1 Hints for upgrading to MS SQL 2005
52 52  
XWiki.XWikiComments[6]
Date
... ... @@ -1,1 +1,1 @@
1 -2010-09-03 12:49:22.391
1 +2010-09-03 12:49:22.0

Get Connected