Versions Compared

Key

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

...

In a first step users have to create a database schema and account for JS7. The database schema has to support the Unicode character set.

...

languagebash
titleExample how to add a Database Schema and Account for MySQL
linenumberstrue

...

 

In a second step the database connection has to be specified from a Hibernate configuration file:

  • Location in the container: /var/sos-berlin.com/js7/joc/resources/joc/hibernate.cfg.xml
  • Consider accessing the configuration file from the volume that is mounted when running the container, for example, from a local folder /home/sos/js7/js7-joc-primary/config.
  • Information about modification of the hibernate.cfg.xml file for your DBMS can be found in the JS7 - Database article.

Create Database Objects

...

During installation JOC Cockpit can be configured

  • not to create database objects by the installer,
  • to create database objects by the installer,
  • on start-up.to check if database objects exist and otherwise

...

  • to create them on-the-fly.

However, users Users can force creation of database objects by executing the following script inside the container::

Code Block
languagebash
titleCreate Database Objects
linenumberstrue
# create database objects
 docker exec -ti js7-joc-primary /bin/sh -c /opt/sos-berlin.com/js7/joc/install/joc_install_tables.sh

...