Native SQL Queries - Aggregate Functions

spirois · **Posted:** Tue Dec 30, 2003 4:52 am

I am using the following Native SQL query:

Code:

String query = "SELECT COUNT(*) AS {rowcount} FROM STUDENT WHERE NAME='Coolio'";

To execute using hibernate, i understand that i am meant to use session.createSQLQuery()

This method takes 3 parameters:

String (the query)
String (the identifier..."rowcount" in this instance)
Class (the returned class)

My question is in this case, what should my returned class be?

Code:

Query q = session.createSQLQuery(query, "rowcount", THE_CLASS);

Thanks in advance

michael · **Posted:** Tue Dec 30, 2003 7:15 am

Why don't you use HQL for this, you can easily do a query like this:

Code:

SELECT count(*) FROM Student s WHERE s.name="whatever"

The .createSqlQuery is meant for querying for Hibernate mapped classes using SQL., which you don't do. If you really want to use SQL for that, you can get the SQL connection using session.getConnection() and execute the query manually.

max · **Posted:** Tue Dec 30, 2003 11:35 am

As per the documentationt the createSQLQuery only supports returning objects at the moment - not scalar results.

spirois · **Posted:** Wed Dec 31, 2003 8:08 am

OK Max (and gloeglm), thanks for your quick reply.

I have modified my application to use gloeglm's recommendation and it appears to be working fine.