EJBQL List pages partial list

[freakwave10]

Hi all,

I have a simple List page that is based on the Seam EntityEquery Bean.
The Entity itself has a few clobs.

The problem is that the list pages are very slow because it is also fetching the CLOB's.
The Clob's only need to be displayed when you select a record.
What is the best way to improve it? Is there any way in the EJBQL to restrict it to the columns needed?
I tried it, but the problem I think is that the EJB QL is supposed to return an object.

Thanks all for your help,

Wolfgang

[francof]

Wolfgang,

I am not the most experienced guy here, so pardon me if I have steered your wrong.

I have not tried this but I believe you can create a custom bean for only your specific resultlist and map it.

See page 2 Result Classes of this guide

http://www.solarmetric.com/resources/ejbql-quickref.pdf

Let me know if it works.

Franco

[swd847]

Some persistence providers provide extensions that allow for lazy property fetching. If you are using hibernate have a look in the hibernate annotations docs to find the annotation to use (I can't remember off the top off my head). If you do use lazy property fetching I think you have to instrument your code at build time, otherwise it is silently ignored.