The issue is solved,
I was returning a scrollable result set object from the method to be
processed by the calling class. The OQLQuery was declared inside the method
and once the method returns it would go out of scope.
The OQLQueryImlp class is designed properly and finalize method forcefully
closes the OQLQuery, thus once the next round of gardbage collector kicks
in, the scrollable resultset would stop returning data.
Thanks everyone.
>From: "Dmitry Amelchenko" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: Re: [castor-dev] scrollable result set issue
>Date: Mon, 16 Sep 2002 15:07:21 +0000
>
>Forgot to attache the code, sorry, here it is now.
>
>The app is really very strait forward. Does not do anything special.
>Here is the code attached.
>
>If you have any questions about the code, I'd be glad to explain it.
>
>>From: Bruce Snyder <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>To: [EMAIL PROTECTED]
>>Subject: Re: [castor-dev] scrollable result set issue
>>Date: Fri, 13 Sep 2002 23:05:01 -0600 (MDT)
>>
>>This one time, at band camp, Dmitry Amelchenko said:
>>
>>DA>The size() method always works fine, but every once in a while
>>hasMore()
>>DA>lies and returns false even though I know that there are more rows that
>>DA>query supposed to return.
>>DA>
>>DA>For instance if i have let say 4000 objects that I want to page
>>through, the
>>DA>size() will return 4000, then I use absolute to set the cursor to lets
>>say
>>DA>trow number 1000, and I want to iterate over next 100 rows, but on row
>>56 it
>>DA>the results.hasMore() will return false, if I ignore the false and try
>>to
>>DA>call results.next() any ways, it will throw an exception (invalid index
>>or
>>DA>not existing element somthing like that, dont remember exactly now).
>>
>>Dmitry,
>>
>>I've never heard of anyone with this particular problem. Can you
>>post some relevant code examples and mappings for us?
>>
>>Bruce
>>--
>>
>>perl -e 'print
>>unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
>>
>>-----------------------------------------------------------
>>If you wish to unsubscribe from this mailing, send mail to
>>[EMAIL PROTECTED] with a subject of:
>> unsubscribe castor-dev
>
>
>
>
>_________________________________________________________________
>Chat with friends online, try MSN Messenger: http://messenger.msn.com
><< a.zip >>
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev