spring data jpa query to limit

Question

I have query as such :

@Query("select a from Ability a where a.eventLogic = ?1 AND a.abilitySetId = ?2 ORDER BY    RAND() LIMIT ?3")

BUt i get an error:

Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: LIMIT near line 1, column 117

How can i programmatically put in the limit number?

im using spring data jpa, so i have an interface as above.. i wonder if i could send in a pageable object?? — user1555190, Oct 22 '12 at 11:12
Take a look here: http://stackoverflow.com/questions/9314078/setmaxresults-for-spring-data-jpa-annotation — santedicola, Oct 22 '12 at 11:38
And here: http://stackoverflow.com/questions/6356322/how-to-use-order-by-and-limit-in-spring-data-jpa-using-querydsl — santedicola, Oct 22 '12 at 11:39
spring data jpa, has documentation, that states how to solve this using some paging. Thats what i used. — user1555190, Mar 01 '13 at 16:29

score 1 · Accepted Answer · answered Mar 01 '13 at 16:29

1

spring data jpa, has documentation, that states how to solve this using some paging. Thats what i used

answered Mar 01 '13 at 16:29

user1555190

score 0 · Answer 2 · answered Sep 03 '13 at 13:35

0

I had a similar issue and adding an explicit ASC clause solved it.

answered Sep 03 '13 at 13:35

Stephane

2 Answers2