tracker issue : CF-4203835

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

Table names that clash with reserved words no longer escaped properly

| View in Tracker

Status/Resolution/Reason: To Test//UserError

Reporter/Name(from Bugbase): Mike Hodgson / ()

Created: 12/19/2018

Components: ORM Support

Versions: 13.0

Failure Type: Crash

Found In Build/Fixed In Build: CF 2018 /

Priority/Frequency: Normal / Some users will encounter

Locale/System: English / Windows 7 64-bit

Vote Count: 0

Problem Description:

If you name an ORM entity the same as a reserved word in SQL Server, a crash occurs when Hibernate attempts to update the table (creation is OK). This is even with escaping the table name in the table="" attribute of the CFC.

Steps to Reproduce:

Create a persisted CFC with the entityname="Group"
Reload application
Add a new property
Reload application again

Actual Result:

Error regarding incorrect syntax near the keyword 'Group'

Expected Result:

Table created

Any Workarounds:

Rename table or entities