Hi,
I have a query I could perfectly execute with JDBC which I need to return results in pages. The query must return a list of Strings. For example in MySQL:



As specifying a "LIMIT" is not standard I wanted to see if there was a way of adapting this to Hibernate's Query; something like:



In this case I'd get a "no persister for java.lang.String" error, but maybe I could create a dummy class for getting the string or an integer.
Any ideas would be appreciated.

Thanks in advance for your help!!

Andr

createSQLQuery can only return mapped classes. Use session.connection() to get the underlying JDBC connection and execute your query just like you would with JDBC.

Why don't you use a HQL query for this, you can use setMaxResult and setFirstResult for a query generated with session.createQuery()

I know. What I mean to do is to create a fake mapped class with a String attribute to contain the value, so I can use the database independent features of Hibernte for paging:

query.setMaxResults(pageSize);
query.setFirstResult(pageSize*pageNumber);

That way I wouldn't be hardcoding the "LIMIT a,b" form MySQL.

I know createSQLQuery wasn't created for doing this, but maybe there is a workaround.

Thanks again,

Andr

Just use a HQL query ...

The problem is that I generate some SQL tables dinamically and can't map them. So I need to use raw SQL.

Well, you could probably create a class mapped to any known table and then use it to keep the result of the createSQLQuery - just try it.