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)".
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