Subject: Re: CachedRowSet vs Collection of ValueObject From: Vic C <[EMAIL PROTECTED]> === It is very fast, besides you are using CRS only as a collection.
Chen, Dean (Zhun) wrote: > Is CachedRowSet performant? > > I read here: > http://developer.java.sun.com/developer/Books/JDBCTutorial/chapter5.html > > "A CachedRowSet class-a disconnected rowset that caches its data in memory; > not suitable for very large data sets, but an ideal way to provide thin Java > clients, such as a Personal Digital Assistant (PDA) or Network Computer > (NC), with tabular data " > > Is this information in the tutorial out of date? > > Thanks, > > Dean Chen > > > -----Original Message----- > From: Struts Newsgroup [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 29, 2002 11:10 AM > To: [EMAIL PROTECTED] > Subject: Re: CachedRowSet vs Collection of ValueObject > > > Subject: Re: CachedRowSet vs Collection of ValueObject > From: Vic C <[EMAIL PROTECTED]> > === > When people use a the old ResultSet API (instead of the newer RowSet > API) they need a collection to store rows. > > You can avoid creating collecion and the garbage collection and the meta > data about the collection by using the RowSet's CachedRowSet. > > (Also RowSet can be created using new() and not ResultSet, making it > less likely to leak memory. ) > > A CachedRowSet is a list of rows. > Why is it so cool and why is it called Cached? > Becuase it is DISCONNECTED. > So after you retrieve, you can disconnect and still access the row. You > do not need to create a collection. > > The reason people used to need a collection is becuase they used to use > ResultSet which is not a JavaBean and ... it needed to be connected. > > Vic > > > vivek shrivastava wrote: > >>Hi, >> >>Following question may sound stupid but this is something I just thought >>of it. >> >>Can we use a helper class (Let's say HelperDB) which has "CachedRowSet" >>as a private member of that helper class instead of using a collection >>of ValueObject? >> >>I am thinking of using this helper class in EmpForm object of my little >>application. In EmpAction class i can get a instance of helper class >>from EmpForm or i can build a instance of helper class in EmpAction >>class and set it to EmpForm class. >> >>i am also thinking of implementing Iterator interface in helper class so >>that i can use this class in <logic:iterate> tag. Like: >> >><logic:iterate id="emp" property="HelperDB" name="EmpForm"> >> >>This way i don't have to create a collection of EmpVO (almost duplicate >>of Empform). >> >>is it a good idea or bad? >> >>Please do comment. >> >>Thanks >>vivek >> >> >>_________________________________________________________________ >>Send and receive Hotmail on your mobile device: http://mobile.msn.com >> >> >>-- >>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]> > > -- > 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]>