Forum:

JDBC and Relational Databases

retrieve values randomly ?

Ranch Hand

Posts: 87

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

how can I retrieve values from database randomly ?
suppose in my database there are 13 rows . and I want to retrieve these in random order ?
is there any method to do it ?

SCJP 6 (88%), SCWCD 5 (78%), preparing for SCBCD

Sandeep Kumar S Jakkaraju

Ranch Hand

Posts: 37

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

you can do "order by rand()" .....if it is an rdbms ......

I write like Jean Paul Sarte but in Java....

Scott Selikoff

author

Posts: 4342

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Not really. The best solution would be to randomize the returned data in the object/list/array you are storing them in.

[OCP 21 Professional Study Guide] [OCP 17 Complete Study Guide] [OCP 17 Practice Tests] [OCP 11 Complete Study Guide] [OCP 11 Programmer I] [OCP 11 Programmer II] [OCP 11 Practice Tests] [OCA 8] [OCP 8] [OCP 8 Practice Tests Book] [Blog]

Scott Selikoff

author

Posts: 4342

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

How many records are we talking about? Unless your passing the result set to the presentation layer (scary) I don't see how your not putting things into memory. A resultset is just a database-backed hashmap.

Saurabh Naik

Ranch Hand

Posts: 87

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thank you Jean.. it works with order by rand()..
but is there any mechanism to fetch result randomly through function..
what is this ResultSet.FETCH_UNKNOWN... how to use it ?

SCJP 6 (88%), SCWCD 5 (78%), preparing for SCBCD

Scott Selikoff

author

Posts: 4342

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

There is no method in java to randomize result sets but it would be trivial to do so in an application.

And then the flying monkeys attacked. My only defense was this tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser