3 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
4 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
5 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
6 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
7 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
8 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
9 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
10 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
11 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
12 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
13 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
15 * This software consists of voluntary contributions made by many individuals
16 * and is licensed under the MIT license. For more information, see
17 * <http://www.doctrine-project.org>.
20 namespace Doctrine\DBAL\Driver\PDOOracle;
22 use Doctrine\DBAL\Platforms;
27 * WARNING: This driver gives us segfauls in our testsuites on CLOB and other
28 * stuff. PDO Oracle is not maintained by Oracle or anyone in the PHP community,
29 * which leads us to the recommendation to use the "oci8" driver to connect
32 class Driver implements \Doctrine\DBAL\Driver
34 public function connect(array $params, $username = null, $password = null, array $driverOptions = array())
36 return new \Doctrine\DBAL\Driver\PDOConnection(
37 $this->_constructPdoDsn($params),
45 * Constructs the Oracle PDO DSN.
47 * @return string The DSN.
49 private function _constructPdoDsn(array $params)
52 if (isset($params['host']) && $params['host'] != '') {
53 $dsn .= 'dbname=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)' .
54 '(HOST=' . $params['host'] . ')';
56 if (isset($params['port'])) {
57 $dsn .= '(PORT=' . $params['port'] . ')';
59 $dsn .= '(PORT=1521)';
62 if (isset($params['service']) && $params['service'] == true) {
63 $dsn .= '))(CONNECT_DATA=(SERVICE_NAME=' . $params['dbname'] . ')))';
65 $dsn .= '))(CONNECT_DATA=(SID=' . $params['dbname'] . ')))';
68 $dsn .= 'dbname=' . $params['dbname'];
71 if (isset($params['charset'])) {
72 $dsn .= ';charset=' . $params['charset'];
78 public function getDatabasePlatform()
80 return new \Doctrine\DBAL\Platforms\OraclePlatform();
83 public function getSchemaManager(\Doctrine\DBAL\Connection $conn)
85 return new \Doctrine\DBAL\Schema\OracleSchemaManager($conn);
88 public function getName()
93 public function getDatabase(\Doctrine\DBAL\Connection $conn)
95 $params = $conn->getParams();
96 return $params['user'];