Introduction / FirstSpirit Server configuration / Database connection / Data source configuration / Obligatory parameters

Description of the obligatory parameters

Table of contents

• .jdbc.DRIVER

• .jdbc.URL

• .jdbc.USER

• .jdbc.PASSWORD

• .jdbc.layerclass

<database>.jdbc.DRIVER

Contains the complete class name of the used JDBC driver which is obligatory for defining the content database. Ensure that the specified class can also be loaded by the FirstSpirit Server. To achieve this, the JAR file, which contains the JDBC driver, has to be stored in the FirstSpirit Server directory shared/lib-isolated. Each change in this directory demands a server restart. The integration of JDBC driver files as FirstSpirit module is recommended.

content1.jdbc.DRIVER=com.mysql.jdbc.Driver

<database>.jdbc.URL

Contains the specification of the JDBC URL to a database server and a database available therein, for example:

content1.jdbc.URL=jdbc:mysql://myServer:3306/mydb

In this example a MySQL database “mydb” on the database server “myServer” is addressed. The structure of the JDBC connection URL varies from database to database and has to be taken from the respective database documentation (see Examples for linking different database systems).

<database>.jdbc.USER

Valid login name of a database user. The FirstSpirit Server uses this account to establish a connection to the database during runtime.

content1.jdbc.USER=db2admin

<database>.jdbc.PASSWORD

Valid password for the login under <database>.jdbc.USER.

content1.jdbc.PASSWORD=admin

<database>.jdbc.layerclass

The class which implements the database layer for this special database system is specified via parameter layerclass, for example:

content1.jdbc.layerclass=de.espirit.or.impl.mysql.MySQLLayer

The parameter layerclass may not be empty as otherwise errors occur in the configuration of the database link (see Databases).

The following layer classes are included in the FirstSpirit standard scope of delivery:

de.espirit.or.impl.db2.DB2Layer
de.espirit.or.impl.derby.DerbyLayer
de.espirit.or.impl.mssql.MSSQLLayer
de.espirit.or.impl.mysql.MySQLLayer
de.espirit.or.impl.oracle.OracleLayer (for Oracle Database up to 12c)
de.espirit.or.impl.oracle.Oracle19cLayer
de.espirit.or.impl.postgres.PostgreSQLLayer

The Derby DBMS contained in FirstSpirit is not suitable for productive use and should therefore be used for tests only.

Print version | Page start