One neat option with DB objects is to implement the design for a FilteredRowSet as specified by Sun's RowSet. It is/can be separated from the DB for caching in the application or session and it essentially acts like a mini-db in memory. One use would be to select * clients and then allow users to use 'range' or 'like' filters to control the cursor of the RowSet.
I tried going down the road of object caching but I cam to the conclusion that any data that required caching was better off just being cached at the view level or pre-view level as XML or as the static page content (OSCache). Retaining ACID properties of site when multiple applications were using the same DB wasn't worth the hassle. A good DBCP provides excellent speed anyways. Links: http://www.javaworld.com/javaworld/jw-02-2001/jw-0202-cachedrow.html http://www.javaworld.com/javaworld/jw-05-2002/jw-0524-sql.html Jacob Hookom Comprehensive Computer Science University of Wisconsin, Eau Claire -----Original Message----- From: Chappell, Simon P [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 11:15 AM To: Struts Users Mailing List Subject: RE: Open Source Object Caching Systems compatible with Struts Interesting. We implemented our own full object cache for an industrial control system that we are writing. I would be very interested to hear any experiences that folks have with the products mentioned here. Simon ----------------------------------------------------------------- Simon P. Chappell [EMAIL PROTECTED] Java Programming Specialist www.landsend.com Lands' End, Inc. (608) 935-4526 >-----Original Message----- >From: Phase Web and Multimedia [mailto:[EMAIL PROTECTED]] >Sent: Monday, July 22, 2002 11:16 AM >To: Struts User List >Subject: Open Source Object Caching Systems compatible with Struts > > >Greetings, > >I believe everyone knows what object caching is, so I won't go >into detail. >But, I have been doing a little exploration to find a good open source >object caching system. I have found a few in the apache world >turbine:services:object cache, turbine:jcs, and OJB has a >caching mechanism >within it. But I would have to extract the OJB code and make >my own caching >system. The code is OJB specific. My questions are: Does >anyone know of any >other open source object caching or JCS implementations? and >Which of these >works well with struts? (i.e. Can the turbine jcs or object >cache service >run independent of all the extra turbine bloat and play nice >with struts?) > >Brandon Goodin >Phase Web and Multimedia >P (406) 862-2245 >F (406) 862-0354 >[EMAIL PROTECTED] >http://www.phase.ws > > > >-- >To unsubscribe, e-mail: ><mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: ><mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.375 / Virus Database: 210 - Release Date: 7/10/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.375 / Virus Database: 210 - Release Date: 7/10/2002 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>