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" <mathias@(protected)>
To: <JSP-INTEREST@(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:JSP-INTEREST@(protected)
> Skickat: den 11 februari 2004 13:40
> Till: JSP-INTEREST@(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" <jlauman@(protected)>
> To: <JSP-INTEREST@(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 listserv@(protected)
> JSP-INTEREST".
> > For digest: mailto listserv@(protected)
> 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 listserv@(protected)
> JSP-INTEREST".
> For digest: mailto listserv@(protected)
> 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 listserv@(protected)
JSP-INTEREST".
> For digest: mailto listserv@(protected)
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 listserv@(protected)".
For digest: mailto listserv@(protected)".

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