Versions Compared

Old Version 1

changes.mady.by.user Ann Base

Saved on

compared with

New Version 2

changes.mady.by.user Ann Base

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article describes the settings for storing information for 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

Expand
titlePrerequisites

Consider these prerequisites:

  • You shall 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.
  • The Derby database is embedded in Nexus Timestamp server.
    • If you use JDBC drivers other than Derby, that is, if you use an external database, place the .jar file containing the JDBC driver in the lib folder of the installation.
    • If you use an external database, set up the database schemas beforehand. The tables will be created automatically when the server receives requests.

Step-by-step instructions

Expand
titleSet database parameters
  1. Set these database parameters in timestamp.properties:
    Insert excerpt
    Description of filters in Nexus Timestamp Server
    Description of filters in Nexus Timestamp Server
    nopaneltrue

Examples

Expand
titleDerby (embedded mode)


Code Block
titleExample: Derby (embedded mode)
[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



Expand
titleMySQL


Code Block
titleExample: MySQL
[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



Expand
titleMicrosoft SQL


Code Block
titleExample: Microsoft SQL
[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



Expand
titlePostgreSQL


Code Block
titleExample: PostgreSQL
[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