I had a query like this:

"select distinct client " +
"from Client as client " +
"inner join client.orders as orders " +
"order by client.name ";

Everything was fine, but I had to add a TEXT column to my Client table (OR mapping and accessors methods were added too).
And now I get a exception:

java.sql.SQLException: The text, ntext, or image data type cannot be selected as DISTINCT.

That

this isn't clean at all but you can retrieve all properties of client except the TEXT one and build a client snapshot from it (this object won't be managed by Hibernate however).

What I did was:

"select client from Client client " +
"where client.id in ( " +
"select c.id " +
"from Client as c " +
"inner join c.orders as order " +
"group by c.id ) ";

So I still have hibernate managing all the objects generated by the query result.

What do you think about the solution?

Tks
Felipe

If your DB CPU can handle it, that's a much better solution.