Hide last authors
Tobias2Roth2 1.2 1 1 Microsoft SQL Server Installation
2
3 #info("This has been tested only on MSSQL 2000. MSSQL 2005 will probably not work due to the depreciation of the text types.")
4
Vincent Massol 2.2 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]")
Tobias2Roth2 1.5 6
Tobias2Roth2 1.2 7 1.1 Create the xwiki user and database
Tobias2Roth2 1.3 8
Tobias2Roth2 1.2 9 * Use the Enterprise Manager to create a database named 'XWiki' and a user named 'xwiki'.
10 * Set xwiki's password to 'xwiki'.
11 * Give database ownership of the database XWiki to the user xwiki.
12
Tobias2Roth2 1.3 13 1.1 Install the JDBC driver
Tobias2Roth2 1.2 14
steel 3.1 15 * Download the [jtds jdbc driver>http://jtds.sourceforge.net/] and install the jar file into your servers lib directory (for JBoss this could be ~~server\\\default\\\lib\\\~~, for Tomcat this might be ~~common\\\lib\\\~~)\\
Vincent Massol 3.2 16
17 #info("The connection was successfully tested with version 1.2.1 of the driver and version 1.3.1 of XWiki. Some problems occurred when using drivers > 1.2.1 so it might be better to use the old one. ")
18
Tobias2Roth2 1.3 19 * Alternatively, you can use the [JDBC driver provided by Microsoft>http://www.microsoft.com/downloads/details.aspx?familyid=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en], however this has not been tested.
20
Tobias2Roth2 1.2 21 1.1 When compiling from source
22
Tobias2Roth2 1.7 23 * Add {attach:xwiki.mssql.hbm.sql|xwiki.mssql.hbm.xml} to ~~xwiki-core\\\src\\\main\\\resources\\\~~ and recompile everything.
Tobias2Roth2 1.5 24
Tobias2Roth2 1.7 25 1.1 When using a downloaded .war
Tobias2Roth2 1.5 26
Tobias2Roth2 1.7 27 * Save the file {attach:xwiki.mssql.hbm.sql|xwiki.mssql.hbm.xml} as ~~WEB-INF/classes/xwiki.mssql.hbm.xml~~ (creating the ~~classes~~ directory if needed). This directory can be found inside the XWiki war, which is either a directory or a zip file.
Tobias2Roth2 1.2 28
29 1.1 XWiki configuration
30
Tobias2Roth2 1.5 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):
Tobias2Roth2 1.3 32
Vincent Massol 2.2 33 {code:none}
Helmut Nagy 5.1 34 <property name="connection.url">jdbc:jtds:sqlserver://<server-url>:1433/XWiki;tds=8.0;lastupdatecount=true</property>
Tobias2Roth2 1.3 35 <property name="connection.username">xwiki</property>
36 <property name="connection.password">xwiki</property>
Sergiu Dumitriu 5.2 37 <property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
Tobias2Roth2 1.3 38 <property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
Helmut Nagy 5.1 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>
Tobias2Roth2 1.3 42 <mapping resource="xwiki.mssql.hbm.xml"/>
43 <mapping resource="feeds.hbm.xml"/>
Tobias2Roth2 1.2 44
45 {code}
46
Helmut Nagy 5.1 47
Tobias2Roth2 1.2 48 1.1 Fix search function
49
Tobias2Roth2 1.3 50 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.
Tobias2Roth2 1.2 51
Vincent Massol 3.2 52 Alternatively, you may want to use the [Lucene search>code:Applications.SearchApplication] instead of the default search.

Get Connected