...
| Info |
|---|
This article includes updates for Nexus Timestamp Server 2.3.0. |
This article describes the settings for storing information for Nexus Timestamp Server in a database. This is only done if audit is required or for other reason, for example, to keep track of amount of requests.
The configuration parameters are located in the file timestamp.properties and they apply to all services that do not have defined their own database connection.
Prerequisites
...
...
Consider these prerequisites:
...
Add database storage of timestamps to the filter chains, since this is not added to the filter chains of the sample configuration. This is necessary to enable database storage. Read more under heading “timestamp.StorageFilter” in Description of filters in Nexus Timestamp Server.
...
Set up the database schemas beforehand for the external databases. The tables will be created automatically when the server receives requests.
...
Step-by-step instructions
...
Set database parameters
Set these database parameters in timestamp.properties:
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Examples
...
| title | Derby (embedded mode) |
|---|
| Code Block | ||
|---|---|---|
| ||
[shared]
# Derby (embedded mode) settings
storage.database.jdbcDriver=org.apache.derby.jdbc.EmbeddedDriver
storage.database.jdbcUrl=jdbc:derby:var/${Service};create=false
storage.database.jdbcUser=app |
...
MySQL
| Code Block |
|---|
...
[shared]
# MySQL settings
storage.database.jdbcDriver=com.mysql.jdbc.Driver
storage.database.jdbcUrl=jdbc:mysql://localhost/<database_name>
storage.database.jdbcUser=root
storage.database.jdbcPassword=password |
...
Microsoft SQL
| Code Block |
|---|
...
...
[shared]
# MSSQL settings
storage.database.jdbcDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
storage.database.jdbcUrl=jdbc:sqlserver://localhost:1433;databaseName=<database_name>
storage.database.jdbcUser=root
storage.database.jdbcPassword=password |
...
PostgreSQL
| Code Block |
|---|
...
[shared]
# PostgreSQL settings
storage.database.jdbcDriver=org.postgresql.Driver
storage.database.jdbcUrl=jdbc:postgresql://localhost:5432/
<database_name>
storage.database.jdbcUser=postgres
storage.database.jdbcPassword=postgres |
...
Related information
...