Data source configuration
The database integration of the FirstSpirit Server is configured via the ServerManager (see Databases) or directly via “DATABASES” in configuration file fs-database.conf (see Databases). It is recommended to use the ServerManager (see Databases) to edit the database configuration, since all the changes are automatically written into fs-database.conf and updated on the server. Moreover, the database connection can be tested (see Figure in section Configure JDBC parameters).
The FirstSpirit database connection can be used for various purposes:
- Creation of “internal data sources”.
- Integration of external databases (“external data sources”).
Prerequisites for using data sources in FirstSpirit:
- Database configuration via the ServerManager (recommended) or directly via the file firstspirit5/conf/fs-database.conf
It is possible to define as many data sources as desired for a FirstSpirit Server. The data sources can be individually allocated to the projects via the administrator user interface or selected during project import.
The following applies for direct configuration via the file fs-database.conf:
- Numerous databases can be listed one after another when separated by commas.
- The names of the external data sources can be freely chosen; nevertheless, the following conventions have to be adhered to.
Permitted characters: A-Z, a-z, 0-9, _, -
Example:
DATABASES=content1, content2, extern1, extern2
The following parameters have to be additionally defined in the configuration (schema) for each database element specified in “DATABASES”:
<database>.jdbc.DRIVER=<JDBC-Driver-Class>
<database>.jdbc.URL=<JDBC-Connection-url>
<database>.jdbc.SCHEMA=<dbName>
<database>.jdbc.USER= <db_login>
<database>.jdbc.PASSWORD=<db_passwort>
<database>.jdbc.layerclass=<FirstSpirit-DB-Layer-Klasse>
Configuration example (for DATABASE=content1):
content1.jdbc.DRIVER=com.mysql.jdbc.Driver
content1.jdbc.URL=jdbc:mysql://localhost:3306/mydb
content1.jdbc.SCHEMA=mydb
content1.jdbc.USER=cms
content1.jdbc.PASSWORD=cms
content1.jdbc.layerclass=de.espirit.or.impl.mysql.MySQLLayer
Description of the obligatory parameters.
The following parameters can be used optionally:
content1.jdbc.SCHEMA=dbName
content1.jdbc.CATALOG=dbCatalogname
content1.jdbc.POOLMIN=10
content1.jdbc.POOLMAX=15
content1.jdbc.POOLCYCLE=120
content1.jdbc.POOLTIMEOUT=240
content1.jdbc.CONNECTIONTIMEOUT=3600
content1.jdbc.CONNECTIONRETRY=3
content1.jdbc.CONNECTIONRETRYCYCLE=500
content1.jdbc.MAXSTRINGLENGTH=4000