@Lob annotation prevents sorting in grid?

Checked on 7.0.10.

If one have an entity class with String field and browse a default grid of these entities, there is standard sorting behaviour - click once on column’s header to sort ascending, then descending and so on…

But if String field is annotated with @Lob, sorting behaviour of corresponding column is disabled.

Is this by design? Or bug?

Hi,
What database type are you using?
Oracle DB doesn’t support sorting by LOB columns.

Hello! Thanks! Indeed, we are using Oracle Database 12c. After your answer I read some additional articles on this issue. Bad Oracle…