Hi, rs.next() will return next row from the result set returned by query. Lee
-----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED]] On Behalf Of ramachandra Sent: Friday, February 07, 2003 2:11 PM To: [EMAIL PROTECTED] Subject: Re: resultset question Dear friend, When you call rs.next() Will the resultset fetches the next record from the database???? or will it from the resultset returned by your SQL Query???????? If it is from the database will it be feasible????????? or it is from the resultset returned by your SQL query then where it will store that result set. Regards, Ram... ----- Original Message ----- From: Ritesh Gupta <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 2:08 PM Subject: Re: resultset question > > Will the RowSet stores the resultset in RAM????????????????? > Yes. Its something like a JavaBean kind of implementation of a ResultSet. > Hence its unsuitable for holding large amount of data at one go. > >Then as you only told > > when you call rs.next() then only the next record is fetched. How the > > RowSet fetches the next record if the resultset is disconnected...... > The above should answer your question. Some reading about RowSet at Sun's > site > should help you understand it better. > > Regards, > Ritesh > > ----- Original Message ----- > From: "ramachandra" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, February 07, 2003 12:59 PM > Subject: Re: resultset question > > > > If the RowSet is uses a disconnected resultset. Then as you only told > > when you call rs.next() then only the next record is fetched. How the > > RowSet fetches the next record if the resultset is disconnected...... > > Will the RowSet stores the resultset in RAM????????????????? > > > > Regards, > > Ram.. > > > > ----- Original Message ----- > > From: Partha Ranjan Das <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, February 07, 2003 12:55 PM > > Subject: Re: resultset question > > > > > > > Only when you call the rs.next() the next record is fetched. If > > connection > > > is closed rs.next() will not fetch records. For such a case, you can use > > the > > > RowSet class which uses disconnected resultset. > > > Regards, > > > Partha > > > > > > -----Original Message----- > > > From: Abdul jeelani [mailto:[EMAIL PROTECTED]] > > > Sent: Saturday, February 07, 2004 12:48 PM > > > To: [EMAIL PROTECTED] > > > Subject: resultset question > > > > > > > > > Hi, > > > > > > One basic question: > > > > > > String query = "Select * from table"; > > > ResultSet rs = statement.executeQuery(query); > > > > > > Now, suppose the query returns 10,000 records. Whether the resultset > will > > > hold all the 10,000 records in memoy (RAM - stack, heap or cache does > not > > > matter)., or whenever a rs.next() is called it gets the next record from > > the > > > database. If the connection.close() is executed after the query is > > executed, > > > will rs.next() be able to get next records. > > > > > > Regards, > > > Jeelani > > > > > > > > > ======================================================================== === > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > > JSP-INTEREST". > > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > > DIGEST". > > > > > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > > > > > http://java.sun.com/products/jsp > > > http://archives.java.sun.com/jsp-interest.html > > > http://forums.java.sun.com > > > http://www.jspinsider.com > > > ********************************************************************* > > > Disclaimer: The information in this e-mail and any attachments is > > > confidential / privileged. It is intended solely for the addressee or > > > addressees. If you are not the addressee indicated in this message, you > > may > > > not copy or deliver this message to anyone. In such case, you should > > destroy > > > this message and kindly notify the sender by reply email. Please advise > > > immediately if you or your employer does not consent to Internet email > for > > > messages of this kind. > > > ********************************************************************* > > > > > > > > > ======================================================================== === > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > > > > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > > > > > http://java.sun.com/products/jsp > > > http://archives.java.sun.com/jsp-interest.html > > > http://forums.java.sun.com > > > http://www.jspinsider.com > > > > > > > > ======================================================================== === > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTER > EST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > > > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > > > http://java.sun.com/products/jsp > > http://archives.java.sun.com/jsp-interest.html > > http://forums.java.sun.com > > http://www.jspinsider.com > > ======================================================================== === > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com > ======================================================================== === To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
