[jboss-user] [EJB 3.0] - random selection with ejbql
do-not-reply at jboss.com
Mon Apr 9 03:34:09 EDT 2007
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.
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
More information about the jboss-user