Named Query...

[Senthil Narayanaswamy]

Hi,
I am using Named Query. I trouble i am having is i am not able to make the Order By clause work. This is the code i am using...the query works and i am getting data but only thing is data is not getting sorted.

<sql-query name="sortTest">
<return alias="empDept" class="com.test.hibernate.namedquery.EmpDeptDTO"/>
<![CDATA[SELECT p.EMP_ID AS {empDept.empId}, p.EMP_NAME AS {empDept.empName},
p.DEPT_ID AS {empDept.deptId}, d.DEPT_NAME AS {empDept.deptName}
  FROM EMP p, DEPT d 
  WHERE p.DEPT_ID = d.DEPT_ID order by :sortField ASC]]>
</sql-query>

In Java File...

Query query = session.getNamedQuery("calendarAdmin");
query.setString( "sortField", "EMP_NAME" );

.

Any help is appreciated.

Thanks,
Senthil.

[Paul Sturrock]

Normally its not possible to substitute object names in SQL, so I'd be a little bit surprised if Hibernate supported it.
[ December 02, 2008: Message edited by: Paul Sturrock ]

[Senthil Narayanaswamy]

Thanks Paul for sharing your thoughts. But i tried using the ?, still it doesn't work.

<sql-query name="sortTest"><return alias="empDept" class="com.test.hibernate.namedquery.EmpDeptDTO"/><![CDATA[SELECT p.EMP_ID AS {empDept.empId}, p.EMP_NAME AS {empDept.empName},p.DEPT_ID AS {empDept.deptId}, d.DEPT_NAME AS {empDept.deptName}  FROM EMP p, DEPT d   WHERE p.DEPT_ID = d.DEPT_ID order by ?]]></sql-query>
 
In Java File...
 
[code]
Query query = session.getNamedQuery("calendarAdmin");
query.setParameter( 0, "EMP_NAME" );

Any thoughts....

Thanks,
Senthil.