Database drivers changes

New and desupported database drivers.

New database server versions supported in Genero 4.01:

Starting with FGL 4.01.03:
  • Microsoft™ SQL Server 2022
  • PostgreSQL 15
Starting with FGL 4.01.06:
  • PostgreSQL 16
  • Oracle® MySQL 8.2 (with new ODI driver dbmmys_8_2)
    Note:

    The MySQL 8.2 version is an Innovation Release (IR) compared to 8.0 Long-Term Support release (LTS). In a next Genero BDL release, the dbmmys_8_2 driver may be replaced by another MySQL IR 8.x version, and when the next MySQL LTS version is released, the latest driver may be replaced by the driver corresponding to the client library version of the most recent MySQL LTS release.

New database clients supported in Genero 4.01:

  • Microsoft ODBC 18 for SQL Server (new ODI driver dbmsnc_18):

    In this version, the generic dbmsnc driver name is an alias for dbmsnc_18. If you don't plan to install Microsoft ODBC 18 and keep using ODBC 17, you must use the dbmsnc_17 ODI driver for Microsoft ODBC 17 (libmsodbcsql-17.so).

    By default, Microsoft ODBC 18 for SQL Server enables connection encryption, that can lead to the following ODBC error when TLS/SSL certificates are not properly configured:
    [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1416F086:SSL routines:
tls_process_server_certificate:certificate verify failed:self signed certificate]
    To disable encryption on Linux platforms, set the following ODBC option in the data source definition file:
    Encrypt = No
    On Microsoft Windows®, set "Connection Encryption" to "Optional" in the 4th panel of the ODBC data source configuration application.
  • Oracle MySQL 8.2 client (libmysqlclient.so.22) with new ODI driver dbmmys_8_2.

    In this version, the generic dbmmys driver name is an alias for dbmmys_8_2. If you don't plan to install MySQL 8.2 and keep using MySQL 8.0, you must use the dbmmys_8_0 ODI driver for MySQL 8.0 client lib (libmysqlclient.so.21).

For more details, see Database driver specification (driver).

Desupported databases server versions in Genero 4.01:

Desupported database server versions:

  • Oracle Database 12.x (dbmora_12 ODI driver is no longer provided)
  • Generic ODBC ODI driver (dbmodc_3)

Changes in earlier versions

Make sure to check the upgrade notes of earlier versions, to not miss changes introduced in maintenance releases. For more details, see Database drivers changes in BDL 4.00.

Notable changes introduced in maintenance releases:
  • No particular change to consider.