Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
-
Objects (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. ThomasMortagne1 +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-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-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-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-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. 3911 +2010-09-03 12:49:22.0