tracker issue : CF-4203461

Hi Graham, Please attach an isolated test case to this bug that can help me in reproducing this issue. -Nimit  

Comment by Nimit S.

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.

Can confirm this is happening on not just annotation but property attributes as well. None of the property declaration below works, having the exact error described by OP, seems like Hibernate 5.2 was updated by not fully tested: property name="id" type="Numeric" default="0" ormtype="int" column="COMMENTID" fieldtype="id" notnull="true" unsavedvalue="0" generator="sequence" sequence="COMMENT_SEQ"; property name="id" type="Numeric" default="0" ormtype="int" column="commentId" fieldtype="id" notnull="true" unsavedvalue="0" generator="sequence" params="{'sequence'='COMMENT_SEQ'}"; property name="id" type="Numeric" default="0" ormtype="int" column="commentId" fieldtype="id" notnull="true" unsavedvalue="0" generator="sequence" params="{'sequence-name'='COMMENT_SEQ'}"; Phill Nacelli CTO, AboutWeb, LLC

Vote by Phill N.

Can confirm this is happening on not just annotation but property attributes as well. None of the property declaration below works, having the exact error described by OP, seems like Hibernate 5.2 was updated by not fully tested: property name="id" type="Numeric" default="0" ormtype="int" column="COMMENTID" fieldtype="id" notnull="true" unsavedvalue="0" generator="sequence" sequence="COMMENT_SEQ"; property name="id" type="Numeric" default="0" ormtype="int" column="commentId" fieldtype="id" notnull="true" unsavedvalue="0" generator="sequence" params="{'sequence'='COMMENT_SEQ'}"; property name="id" type="Numeric" default="0" ormtype="int" column="commentId" fieldtype="id" notnull="true" unsavedvalue="0" generator="sequence" params="{'sequence-name'='COMMENT_SEQ'}"; Phill Nacelli CTO, AboutWeb, LLC

Comment by BETH T.

Has there been any further investigation into this issue? We are also seeing ORA-02289: sequence does not exist errors in CF2018. This error only occurs when saving objects using ORM. Investigation so far: 1. The ColdFusion database user definitely has access to these sequences. 2. If we call the sequences directly using cfquery then we get the values expected. For example our onError() function successfully saves the error messages to the database and calls `SELECT AIR_LOG_ID_SEQ.NEXTVAL AS NEXTID FROM DUAL` to get the required ID so we know this works. 3. I created a test.cfm file that selects ALL the sequences we use and outputs them to a display page – this runs as expected without error. 4. The exact same code runs fine on previous versions of ColdFusion. ORM is able to use the Oracle sequences to read and write to the same database. My code is very similar to Phill Nacelli's eg: <cfproperty name="id" hint="Maps to the id of the record." column="area_id" fieldtype="id" generator="sequence" params="{sequence='air_area_id_seq'}" /> Martin Jones Senior Analyst and Developer University of Edinburgh.

Vote by Martin J.

Has there been any further investigation into this issue? We are also seeing ORA-02289: sequence does not exist errors in CF2018. This error only occurs when saving objects using ORM. Investigation so far: 1. The ColdFusion database user definitely has access to these sequences. 2. If we call the sequences directly using cfquery then we get the values expected. For example our onError() function successfully saves the error messages to the database and calls `SELECT AIR_LOG_ID_SEQ.NEXTVAL AS NEXTID FROM DUAL` to get the required ID so we know this works. 3. I created a test.cfm file that selects ALL the sequences we use and outputs them to a display page – this runs as expected without error. 4. The exact same code runs fine on previous versions of ColdFusion. ORM is able to use the Oracle sequences to read and write to the same database. My code is very similar to Phill Nacelli's eg: <cfproperty name="id" hint="Maps to the id of the record." column="area_id" fieldtype="id" generator="sequence" params="{sequence='air_area_id_seq'}" /> Martin Jones Senior Analyst and Developer University of Edinburgh.

Comment by Martin J.

Hi Martin, Are you running the update 5 that was just launched two days ago? Phill Nacelli CTO, AboutWeb, LLC

Comment by Phill N.

Hi Phill, Yes- It was installed today and the issue still persists. Cheers Martin

Comment by Martin J.

Hi Martin, After working with Adobe on documenting and troubleshooting this issue, I received a patch a while back through our customer support channel that resolved the hibernate issue. I reached out to the contact who gave me a patch for this issue to see if it was included in the update 5, but as you mentioned it looks like it was not. Let me check with him if I can make that patch available to you (not sure if there's some client support agreement that we are on that may be a conflict) or ask him to post it here directly (so you're not getting some file from a stranger which I totally understand) or by getting a hold of you directly and let you know. Best, Phill Nacelli CTO, AboutWeb, LLC

Comment by Phill N.

Thanks Phill, The same thing happened to us with a NULL issue and Adobe support shared a hot-fix via Dropbox. I have to say I am worried that they are sharing bug fixes to install on our production servers that they aren't then including in their official patches. Cheers Martin

Comment by Martin J.

Hi Martin, Can you please send an email at cfinstal@adobe.com and mentioned this bug. Thanks, Priyank

Comment by Priyank S.