You may want to look at Cayenne ORM: http://objectstyle.org/cayenne/
> 1. I have atleast two databases which I wish to > communicate with. That requires DB queries > crossing between tables or even databases. Cayenne allows to have multiple databases used transparently. It will figure out where to send each query behind the scenes. > 4. As I may have say 10 users at a time logged on > each of them returning 2000 rows each = 20,000. Cayenne has a feature that we successfully used at http://www.nhl.com/ - paginated results, when the list returned is being resolved "lazily" addressing performance and stale data issues: http://objectstyle.org/cayenne/userguide/perform/paged-queries.html Cheers, Andrus Adamchik > Hi, > > I am looking to write a web application/(servlet/JSP) > and I have the following requirements. > > 2. When selecting rows I may have say 100 rows > returned > probably over 2000 but I wish to display twenty at a > time. > > 3. With point two I am worried that I may be > displaying stale data. > > 4. As I may have say 10 users at a time logged on > each of them returning 2000 rows each = 20,000. > > I intend to use struts frame work for session control > between users. > > Is this db the right framework for me if not which > framework is most useful for me ?
