Page History
...
For a number of DBMS the JDBC Drivers are included with JS7. However, due to restrictions for bundling of JDBC Drivers with Open Source software for some DBMS users have to individually download the JDBC Driver from the vendor.'s web site:
| 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 | 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 The MariaDB® JDBC Driver can be used for MySQL® |
| Oracle® | 12c, 18c, 19c |
| 19.7 | ojdbc8.jar |
| FUTC 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® | 2012, 2014, 2017, 2019 | 9.x | mssql-jdbc-9.x.jre8.jarmssql-jdbc-9.x.jre11.jarmssql-jdbc-9.x.jre15.jar | Proprietary License | no | DBMS and JDBC Drivers are not Open Source |
Hibernate Configuration Files
- Hibernate configuration files are used from an XML format. During installation the respective hibernate configuration file is created and can later on be manually updated.
- By default the Hikari Connection Pool is used.
- The Hikari setting for the
maximumPoolSizeshould be included with a Hibernate configuration file as this determines the number of open database connections. Adjust this setting to the number of connections required for sharing between parallel users of JOC Cockpit. As a rule of thumb 10 connections should work for approx .30 parallel users. Any additional settings for Hikari can be added to a Hibernate configuration file.
Hibernate Configuration for H2®
...
Overview
Content Tools