hi! i got 38 mails from servlet-interest today. 30 with the subject containing "resultset". i think it's just rude and impolite that in case you _know_ that your question is off-topic for servlet-interest to ask it anyway at servlet-interst (sorry, don't take it personal, but if you don't know it's off-topic, you're just dumb). i know that there are people on this list asking jdbc questions on servlet-, jdbc- AND j2ee-interest. you call yourself programmers or software engineers and you write servlets which is quite a difficult task. so i think everyone on this list should be clever enough to search google with some keywords describing his/her problem or to subscribe to a newsgroup/mailing list that is appropriate to his/her question. sorry for being rude, but this is not the first day that there are more off-topic questions than on-topic ones and i just don't get it. it's not only because i don't like answering database/swing/j2ee related questions (actually i'm a subscriber of all these lists so i think all these topics are interesting) it's just that this isn't the place to discuss these topics (btw, for jdbc questions you'll get better answers on jdbc-interest). i don't think it's a rule to ask servlet questions on servlet-interest and jdbc-related questions on jdbc-interest because somebody loves to make rules but because that rule makes sense. it's not only a matter of respect. can't we have a list-manager to delete all tht off-topic stuff???
-mw ----- Original Message ----- From: "Zvika" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 9:22 PM Subject: Re: Copiar ResultSets > ...or else you can work with a RowSet object, which you can use to wrap the > original resultset. Some memory issues might arise, depending on the size of > the rowset, but here's a link for a nice article about RowSets: > http://www.javaworld.com/javaworld/jw-02-2001/jw-0202-cachedrow.html > > > -----Original Message----- > From: A mailing list for discussion about Sun Microsystem's Java Servlet API > Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Dror Matalon > Sent: Tuesday, May 28, 2002 7:26 PM > To: [EMAIL PROTECTED] > Subject: Re: Copiar ResultSets > > > do a "select count(*) from tablename" first. The database can count > the number of rows much faster than you can. If there's no where > clause it'll often know the answer without fetching any rows. > > You are executing the query again, but since you're not transferring > any data, it should be much faster. > > On Tue, May 28, 2002 at 06:53:14PM +0200, Manuel Rodriguez Diaz wrote: > > Hi all, > > I'm working with java 1.1. (this is a mandatory requirement). > > In this version of Java, resultset are "FORWARD ONLY". > > The fact is that i need to count the rows contained in a resultset > > before displaying its data and the way i've thought to do this is read > > all the resultset. > > rows= 0; > > while( rs.next()) { > > rows++; > > } > > > > With my actual version of java, I would need to re-execute the query > > again to get the pointer "beforeFirsted". > > Is there any way to obtain a independent copy of a ResultSet without > > executing the query again? > > > > Thankyou > > > > > ___________________________________________________________________________ > > To unsubscribe, send email to [EMAIL PROTECTED] and include in the > body > > of the message "signoff SERVLET-INTEREST". > > > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > > Resources: http://java.sun.com/products/servlet/external-resources.html > > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > > > > -- > Dror Matalon > Zapatec Inc > 1700 MLK Way > Berkeley, CA 94709 > http://www.zapatec.com > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
