how to generate a complex query without a param with JpaRepository?

Asked Nov 19 '17 at 13:42

Active Jan 10 '18 at 09:06

Viewed 50 times

I want to genaerate a query like below.

select * FROM news ORDER BY ptime DESC LIMIT 5

I have tried

List<News> findAllOrderByPtimeDesc();

List<News> findFirst10AllOrderByPtimeDesc();

It always said

Caused by: java.util.NoSuchElementException: null

Can I generate a method to implement this query directly?

edited Jan 10 '18 at 09:06

Jens Schauder

asked Nov 19 '17 at 13:42

M Chen

1

can you share the code which produce this error please? – Youcef LAIDANI Nov 19 '17 at 13:46
You should probably use an extra `By` between your statements – Yassin Hajaj Nov 19 '17 at 13:52
findTop5ByOrderByPtimeDesc – Cepr0 Nov 19 '17 at 13:54
why would a method signature _alone_ be any use to us? we need to see the logic which goes on inside the said method. – Ousmane D. Nov 19 '17 at 13:59
@Aominè because spring-data-jpa can derive queries from method signatures. – JB Nizet Nov 19 '17 at 14:02
@JBNizet I see, good to learn something new eh. ;-) – Ousmane D. Nov 19 '17 at 14:04

0 Answers0