To connect Nuxeo to your database, you need to tell Nuxeo which database template to use and provide the database connection information.
- In the Admin Center, click on the Setup tab of system information section.
- In the Main information section, select the target database in the drop down menu.
A new Database Information section is displayed on the page.
- Fill in the database connection information.
- Click on the Save button displayed below the Email information section.
- Restart your server.
The first time you start your Nuxeo server, a wizard is displayed to help you setup your application. One of the steps is about the database: select the database you want to use in the drop down list and provide the connection information to the database.
By default, the "default" template is enabled on your Nuxeo server (see the Database templates section for more information on this template). You need to edit it to change the template to be used.
- Open your
nuxeo.conffile with a text editor.
Wordpad is fine, Notepad++ and SciTE are good text editors, there are a lot of other text editors.
- If needed, uncomment or edit the
nuxeo.templatesparameter and replace
defaultwith the wanted database template's name (see Database Templates section).
- Uncomment or edit the parameters below and provide their values:
- Save your modifications.
- Restart the server.
These are the minimum required parameters to enable the Nuxeo server to communicate with the database. For a production or load testing environment, you may need to provide the other commented parameters.
The default available database templates are:
- common: common template used by other templates;
- default: default Nuxeo configuration template for test purpose;
- https: (not recommended) template to make the server listen to port 443 (HTTPS);
- postgresql: PostgreSQL configuration template;
- mssql: MS SQL Server configuration template;
- mysql: MySQL configuration template;
- oracle: Oracle configuration template;
- custom: sample custom templates. Of course, this template is empty by default. One should copy it outside
$NUXEO_HOMEand adapt to his needs.
The most commonly used templates are described below. For more information read the page Configuration Templates.
This is the default Nuxeo configuration using an embedded H2 database. It is designed for development or test purpose. Do not use this in production or for performance evaluations.
- Repository backend: H2
- Services backend: H2
This is the recommended configuration for production, based on PostgreSQL.
- Repository backend: PostgreSQL XA
- Services backend: PostgreSQL XA
The PostgreSQL driver is included in the Nuxeo applications by default. However, if needed you can download a more recent version from http://jdbc.postgresql.org/download.html#current.
The JAR (for instance
postgresql-9.2-1002.jdbc4.jar) is located in
You can use a later driver with an earlier database version, for instance the 9.4 driver still works with PostgreSQL 9.2 or 9.3.
See the page PostgreSQL for more information on the database configuration.
- Repository backend: Oracle XA
- Services backend: Oracle XA
The driver is not included in Nuxeo applications for legal reasons. To install it:
- Download the appropriate JDBC driver from http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html.
- The JAR (ojdbc6.jar) must be placed in
See the page Oracle for more information on the database configuration.
- Repository backend: Microsoft SQL Server XA
- Services backend: Microsoft SQL Server XA
The Open Source jTDS driver should be used and is already shipped with Nuxeo (the official Microsoft JDBC driver has problems).
The JAR (for instance
jtds-1.3.0.jar) is located in
See the page Microsoft SQL Server for more information on the database configuration.
- Repository backend: MySQL XA
- Services backend: MySQL XA
The JDBC driver (dowloadable from http://www.mysql.com/downloads/connector/j/) is included in Nuxeo applications and is located in