[jboss-user] [EJB 3.0] - random selection with ejbql

[merabi]

hi fellaz.

I'm developing a web app using EJB3.0 and MySQL but I came up w/ the EJBQL problem.

I need to write the EJBQL query to select RANDOM 150 records from a DB.

Is there anyway I can do it?

I know MySQL provides a rand() option and I know there is a method called createNativeQuery.

but my boss doesn't wanna use createNativeQuery for some reason...

Any info will be appreciated.
THNX!


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4035643#4035643

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4035643