Hibernate Community • View topic - hibernate random function

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

hibernate random function

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

tarun.trehan

Post subject: hibernate random function

Posted: Tue May 22, 2007 3:05 am

Newbie

Joined: Tue May 22, 2007 2:12 am
Posts: 9

hi all.

i need to retrieve a number of records from my table.
the retrieval has to be in a random order.
i'm aware of RAND() function in SQL.but is there any similar mapping in HQL too.

Top

amila733

Post subject:

Posted: Tue May 22, 2007 6:57 am

Senior

Joined: Thu May 17, 2007 2:31 am
Posts: 194
Location: Sri Lanka

Hi

SQLQuery q=sess.createSQLQuery("select RAND(1) as f, * from Table1");
q.list();

Amila
(Don't forget to rate)

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum