java - JPA: 'SELECT DISTINCT' with BLOB columns -

I am trying to run this JPQL query:

  Select I JOIN I.ther  

with which instant fails:

"Internal Exception: java.sql.SQLException: Column Type 'Blob 'Maybe' index is used in order bye, group bye, union, intersect, acetate or deliateac statements because the comparison is not supported for that type. "

This error I understand But how can I get around this?

You have a hush in any other column Or store the checksum of the Blob object, and select

Example:

  from SELECT I to the table WHERE id (SELECT id FROM (SELECT MIN (id) AS is the hash_of_i table group by hash_of_i) t)  

I'm sure you can write this SQL more beautifully, but it will give you an IDE.

Edit - Let you use it realized that can deliver entirely separate operator (it will functionally equivalent).

Edit 2 - I'm not sure that my first version works, so it has been rewritten