Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-142

Mapping Driver for Oracle does not know what to do with blobs, throws DBAL Exception for types "blob" and "long raw".

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.1
    • Fix Version/s: 2.2
    • Component/s: Platforms
    • Labels:
      None
    • Environment:
      CentOS 5.0, PHP 5.3.6, Oracle 11g EE, Symfony 2.0, Doctrine 2.1

      Description

      When attempting to reverse engineer an existing Oracle 11g database an exception is thrown (by DBAL) complaining that the type blob is unknown. I believe this is coming from AbstractPlatform.php. I attempted to solve the problem by add a type mapping for blob in PDOOracle\Driver.php (blob => text) and it now complains that "long raw" is unknown.

      [Doctrine\DBAL\DBALException]
      Unknown database type long raw requested, Doctrine\DBAL\Platforms\OraclePlatform may not support it.

        Issue Links

          Activity

          Ed Anderson created issue -
          Hide
          Benjamin Eberlei added a comment -

          Implemented blob support

          Show
          Benjamin Eberlei added a comment - Implemented blob support
          Benjamin Eberlei made changes -
          Field Original Value New Value
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 2.2 [ 10142 ]
          Resolution Fixed [ 1 ]
          Benjamin Eberlei made changes -
          Link This issue duplicates DBAL-6 [ DBAL-6 ]
          Hide
          Sergio Andres Diaz Oviedo added a comment -

          Sorry. i am new in it, i am developing and app in symfony 2, and when i try to import the entities from the database i get the error:

          [Doctrine\DBAL\DBALException]
          Unknown database type blob requested, Doctrine\DBAL\Platform may not support it.

          i am using oracle 11g, i did try (blob => 'text') in oraclepatform.php but is later send me more errors, i cant understand, i want know how can i fix it i anyway to at least can import the entities, thank you

          Show
          Sergio Andres Diaz Oviedo added a comment - Sorry. i am new in it, i am developing and app in symfony 2, and when i try to import the entities from the database i get the error: [Doctrine\DBAL\DBALException] Unknown database type blob requested, Doctrine\DBAL\Platform may not support it. i am using oracle 11g, i did try (blob => 'text') in oraclepatform.php but is later send me more errors, i cant understand, i want know how can i fix it i anyway to at least can import the entities, thank you
          Benjamin Eberlei made changes -
          Workflow jira [ 12893 ] jira-feedback2 [ 17737 ]
          Benjamin Eberlei made changes -
          Workflow jira-feedback2 [ 17737 ] jira-feedback3 [ 20092 ]

          This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

          • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DBAL-142, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

            People

            • Assignee:
              Benjamin Eberlei
              Reporter:
              Ed Anderson
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: