i have to inform you, that paging by SQL is not yet an option because we execute a select for each extent. imo it could be done using the sql limits/offset, but some dbms would need an enclosing query because the rownim comparison is someway limited :
(oracle)
select * from ( select ... , rownum as ojb_rnum where .... order by ... ) where ojb_rnum between OFFSET and OFFSET + LIMIT
but i think i found a way to improve OJB-paging be it for collections or iterators.
as soon as time permits i will start working on the new solution.
Jakob Braeuchi wrote:
hi all,
here's what i found regarding SAPDB
http://www.sapdb.org/htmhelp/8c/ccce30c71c11d2a97100a0c9449261/content.htm
jakob
Charles Anthony wrote:
Hi,
It is not possible to do this in a cross platform way, so No, currently this
is not possible in OJB.
For an explanation of the reasons why, see
http://article.gmane.org/gmane.comp.jakarta.ojb.user/10065/match=paging+perf
ormance+issues
Cheers,
Charles.
-----Original Message----- From: Andy Czerwonka [mailto:[EMAIL PROTECTED] Sent: 11 November 2003 13:35 To: 'OJB Users List' Subject: only grab 10 records
Does anyone know if its possible to do something like this in OJB:
select * from table where criteria but only return me a maximum of 10 records.
Is this possible?
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
___________________________________________________________ HPD Software Ltd. - Helping Business Finance Business Email terms and conditions: www.hpdsoftware.com/disclaimer
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
