Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:10g

Hello All,

I have encountered an exception while running this query in hibernate.
String str6 = "SELECT TO_CHAR(ADD_MONTHS( TO_DATE(?,'DD/MM/YYYY'), (ROWNUM-1)),'Mon-YYYY') as MONYR, ADD_MONTHS(TO_DATE(?,'DD/MM/YYYY'),(ROWNUM-1)) as DD_DATE FROM CL_Enroll as clEnroll WHERE ROWNUM <= MONTHS_BETWEEN(TO_DATE(?,'DD/MM/YYYY'),TO_DATE(?,'DD/MM/YYYY'))+1 ORDER BY DD_DATE ASC";

The error is "DD_DATE": invalid identifier

when I run this query after removing the bold portion , the query runs successfully.But I need to add the order by clause.
This runs successfully:-
String str6 = "SELECT TO_CHAR(ADD_MONTHS( TO_DATE(?,'DD/MM/YYYY'), (ROWNUM-1)),'Mon-YYYY') as MONYR, ADD_MONTHS(TO_DATE(?,'DD/MM/YYYY'),(ROWNUM-1)) as DD_DATE FROM CL_Enroll as clEnroll WHERE ROWNUM <= MONTHS_BETWEEN(TO_DATE(?,'DD/MM/YYYY'),TO_DATE(?,'DD/MM/YYYY'))+1

So how can I order the result set on the basis of anonymous column which in my case is DD_DATE .

Thanx in Advance.

Regards,
Abhishek

try :
ORDER BY clEnroll.DD_DATE ASC

Hello,
Thanx for the fast reply, but I had tried this earliar, but that don't work.

I am getting an error:-

could not resolve property: DD_DATE of: CL_Enroll [SELECT TO_CHAR(ADD_MONTHS( TO_DATE(?,'DD/MM/YYYY'), (ROWNUM-1)),'Mon-YYYY') as MONYR, ADD_MONTHS(TO_DATE(?,'DD/MM/YYYY'),(ROWNUM-1)) as DD_DATE FROM CL_Enroll as clEnroll WHERE ROWNUM <= MONTHS_BETWEEN(TO_DATE(?,'DD/MM/YYYY'),TO_DATE(?,'DD/MM/YYYY'))+1 ORDER BY clEnroll.DD_DATE ASC]

As DD_DATE is not a property of CL_Enroll class.

So what I would do...

Regards,
Abhishek

This should work:

SELECT TO_CHAR(ADD_MONTHS( TO_DATE(?,'DD/MM/YYYY'), (ROWNUM-1)),'Mon-YYYY') as MONYR, ADD_MONTHS(TO_DATE(?,'DD/MM/YYYY'),(ROWNUM-1)) as DD_DATE FROM CL_Enroll as clEnroll WHERE ROWNUM <= MONTHS_BETWEEN(TO_DATE(?,'DD/MM/YYYY'),TO_DATE(?,'DD/MM/YYYY'))+1 ORDER BY ADD_MONTHS(TO_DATE(?,'DD/MM/YYYY'),(ROWNUM-1)) ASC

(repeat the calculations in the order by)

Hello nathan,
Yes, its working now...Thanx once again.

Regards,
Abhishek