Page History

...

• Hibernate configuration files are used in an XML format.
• JS7 - JOC Cockpit Installation On Premises
  • During installation the relevant hibernate configuration file is created and can be manually updated later on.
  • After installation of the JOC Cockpit the hibernate.cfg.xml Hibernate configuration file is available in
    • Unix
      • /var/sos-berlin.com/js7/joc/jetty_base/resources/joc
    • Windows
      • C:\ProgramData\sos-berlin.com\js7\joc\jetty_base\resources\joc
    • A different location for the configuration directory can be specified during installation of the JOC Cockpit.
• JS7 - JOC Cockpit Installation for Docker Containers
  • The JOC Cockpit ships preinstalled from a Docker® image.
  • It is therefore recommended that users:
    • download/copy one of the Hibernate configuration files listed below to:
      • /var/sos-berlin.com/js7/joc/jetty_base/resources/joc
    • adjust changes to reflect their database connection. For use with H2® you can use the below sample without changes.
• By default the Hikari Connection Pool is used.
• Consider that XML requires special characters to be quoted, for example a password in the Hibernate configuration file that includes the character & is quotes as &. This applies to any characters in Hibernate configuration files.
  • Wrong: <property name="hibernate.connection.password">sec&ret</property>
  • Right: <property name="hibernate.connection.password">sec&amp;ret</property>

Hibernate Configuration for Embedded H2®

...

# grant all permissions
GRANT ALL ON js7.* TO 'jobscheduler'@'%';

# alternatively grant individual permissions
GRANT CREATE, CREATE VIEW, DROP, ALTER, EXECUTE, SELECT, UPDATE, INSERT, DELETE on js7.* to 'jobscheduler'@'%';

...