Return-Path: 
 <user-return-37447-apmail-ofbiz-user-archive=ofbiz.apache.org@ofbiz.apache.org>
X-Original-To: apmail-ofbiz-user-archive@www.apache.org
Delivered-To: apmail-ofbiz-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 766F34B97
	for <apmail-ofbiz-user-archive@www.apache.org>;
 Thu, 19 May 2011 13:38:01 +0000 (UTC)
Received: (qmail 16186 invoked by uid 500); 19 May 2011 13:38:00 -0000
Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org
Received: (qmail 16152 invoked by uid 500); 19 May 2011 13:38:00 -0000
Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@ofbiz.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@ofbiz.apache.org>
List-Post: <mailto:user@ofbiz.apache.org>
List-Id: <user.ofbiz.apache.org>
Reply-To: user@ofbiz.apache.org
Delivered-To: mailing list user@ofbiz.apache.org
Received: (qmail 16144 invoked by uid 99); 19 May 2011 13:38:00 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 May 2011 13:38:00 +0000
X-ASF-Spam-Status: No, hits=2.3 required=5.0
	tests=SPF_SOFTFAIL,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: softfail (nike.apache.org: transitioning domain of
 paul@cohsoft.com.au does not designate 216.139.236.26 as permitted sender)
Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 May 2011 13:37:55 +0000
Received: from joe.nabble.com ([192.168.236.139])
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <paul@cohsoft.com.au>)
	id 1QN3Pw-0002GS-U4
	for user@ofbiz.apache.org; Thu, 19 May 2011 06:37:32 -0700
Date: Thu, 19 May 2011 06:37:32 -0700 (PDT)
From: Paul Foxworthy <paul@cohsoft.com.au>
To: user@ofbiz.apache.org
Message-ID: <1305812252983-3535697.post@n4.nabble.com>
In-Reply-To: <1305292645000-3520179.post@n4.nabble.com>
References: <1305292645000-3520179.post@n4.nabble.com>
Subject: Re: EntityListIterator Not Closed Error
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Hello Vivek,

Are you consuming your productReviewList anywhere? That might be what frees
up the iterator.

See for example the screen EditContactListParty in
applications/marketing/widget/ContactListScreens.xml at
https://fisheye6.atlassian.com/browse/ofbiz/trunk/applications/marketing/widget/ContactListScreens.xml?hb=true#to129
There's an iterate-section using the list defined by the entity-condition.

I haven't tested it, but if the EditContactListParty doesn't bring on the
problem you're seeing, you might be able to narrow down the difference
between it and your code. If it does produce the same error, maybe a bug has
crept into the entity-condition action.

Cheers

Paul Foxworthy


vivek wrote:
> 
> Dear Friends,
> 
> Greetings of the day.
> 
> I am working on a request to display latest 5 pending reviews in one
> particular section of the website.
> For this reason i have written entity-condition in the actions section of
> the screen.
> However i can make use of groovy or ftl itself & call the list out there,
> but wish to perform in this way.
> 
> The concern i am facing is that when the list gets prepared, it is
> throwing EntityListIterator error stating
>  EntityListIterator Not Closed for Entity [ProductReview], caught in
> Finalize
> 
> Here is the attached code what i am trying to do.
> 
> <entity-condition entity-name="ProductReview"
> list-name="productReviewList">
> 	<condition-expr field-name="statusId" operator="equals"
> value="PRR_PENDING"/>
> 	<select-field field-name="productRating"/>
> 	<select-field field-name="productReview"/>
> 	<select-field field-name="postedAnonymous"/>
> 	<select-field field-name="userLoginId"/>
> 	<select-field field-name="postedDateTime"/>
> 	<order-by field-name="productReviewId"/>
> 	<limit-range start="0" size="5"/>
> </entity-condition>
> 
> As it observed there should be an object of EntityListIterator say eli
> which must be closed (eli.close()). However the same thing in groovy or
> java with eli.close() works fine, but I am unaware as how to write the
> said expression in xml or is there any other way around to prevent the
> concern i am facing.
> 
> i have attached an file containing the same code, if in case the code gets
> messy while posting.
> 
> Kindly let me know what can be done in the process to rectify the concern
> or how can i avoid the error being encountered?
> 
> Your early reply & help in this regard will be highly appreciated.
> 
> Thanks.
> 
> Regards:-
> 
> Vivek Jadiya
> er.jadiyavivek@gmail.com
> +91-9686757747 http://ofbiz.135035.n4.nabble.com/file/n3520179/code.txt
> code.txt 
> 


--
View this message in context: http://ofbiz.135035.n4.nabble.com/EntityListIterator-Not-Closed-Error-tp3520179p3535697.html
Sent from the OFBiz - User mailing list archive at Nabble.com.