[hibernate-issues] [Hibernate-JIRA] Created: (HHH-1996) "ORDER BY ?" named parameter in named query ignored

"ORDER BY ?" named parameter in named query ignored --------------------------------------------------- Key: HHH-1996 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1996 Project: Hibernate3 Type: Bug Components: query-sql, query-hql Versions: 3.1.3 Environment: hibernate 3.1.3, java 1.5.0_06-b05, mysql 5.0.21 Reporter: W. Muir a named query, that contains a named parameter in the "ORDER BY" clause is ignored/removed. example: <query name="test"> <![CDATA[ FROM SomeObject so WHERE 1=1 ORDER BY :order ]]> </query> case 1 : named parameter set Query query = session.getNamedQuery( "test" ); query.setString( "order ", "so.id" ); List list = query.list(); // results are not ordered by id (or what ever you set for the named paraemeter) case 2: named parameter NOT set Query query = session.getNamedQuery( "test" ); // query.setString( "order ", "so.id" ); List list = query.list(); Exception in thread "main" org.hibernate.QueryException: Not all named parameters have been set: [order] [ FROM SomeObject so WHERE 1=1 ORDER BY :order ] 1. Should some sort of exceptioin be thrown (NotSupportedException, or something)? 2. bump this to a feature request? Related? http://opensource.atlassian.com/projects/hibernate/browse/HB-297 -- 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