I'm currently using 3.1, and having some issues with pulling a random single record from my database.

The mysql query utilizes the following format: "select * from table order by rand() limit 1"

This query results in one random record from the DB. With HQL, it throws an error on "limit" in the form of: unexpected token.

I've searched and found a few similar errors, but no result. Currently, I'm grabbing the entire set utilizing order by rand(), and just using the first or last row returned. The problem with this is that the DB size grows, the List size will as well.

Thoughts?

For limit you can use setMaxResults(1) on query object.

Hope that helps.
Thanks

Thanks, it appears this is exactly what I needed. Thanks!