The first thing that comes to mind is instructing JPA to lazy load the field like this:
The problem with this is that in order to work the persistence provider needs to support it. When using Hibernate as JPA provider you have to instrument the bytecode at compile time.
What are the alternatives?
- Create a separate Entity class containing all fields except the lob field and use this for the collection query.
- Use a query with a projection to only include the non-lob fields