Jad,
In case your result set is really large ,you could use entity list
iterator, as shown below,
resultEli = delegator.find(entityName, condition, null, fieldsToSelect,
null, efo);
Entity list iterator will fetch partial results into memory, yet
delegator.findList() will retrieve all the records into memory. In case
your machine is memory-constrained, entity list iterator is preferred.
On Fri, Jan 17, 2014 at 8:01 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:
> +1, Think twice about it !!!
>
> Jacques
>
> On Friday, January 17, 2014 12:17 PM, adrian.crum@sandglass-software.comwrote
> > I would recommend that no one do this. It breaks the encapsulation of
> > the entity engine.
> >
> > The entity engine has been around for 12 years. Anything you need to do
> > with a data source has been accommodated, you just need to spend some
> > time looking for it.
> >
> > Adrian Crum
> > Sandglass Software
> > www.sandglass-software.com
> >
> > On 1/17/2014 4:21 AM, rongnguyen wrote:
> >> You can use custom SQL:
> >> String helperName = delegator.getGroupHelperName("org.ofbiz");
> >> SQLProcessor sqlProc = new SQLProcessor(helperName);
> >> sqlProc.prepareStatement("SELECT * FROM TABLE");
> >> ResultSet resultSet = sqlproc.executeQuery();
> >>
> >>
> >>
> >> --
> >> View this message in context:
> http://ofbiz.135035.n4.nabble.com/delegator-findAll-missing-tp4647322p4647323.html
> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
