...

Configuring the JOC Cockpit

Database Connection

JOC Cockpit requires a database connection, see JS7 - Database.

The database connection can be configured after initial start of JOC Cockpit. 

Check JDBC Driver

JS7 ships with a number of JDBC Drivers  However, a few DMBS products such as Microsoft SQL Server require users to download the JDBC Driver as it cannot be bundled with open source software due to license conflicts. In this situation manually download the JDBC Driver and  store the resulting *.jar file(s) with the locations: TBD

Configure Database Connection

The database connection is specified from a Hibernate configuration file.

• Location
  • for Windows: C:\ProgramData\sos-berlin.com\js7\joc\hibernate.cfg.xml
  • for Linux: /var/sos-berlin.com/js7/joc/resources/joc/hibernate.cfg.xml
• For modification of the Hibernate *.xml file to comply with your DBMS product consider the JS7 - Database article.

Install Database Objects

When the Hibernate configuration file hibernate.cfg.xml is ready then a script should be executed that will create required objects in the database and that will populate database tables.

# create database objects
 docker exec -ti js7-joc-primary /bin/bashsh -c /opt/sos-berlin.com/js7/joc/install/joc_install_tables.sh

Explanations:

• The docker exec is the command that connects to the JOC Cockpit container js7-joc-primary and that executes a script to install database objects required for operation of JOC Cockpit.. 
• Consider 

Initial Operation

Explanations:

...