but back then the new list on Apache sort of was
empty, never got an answer. I try to post it again, now that the list has picked up momentum.
I have following problem. I want to have a Hibernate backed backend bean which I want to connect to a datascroller/datatable combination.
The problem I see with the current API is, that it seems to be either resultset, with a permanent open db connection and plain jdbc, or load the entire resultset into the ram and "shove" it into the datatable.
Now both combinations are not exactly what I want, I want
to have the connections not totally open all the time (the framework will take care of it anyway once not used anymore)
and I want only the visible scope of database objects loaded.
My idea which I have been thinking about would be some kind of proxy patterned list which is given to the datatable.
The list basically only loads one single page at a time and then closes the connection but is giving the full size and keeping the page size for the paging and the page pos.
(Even with the problem that this thing can be altered between
page requests during scroll operations by another user)
But my question is, am I correct with the assumption that writing a proxy list is the cleanest way to reach my goals, or is there another solution which might be cleaner and easier to implement (like an already implemented solution which already does this or an existing hibernate hook of the myfaces components in CVS?)
Werner

