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

Hibernate version:
2.0
Name and version of the database you are using:
Oracle 9

I am trying to do this query(cames from a legacy system):

select to_char(trunc(first_alert,'mm'),'Mon YYYY') , count(*) from Alert where first_alert is not null group by trunc(first_alert,'mm') order by trunc(first_alert,'mm') desc

Unfortunately, I am getting a SQL 17090 error, but when I run this same query direclty to database and works. Is there any statement that I am doing wrong?