Yes it would require a continuous key sequence. If you're going to use the resultset, I would set the prefetch size as small as possible. stmt.setFetchSize(1); rs.absolute(random(1-nr.getSize());
(http://java.sun.com/j2se/1.4.2/docs/guide/jdbc/getstart/resultset.html#1012 735) Hugo ----- Original Message ----- From: "Mathias Höggren" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 11, 2004 2:01 PM Subject: SV: Java / MySQL Question > Doesn't that require that the primary key is in sequence without any gaps!? > > A more failure tolerant solution would be to fetch all rows in the table and > scroll the resultset forward a random number of rows based on the total > number of rows in the table. > > for (int i = 0; i < randomRowNum && resultset.next(); i++); > > /Mathias > > > -----Ursprungligt meddelande----- > Från: A mailing list about Java Server Pages specification and reference > [mailto:[EMAIL PROTECTED] Hugo Pragt > Skickat: den 11 februari 2004 13:40 > Till: [EMAIL PROTECTED] > Ämne: Re: Java / MySQL Question > > > Well, if you have an autonumber primary key, you could get the largest > existing value and generate a random key with the class Random in JBoss > Then retrieve the 1random recoord from the random key. > > Hugo > > ----- Original Message ----- > From: "Jack Lauman" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, February 11, 2004 12:49 PM > Subject: Java / MySQL Question > > > > I have a table containing information about different businesses. I > > want to randomly select a single row from the table using a prepared > > statement in a java bean. (Using MySQL 4.0.17 and JBoss 3.2.2) > > > > What is the most eficient way to do this? > > > > TIA > > > > Jack > > > > > =========================================================================== > > 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 > =========================================================================== 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