[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1706?page=c...
]
Matthew Lieder commented on HHH-1706:
-------------------------------------
I can confirm this is a legitimate bug and still exists in 3.5.1.
org.hibernate.engine.query.ParameterParser isn't aware of comments and thus treats
anything inside comments as if it's actual SQL.
Named parameters ignored when single apostrophe encountered within an
SQL comment
---------------------------------------------------------------------------------
Key: HHH-1706
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1706
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.1.3, 3.2.0 cr1
Environment: 3.1.2, DB2/400
Reporter: Curtis Witherow
Attachments: bug.zip
Found that named parameters in an named SQL query are ignored when a single apostrophe is
encountered in an SQL comment (either /* ... */ or -- ... form).
The obvious workaround is to remove single apostrophes from SQL comments.
I have included test code that runs two queries -- the first succeeds, the second fails.
The only difference between the queries is that the second contains the apostrophe
character within a comment.
Since I was testing against DB2/400, I was using SYSIBM.SYSDUMMY1 as my source table.
This is analygous to using DUAL on an Oracle db.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira