Page History
...
DBMS Product | DBMS Version | JDBC Driver Version | JDBC Driver File | JDBC Driver License | Included with JS7 | Comment |
---|---|---|---|---|---|---|
H2® | 1.4.200 | 1.4.200 | h2-1.4.200.jar | MPL 2.0, EPL 1.0 | no | DBMS and JDBC Drivers are Open Source |
MariaDB® | 10 | 2.7.2 | mariadb-java-client-2.7.2.jar | LGPL | yes | DBMS and JDBC Drivers are Open Source |
MySQL® | 5.7, 8.0 | 8.x | mysql-connector-java-8.x.jar | Proprietary License | no | DBMS is Open Source, JDBC Drivers are not Open Source The MariaDB® JDBC Driver can be used for access to MySQL® databases |
Oracle® | 12c, 18c, 19c | 19.7 | ojdbc8-18.3.0.0.jar | FUTC License | yes | DBMS and JDBC Drivers are not Open Source Use |
PostgreSQL® | 10, 11, 12, 13, 14, 15 | 42.4.3 | postgresql-42.4.3.jar | BSD 2-clause | yes | DBMS and JDBC Drivers are Open Source |
SQL Server® | 2016, 2017, 2019 | 9.x, 10.x, 11.x | mssql-jdbc-<version>.jre8.jar mssql-jdbc-<version>.jre11.jar mssql-jdbc-<version>.jre15.jar | Proprietary License | no | DBMS and JDBC Drivers are not Open Source |
...
- 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.
- Unix
- 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.
- download/copy one of the Hibernate configuration files listed below to:
- By default the Hikari Connection Pool is used.
- Consider that XML requires special characters to be used with escape characters, for example a password in the Hibernate configuration file that includes the character
&
is written as&
. This applies to any values of XML elements and attributes in Hibernate configuration files.- Wrong:
<property name="hibernate.connection.password">sec&ret</property>
- Right:
<property name="hibernate.connection.password">sec&ret</property>
- Wrong:
...
/var/sos-berlin.com/js7/joc/resources/joc/lib
- The
/var/sos-berlin.com/js7/joc/resources/joc
directory is typically mounted to a Docker volume when running the container - for details see the JS7 - JOC Cockpit Installation for Docker Containers article. If thelib
sub-directory does not exist then you can create it to store the JDBC Driver (*.jar) file.
...
Overview
Content Tools