Doctrine DBAL

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 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

duplicates

Bug - A problem which impairs or prevents the functions of the product. DBAL-6 MySQL BLOB datatypes throw DoctrineException::unknownColumnType() exception

  • Major - Major loss of function.
  • Resolved - A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
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
Permalink
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[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Ed Anderson
Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: