how to do this kind of jboss-ql?(select top n from....)

fingertiploneliness Mar 31, 2004 6:45 AM

in ejb finder method,i want to get the top n record form the query,how to do it in jbosscmp-jdbc.xml? or tell me jboss doesn't support it

1. Re: how to do this kind of jboss-ql?(select top n from....)

aloubyansky Apr 3, 2004 5:33 AM (in response to fingertiploneliness)
Like this
<jboss-ql>SELECT OBJECT(o) FROM OrderX o OFFSET ?1 LIMIT ?2</jboss-ql>

It is, in fact, does not translate into a vendor specific SQL syntax but the result set is read taking into account the values.
Actions
2. Re: how to do this kind of jboss-ql?(select top n from....)

malipanchu Sep 17, 2004 10:02 AM (in response to fingertiploneliness)

Is this syntax with LIMIT supported in 3.2.3.

Any configuration to be done for this?
Actions