Database drivers changes

New and desupported database drivers.

New database server versions supported in Genero 3.20:

Support for new database server releases, with existing ODI drivers:
  • PostgreSQL 11 is supported with the existing dbmpgs_9 driver (linked to libpq.so.5).
Support for new database server and client releases with new ODI drivers:
  • Oracle® 18c database driver (dbmora_18/dbmora) for Oracle 18c server.
    Important: The generic driver name dbmora maps now to dbmora_18. If your application is using Oracle 12c or Oracle 11g, specify respectively dbmora_12 or dbmora_11 drivers in the connection parameters.
ODI driver replacements:
  • Oracle MySQL 5.6 driver (dbmmys_5_6) has to be used in place of the desupported dbmmys_5_5 driver.

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

Databases / ODI drivers desupported in Genero 3.20:

Database drivers for old database client versions are removed in accordance with DB vendor de-support plans:

  • Microsoft™ SQL Server 2008 / SQL Natice Client V10 (dbmsnc_10)
  • Oracle MySQL 5.5.x (dbmmys_5_5) - for MySQL 5.6, use the new driver dbmmys_5_6. It is still possible to connect to a MySQL 5.5 server by using the dbmmys_5_6 driver with the MySQL 5.6 client. However, DATETIME types with FRACTION(N) cannot be supported with MySQL 5.5 (and MySQL 5.6 versions before 5.6.4): See DATE and DATETIME data types.
    Note: The dbmmys_5_5 driver could also be used to connect to MariadDB 10.0 and 10.1. These MariadDB versions are no longer supported: Use MariadDB 10.2+ with dbmmdb_10_2.

Minimal required FreeTDS version is 1.00.104

See FreeTDS 1.00 for SQL Server for more details.

FGLSQLDEBUG levels and output

Starting with version 3.20, the FGLSQLDEBUG and fgl_sqldebug() maximum debug level is 3. If you set the SQL debug level to a higher value, it will be equivalent to level 3.

When FGLSQLDEBUG is enabled, the OPTIONS SQL INTERRUPT ON/OFF is traced.