tracker issue : CF-4024159

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

ormClearSession and ormCloseSession causes entityDelete not to work

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Jork Zijlstra / Jork Zijlstra (Jork Zijlstra)

Created: 07/22/2015

Components: ORM Support

Versions: 10.0

Failure Type: Data Corruption

Found In Build/Fixed In Build: Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Linux Ubuntu 10.10

Vote Count: 0

Duplicate ID:	CF-4024153

Problem Description:
calling ormClearSession and ormCloseSession after an entityDelete causes the entity nog to be deleted

Steps to Reproduce:
1) entityLoad an object
2) call entityDelete(loaded object)
3) call ormClearSession / ormCloseSession

4) check database and sess that record still exists / entityLoad object in a new request

Actual Result:
Entity is not deleted from the database

Expected Result:
Entity is delete from the database

Any Workarounds:
- Nope

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	4024159

External Customer Info:
External Company:  
External Customer Name: Jork
External Customer Email:  
External Test Config: My Hardware and Environment details:

Ubuntu 12.04, CF10,0,15,292620

Attachments:

  1. July 24, 2015 00:00:00: 1_still-existing-record.png

Comments:

Hi Jork, It is also working if I call ORMFlush before clearing or closing the session. It looks like ORMFlush is not working at your configuration. Please share your coldfusion server's settings summary as I asked in another bug.
Comment by Nimit S.
6522 | July 24, 2015 02:40:48 AM GMT
I have just updated my system to CF Version 10,0,16,293499. I have also tested it on our test environment. When using the ormFlush it seems to work. However still when not using the ormflush() the enittyDelete is not persisted. See atachements for screenshot of mssql db Example code: x = entityLoadByPk("Test", url.id); entityDelete(x); ormCloseSession();
Comment by External U.
6523 | July 24, 2015 03:27:28 AM GMT
Hi Jork, We have to call ORMFlush to persist data before closing ORM session, if you are calling ORMCloseSession function explicitly. Because ColdFusion flushes ORM session at request end by default.
Comment by Nimit S.
6524 | August 04, 2015 09:16:50 PM GMT
We are closing this bug as duplicate. We will track this issue as part of bug #CF-4024153.
Comment by Nimit S.
6525 | August 19, 2015 03:11:57 AM GMT