Review main Abandoned

51882[FEATURE] Add Oracle database (oci8) support for the first install tool

Mathieu Bouchard CR 0 V 0 Hard +569 −71 updated 03/01/19, 18:29

Commit message

The patch add the following features:
* Detect that the oci8 driver is loaded
* Implement driver selection and connection details for Oracle (step 2
  of the install tool)
* Implement Oracle versions of Unicode detection (supports only the
  newer AL32UTF8 character set)
* Allow to import the initial data into an Oracle schema

The connection configuration support multiple Oracle features, such as:
* Allow to use persistent connections
* Allow to connect using Net Service Name (from a tnsnames.ora file)
* Allow to connect using Host, Port and Service Name or SID
* Allow to connect using an Easy Connect descriptor

The initial data import has the following changes:
* Use the index renaming of PostgreSQL to make sure that index names
  are globally unique
* Makes sure to use consistent quoting of identifiers (Oracle transform
  every unquoted identifier to UPPERCASE)
* Add a table name mapping used exclusively for Oracle to map long
  table identifiers to something shorter than the 30 characters limit
* Add a fix fix for Oracle non-respect of SQL standard regarding the
  value of an empty string that is considered equal to NULL

This patch doesn't fix every issue of using TYPO3 with an Oracle
database. This only fix the install tool to allow to import some
initial data up to the redirection to the backend login. Some more
work is needed to allow the user to connect to the backend or frontend.

Review

  • Code review CR 0

    Imported before Forger kept the single votes, the next import adds them.

  • Verified V 0

    Imported before Forger kept the single votes, the next import adds them.

Issues 2

Files 7