Doctrine DBAL

OraclePlatform getSequenceNextValSQL not handling case/quoting properly on 11g

Details

  • Type: Bug Bug
  • Status: In Progress In Progress
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 2.3.2
  • Fix Version/s: 2.4
  • Component/s: Platforms
  • Security Level: All
  • Labels:
  • Environment:
    PHP version 5.4.11
    Oracle 11g Instant Client version 11.2.0.3.0
    Oracle Database 11g Enterprise Edition version 11.2.0.3.0 (x64)
    OCI8 DBAL driver

Description

I have an installer script that uses ORM SchemaTool to create the entities in the DB and then populates with basic data using basic EM->persist calls via ORM.

Sequence objects are created, and when using the 10g Instant Client everything worked correctly, however, upon upgrade to latest version of the Instant Client Oracle seems to be expecting consistent case for these schema objects. It appears as if they are being created with a quoted name as they are created in lowercase. OraclePlatform::getSequenceNextValSQL, however, generates "SELECT entity_id_seq.nextval FROM DUAL" and this fails with error "General error: 2289 OCIStmtExecute: ORA-02289: sequence does not exist".

Executing "SELECT "entity_id_seq".nextval FROM DUAL" directly on the DB returns the correct value.

I believe this may also impact the code in http://www.doctrine-project.org/jira/browse/DBAL-278

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Max Milaney added a comment -

Hi there,
Wondering if there is any update on this? I'm having to use a workaround in my applications.
Cheers,
Max

Show
Max Milaney added a comment - Hi there, Wondering if there is any update on this? I'm having to use a workaround in my applications. Cheers, Max
Max Milaney made changes -
Field Original Value New Value
Description I have an installer script that uses ORM SchemaTool to create the entities in the DB and then populates with basic data using basic EM->persist calls via ORM.

Sequence objects are created, and when using the 10g Instant Client everything worked correctly, however, upon upgrade to latest version of the Instant Client Oracle seems to be expecting consistent case for these schema objects. It appears as if they are being created with a quoted name as they are created in lowercase. OraclePlatform::getSequenceNextValSQL, however, generates "SELECT entity_id_seq.nextval FROM DUAL" and this fails with error "General error: 2289 OCIStmtExecute: ORA-02289: sequence does not exist".

Executing "SELECT "entity_id_seq.nextval" FROM DUAL" directly on the DB returns the correct value.

I believe this may also impact the code in http://www.doctrine-project.org/jira/browse/DBAL-278 		I have an installer script that uses ORM SchemaTool to create the entities in the DB and then populates with basic data using basic EM->persist calls via ORM.

Sequence objects are created, and when using the 10g Instant Client everything worked correctly, however, upon upgrade to latest version of the Instant Client Oracle seems to be expecting consistent case for these schema objects. It appears as if they are being created with a quoted name as they are created in lowercase. OraclePlatform::getSequenceNextValSQL, however, generates "SELECT entity_id_seq.nextval FROM DUAL" and this fails with error "General error: 2289 OCIStmtExecute: ORA-02289: sequence does not exist".

Executing "SELECT "entity_id_seq".nextval FROM DUAL" directly on the DB returns the correct value.

I believe this may also impact the code in http://www.doctrine-project.org/jira/browse/DBAL-278
Max Milaney made changes -
Status Open [ 1 ] Awaiting Feedback [ 10000 ]
Max Milaney made changes -
Status Awaiting Feedback [ 10000 ] In Progress [ 3 ]
Max Milaney made changes -
Status In Progress [ 3 ] Awaiting Feedback [ 10000 ]
Hide
Permalink
Benjamin Eberlei added a comment -

Can you maybe show an entity definition with its sequence mapping?

Show
Benjamin Eberlei added a comment - Can you maybe show an entity definition with its sequence mapping?
Hide
Permalink
Max Milaney added a comment -

Here you are mate. Please see attachment.

Show
Max Milaney added a comment - Here you are mate. Please see attachment.
Max Milaney made changes -
Attachment example.php [ 11512 ]
Max Milaney made changes -
Status Awaiting Feedback [ 10000 ] In Progress [ 3 ]
Max Milaney made changes -
Status In Progress [ 3 ] Awaiting Feedback [ 10000 ]
Max Milaney made changes -
Status Awaiting Feedback [ 10000 ] In Progress [ 3 ]
Benjamin Eberlei made changes -
Fix Version/s 2.4 [ 10320 ]
Fix Version/s 2.3.3 [ 10328 ]
Hide
Permalink
Benjamin Eberlei added a comment -

I cant seem to find the problem, in DBAL "lib/Doctrine/DBAL/Platforms/OraclePlatform.php" on line 171, the sequence statement is created with $sequence->getQuotedName($platform), but this only works if quoting is requrested for the sequence.

How do you actually create the sequence? Your entity doesnt have @GeneratedValue.

What does the create schema command say with "--dump-sql" flag? Is the SQL quoted?

Show
Benjamin Eberlei added a comment - I cant seem to find the problem, in DBAL "lib/Doctrine/DBAL/Platforms/OraclePlatform.php" on line 171, the sequence statement is created with $sequence->getQuotedName($platform), but this only works if quoting is requrested for the sequence. How do you actually create the sequence? Your entity doesnt have @GeneratedValue. What does the create schema command say with "--dump-sql" flag? Is the SQL quoted?
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-444, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Max Milaney
Vote (0)
Watch (2)

Dates

  • Created:
    Updated: