Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-543

Oracle DSN pooled option in wrong place of TNS connect descriptor and missing in Oracle PDO driver

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.5, 2.4.2
    • Component/s: Drivers
    • Security Level: All
    • Labels:
      None
    • Environment:
      oci8 driver: wrong TNS connect descriptor
      pdo_oci driver: missing pooled directive

      Description

      The DBAL OCI8 driver places the "(SERVER=POOLED)" directive in the wrong place. To illustrate, when the "pooled" option is given to the driver options the following TNS connect descriptor is build:

      (
        DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521)))
        (
          CONNECT_DATA=(SID=sales)
        )
        (
          SERVER=POOLED
        )
      )
      

      However the correct TNS connect descriptor is:

      (
        DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521)))
        (
          CONNECT_DATA=(SID=sales)(SERVER=POOLED)
        )
      )
      

      Also, the pooled option is missing in the PDO Oracle driver.

      See this page for more info: http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc004.htm

        Activity

        Martijn Evers created issue -
        Benjamin Eberlei made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 2.5 [ 10523 ]
        Resolution Fixed [ 1 ]
        Benjamin Eberlei made changes -
        Fix Version/s 2.4.2 [ 10620 ]

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Martijn Evers
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: