Database properties
The file database.properties stores several settings related to the database, such as the login credentials.
You should edit database related settings via the user interface. Please note that some of these properties are stored encrypted.
| Property | Default value | Encrypted | Explanation |
|---|---|---|---|
| db.connection.login.password | - | yes | Password for accessing the database. |
| db.connection.login.username | - | yes | User name for accessing the database. |
| db.connection.jdbcurl | - | no | The JDBC connection URL to the database. |
| db.connection.connnections.max | 50 | no | The maximum size that the connection pool is allowed to reach, including both idle and in-use connections. |
| db.connection.connnections.timeout | 200 | no | The maximum amount of time in seconds that a connection is allowed to sit idle in the connection pool. A value of 0 means that idle connections are never removed from the pool. Otherwise, the minimum allowed value is 10. |
| db.connection.connnections.unreturned.timeout | 0 | no | The maximum lifetime in milliseconds of a connection in the connection pool. A value of 0 indicates no maximum lifetime. However, the db.connection.connnections.timeout setting still applies. |
| db.connection.connnections.leakdetection_threshold | 0 | no | The amount of time in milliseconds that a connection can be out of the connection pool before a message is logged indicating a possible connection leak. A value of 0 means that leak detection is disabled. Lowest acceptable value for enabling leak detection is 2000. |
| db.connection.dbms.shortname | - | no | The type of database management system. Possible values are mysql (MySQL), oracle (Oracle), postgresql (PostgreSQL), sqlserver (SQLServer), and h2db (H2 Server). |