 | Warning The following describes changes in the low-level Nuxeo configuration files. Starting with Nuxeo 5.3.2, a template system is used to change Nuxeo configuration, and by default the files described below will be overwritten by those from the templates at each startup. See the documentation on [How to configure Nuxeo EP] for more about templates. |
To use Microsoft SQL Server 2005/2008 with Nuxeo and VCS (Visible Content Store) you need the following.
JDBC Driver
The Open Source JTDS driver must be used (the official Microsoft JDBC driver has problems). You can download it from: http://repo2.maven.org/maven2/net/sourceforge/jtds/jtds/1.2.2/jtds-1.2.2.jar.
This JAR must then be placed in $JBOSS/server/default/lib/ or $TOMCAT/lib/.
JBoss Configuration
The configuration files refer to files below the directory $JBOSS/server/default/deploy/nuxeo.ear/.
config/default-repository-config.xml
In the following file, you should change the fulltext catalog and analyzer to suit your needs. The catalog can be left to "nuxeo". The analyzer should be changed according to the default language for your indexes (it can be overridden per-index). See section about LANGUAGE in the SQL Server documentation about CONTAINSTABLE.
datasources/default-repository-ds.xml
You should check that the rar-name references the correct .rar file in the system/ directory of the EAR (check the version number).
datasources/unified-nuxeo-ds.xml
For a non-transactional configuration:
For a transactional configuration:
config/sql.properties
Tomcat configuration
To use Ms SQL Server with the Tomcat distribution of Nuxeo, you need to change some files:
The resources should looks like:
for each resource.
Also change:
The configuration should looks like:
And finally:
- nxserver/config/commentService-config-bundle.xml
- nxserver/config/nxrelations-default-jena-bundle.xml
- nxserver/config/sql.properties
where you should change "databaseType" property from "Derby" to "MsSQL" and "databaseTransactionEnabled" property set to "false".