Versions Compared

Key

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

Introduction

  • JOC Cockpit makes use of a database to store inventory information, status information and workflow related logs.
  • The database is required for restart capabilities with the JS7 - Cluster Service.
  • The supported DBMS include
    • H2
    • MariaDB
    • MySQL
    • Oracle
    • PostgreSQL
    • SQL Server
  • Basically any versions of a DBMS can be used that are actively supported by their vendor. 
  • Access to the DBMS is provided by Hibernate. This includes to use a JDBC Driver that is specific for the DBMS.

Hibernate Configuration Files

  • Hibernate configuration files are used from an XML format. During installation the respective hibernate configuration file is created and can later on be manually updated.
  • By default the Hikari Connection Pool is used. Settings for Hikari can be added to a Hibernate configuration file.

Hibernate Configuration H2