i need to get a series of random number to be compared to a table so as to fetch random questions from the table how can i acomplis this...

thanks in advance
Balaji.M

One way would be to have a column in the Question table whose value is a number..1,2,3,4...etc. This could be an id column for that matter.

Now you can generate a random number using Random, for example and do a select using "where id=<random>". You'd probably need to normalize the generated number.

Hi

Query q=session.createQuery("from Animals ") ;

q.setFirstResult(random);
q.setFetchSize(1);

Amila

(Don't forget to rate if helps)