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, 21c | 21.8 | ojdbc8-19.19.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>.jre15jre17.jar | Proprietary License | no | DBMS and JDBC Drivers are not Open Source |
In most situations it is technically possible to operate JS7 with newer versions of a DBMS or JDBC Driver if the version is actively supported by the DBMS vendor. Users frequently ask if JS7 is compatible with newer versions of a DBMS or JDBC Driver. It's the wrong question and your DBA should know the answer. Consider the following example for Oracle® that similarly applies to other DBMSs:
...
- The example uses the MySQL® database server running with hostname
mysqlsrv
and port3306
. - The example applies to use of a MySQL® JDBC Driver. Such drivers do not ship with JS7 as they are not available from open source compatible license. Users can download such drivers from the vendor's site.
- For use with MySQL® databases the MariaDB® JDBC Driver can be used that ships with JS7. The class name for this driver is
org.mariadb.jdbc.Driver,
see example for MariaDB®.
Hibernate Configuration for Oracle®
...
JOC Cockpit Component | Min. Connections | Max. Connections | Configurable | Comment |
---|---|---|---|---|
JS7 - REST Web Service API | 10 | unbounded (default: 10) | yes | Recommendation: number of simultaneous users / 3. |
1 | 1 | no | ||
JS7 - Cleanup Service | 5 | unbounded (default: 5) | yes | Configuration via JS7 - Settings |
JS7 - History Service | 1 | number of connected Controller Instances | no | Any Controllers connected to a JOC Cockpit Instance are counted. |
JS7 - Monitor Service | 3 | 3 | no | 2 connections for JS7 - Monitoring. 1 connection for JS7 - NotificationNotifications. |
Total: 20 |
Hibernate allows one out of a number of Connection Pool implementations to be chosen.
...