I haven't tried FilteredRowSet yet, but we have not had much in the way of ACID problems yet. We do have a timestamp on the database parent record and the cached object. Before handing out the cached object, we run a real simple SELECT to compare the timestamps and that way we know that the cached version is up to date. The SELECT takes less than 15 ms in our environment and we find that acceptable in the trade-off of wanting pre-fetched data yet not wanting stale data.
Simon ----------------------------------------------------------------- Simon P. Chappell [EMAIL PROTECTED] Java Programming Specialist www.landsend.com Lands' End, Inc. (608) 935-4526 >-----Original Message----- >From: Jacob Hookom [mailto:[EMAIL PROTECTED]] >Sent: Monday, July 22, 2002 11:30 AM >To: 'Struts Users Mailing List' >Subject: RE: Open Source Object Caching Systems compatible with Struts > > >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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
