Hibernate version: 2.1.6

I have a Hibernate persisted object, Recipe, in a table "recipe". I need to utilize a native SQL statement like the following:



but obviously this is not intended to return recipe objects... as a Recipe object does not have either "section" or "cnt" properties.

My question is, in general what is the appropriate way to accomplish this type of arbitrary native SQL in Hibernate? There are some cases where I want to execute arbitrary queries that return result sets that don't map to Hibernate-persisted object properties.

use session.connection() and do it the plain old JDBC way

It works!

Example:
Query sqlQuery = session.createQuery("select substr(quiz.a_StartDate,1,2) from E_Quiz quiz");