Status/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Matthew Walker / Matthew Walker (leptinella1)
Created: 03/19/2013
Components: ORM Support
Versions: 10.0
Failure Type: Usability Issue
Found In Build/Fixed In Build: Final / CF10_Update14
Priority/Frequency: Minor / Some users will encounter
Locale/System: English / Windows 7 64-bit
Vote Count: 2
Problem Description:
If you use tabs to lay out your HQL query without spaces then you receive a cryptic error.
Steps to Reproduce:
Here's a typical query. If the white space is done with tabs then there is an error. If it is a combination of spaces and tabs or just spaces it works.
<cfquery name="tags" dbtype="hql">
SELECT tag.tag
FROM thrive.tag tag
WHERE tag.tag LIKE <cfqueryparam value="#url.q#%">
ORDER BY tag.objects.size desc
</cfquery>
Actual Result:
org.hibernate.hql.QueryExecutionRequestException: Not supported for select queries [
SELECT tag.tag
FROM thrive.tag tag
WHERE tag.tag LIKE ?
ORDER BY tag.objects.size desc
]
Any Workarounds:
This error is easy to work around. However, the error message is completely misleading so it is tricky to debug and just one more horrible ORM / CF experience. This has been reported before. I think it would be great to either fix this (just turn tabs into spaces?) or at least fix the error messaging.
https://bugbase.adobe.com/index.cfm?event=bug&id=3041019
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3525456
External Customer Info:
External Company:
External Customer Name: leptinella1
External Customer Email:
External Test Config: My Hardware and Environment details:Attachments:
Comments: