Uploaded image for project: '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
    • Status: Resolved
    • Priority: 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

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

          Implemented blob support

          Show
          beberlei Benjamin Eberlei added a comment - Implemented blob support
          beberlei Benjamin Eberlei made changes -
          Field Original Value New Value
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 2.2 [ 10142 ]
          Resolution Fixed [ 1 ]
          beberlei Benjamin Eberlei made changes -
          Link This issue duplicates DBAL-6 [ DBAL-6 ]
          Hide
          seandiovza 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
          seandiovza 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
          beberlei Benjamin Eberlei made changes -
          Workflow jira [ 12893 ] jira-feedback2 [ 17737 ]
          beberlei 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={expand=changesets[0:20].revisions[0:29],reviews, query=DBAL-142}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

            People

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

              Dates

              • Created:
                Updated:
                Resolved: