I've a simple query with a very simple group by clause. But, it's blowing up temporary tablespace. No matter how big is the temporary tablespace or no matter how many rows the query is returning. In other words, tried to extend temporary tablespace as big as possible and tried to restric the query to return only 12 rows. Still the result is same. When I run the query outside of hibernate (using sqlplus it returns quickly without any issues). Has anyone seen this before?




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