[DBAL-543] Oracle DSN pooled option in wrong place of TNS connect descriptor and missing in Oracle PDO driver Created: 12/Jun/13  Updated: 18/Dec/13  Resolved: 18/Dec/13

Status: Resolved
Project: Doctrine DBAL
Component/s: Drivers
Affects Version/s: None
Fix Version/s: 2.5, 2.4.2
Security Level: All

Type: Bug Priority: Minor
Reporter: Martijn Evers Assignee: Benjamin Eberlei
Resolution: Fixed Votes: 0
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


Generated at Fri Apr 18 00:25:08 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.