Page History
...
- JOC Cockpit makes use of a database to store inventory information, status information and workflow related logs.The The database is required for restart capabilities with the JS7 - Cluster Service.
- JS7 does not include a DBMS, instead, it make use of a DBMS that has been installed separately - with the exception of H2® for which JS7 includes an embedded version of the DBMS for evaluation purposes.
- The supported DBMS products 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 the Hibernate database access layer. This includes to use a JDBC Driver that is specific for the DBMS.
...
For a number of DBMS the JDBC Drivers are included with JS7. However, due to restrictions to bundle for bundling of JDBC Drivers with Open Source software for some DBMS users have to individually download the JDBC Driver from the vendor.
| DBMS Product | DBMS Version | JDBC Driver Version | JDBC Driver File | License | Included with JS7 | Comment |
|---|---|---|---|---|---|---|
| H2® | 1.4.200 | 1.4.200 | h2-1.4.200.jar | MPL 2.0, EPL 1.0 | yes | 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 |
| Oracle® | 12c, 18c, 19c | 12.2.0.1 | ojdbc8.jar | Proprietary License | yes | DBMS and JDBC Drivers are not Open Source |
| PostgreSQL® | 10, 11, 12 | 42.2.19 | postgresql-42.2.19.jar | BSD 2-clause | yes | DBMS and JDBC Drivers are Open Source |
| SQL Server® | 9.x | mssql-jdbc-9.x.jre8.jar mssql-jdbc-9.x.jre11.jar mssql-jdbc-9.x.jre15.jar | Proprietary License | no | DBMS and JDBC Drivers are not Open Source |
Hibernate Configuration Files
...
Overview
Content Tools