MSSQL Installation
Version 4.1 by Helmut Nagy on 2008/04/04
Microsoft SQL Server Installation
Create the xwiki user and database
- Use the Enterprise Manager to create a database named 'XWiki' and a user named 'xwiki'.
- Set xwiki's password to 'xwiki'.
- Give database ownership of the database XWiki to the user xwiki.
Install the JDBC driver
- Download the jtds jdbc driver 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
)\
- Alternatively, you can use the JDBC driver provided by Microsoft, however this has not been tested.
When compiling from source
- Add to xwiki-core
src
main
resources
and recompile everything.
When using a downloaded .war
- Save the file 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.
XWiki configuration
- 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):
<property name="connection.url">jdbc:jtds:sqlserver://\<server-url\>:1433/XWiki;tds=8.0;lastupdatecount=true</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwiki</property>
<property name="connection.driver_class ">net.sourceforge.jtds.jdbc.Driver</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<mapping resource="xwiki.mssql.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwiki</property>
<property name="connection.driver_class ">net.sourceforge.jtds.jdbc.Driver</property>
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>
<mapping resource="xwiki.mssql.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
Fix search function
If you try to do a search, via 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 WebSearch. This is however not very practical, because it makes search case-sensitive.
Alternatively, you may want to use the Lucene search instead of the default search.
