select count(this_.when_requested) as y0_, count(this_.when_accessed) as y1_, count(this_.when_downloaded) as y2_, this_.application_name as y3_ from reports this_ where this_.when_requested between 'Mon Jun 02 00:00:00 BST 2008' and 'Thu Aug 14 00:00:00 BST 2008' group by this_.application_name order by this_.when_requested limit 100

gives me an error : org.postgresql.util.PSQLException: ERROR: column "this_.when_requested" must appear in the GROUP BY clause or be used in an aggregate function

So, I need to use the generated alias(y0_) for this.when_requested. Any ideas how to control the alias names for columns?















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

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html