tracker issue : CF-4203461

select a category, or use search below
(searches all categories and all time range)
Title:

CfScript ORM mapping annotation for param/sequence does not work

| View in Tracker

Status/Resolution/Reason: To Track//PRNeedInfo

Reporter/Name(from Bugbase): Graham Bakay / ()

Created: 11/13/2018

Components: ORM Support

Versions: 2018

Failure Type: Crash

Found In Build/Fixed In Build: Docker image 2018.0.1 /

Priority/Frequency: Normal / All users will encounter

Locale/System: ALL / Other

Vote Count: 0

Problem Description:
When mapping a sequence to an ORM-mapped component using CfScript annotations, the value for the sequence name is *ignored* and replaced with "hibernate_sequence".

Steps to Reproduce:
Map a component to an Oracle database using annotations and include for the identity column:
/**
 ...
 * @generator "sequence"
 * @params "{sequence='AUDIT_HISTORY_SEQ'}"
*/

Actual Result:
11/13 20:05:07 [http-nio-8500-exec-10] ERROR ORA-02289: sequence does not exist

Hibernate:
    select
        hibernate_sequence.nextval
    from
        dual
11/13 20:05:28 [http-nio-8500-exec-4] ERROR ORA-02289: sequence does not exist

Expected Result:
Hibernate:
    select
        AUDIT_HISTORY_SEQ.nextval
    from
        dual

Any Workarounds:
Downgrade to v2016.

Attachments:

Comments:

Hi Graham, Please attach an isolated test case to this bug that can help me in reproducing this issue. -Nimit  
Comment by Nimit S.
30206 | February 08, 2019 04:59:03 AM GMT
What is unclear about the bug report? Are you expecting me to create an entire Docker project with an Oracle Database container for you to use? That seems like an enormous amount of effort for what is obviously a simple bug (and being a regression, should never have happened). This regression is not limited to the Docker image, it's present in all CF v2018 combinations.
Comment by Graham B.
30212 | February 08, 2019 04:38:14 PM GMT