Hibernate version:3.0.5

Hi,

I have Hibernate based object model and I would like to use Hibernate Criteria API to build queries which feed my report engine. But after some thinking, I think that it won't be usable to retrieve all objects into the memory. So I have a question:

I still would like to use Criteria API to build queries, but then, I would like to retrieve a sql string from the Criteria and to execute plain JDBC select.

Is it possible? I looked for this kind of "Projection" class, but couldn't find ...

Thanks!
Misha.

Criterion.toSQLString is , but requires you to pass in instances of classes that are supposed to only be used by the API, not client programmers.

DetachedCriteria.toString() gives you a string that describes the query, but isn't actually sql.

Also, if your only concern is the size of the result set, DeteachedCriteria allows setting paging sizes, to bring back "pages" consisting of only part of a result set.