Hello,
How I can resolve problem when list in one-to-many relationship is large ?

For instance order with > 10000 items

regards
Haris Peco

lazy="true"

and when I access to items will I get all items or for instance only 100 items ?

All, of course.

Fine, but I want only <= 100 rows - How I can do this ?

Thanks

You probably need "pagination", search the documentation.

I know for pagination (and scrolling resultses, too), but my question is :

Can I set any mapping property and that Hibernate don't load all items in collection than load btw. <= 100 and scroll automatic when is necessery, like
ResultSet in JDBC with setFetchSize

regards

No, not if you are using lazy loading. Use an explicit fetch.

I don't worry about lazy - only that <= xxx rows be in memory

When I set fetch in hibernate cfg, hibernate use fetch for database access, but collection is complete full always

I want that when I access to collection items, hibernate have <= xxx items in memory and load rest of items when I get it

For instance : orders items have > 10000 rows ( I can get all 10000 rows in
memory - VM return OutOfMemory)

I access to items 1 and hibernate have in memory 1-100 rows, when I access to row 101 hibernate load next 100 rows from database etc

I can resolve this with scrollable ResultSet, but I want that hibernate do it with for instance

<set ....
maxRows="100" />

regards

It doesn't exist, but you can of course write a patch and submit it to JIRA.

It is features wish - I know write helper class for me , which use scrollable results, but I don't know add it to hibernate - it have to be, probably, special collection (LargeList or LargeSet)

Thanks

Note that you can also use pagination using a collection filter. Actually, I've never seen a request like yours, because most of the issue you have can be solved with criteria, HQL, and/or filters.

If you think on criteria.setMaxResults, it don't work with Oracle 8.0,
but it isn't important.
I know that I can resolve this problem,but I want that Hibernate work this (with declaration in mapping file)
I don't know why You haven't request like this, but large query are often
and I want next form Hibernate
give me "normal" collection, but I want that only <= xx items are in memory - I can do it (with HQL,criteria, scroll resultset etc), but I declare it and forget .
regards