JpaSort.unsafe throwing Exception

Question

Using Spring Boot and Spring Data. Using JpaSort.unsafe but getting Exception. Is this a known Spring issue? Hibernate/JPA issue? Thanks.

Maven:

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.0.5.RELEASE</version>
</parent>

Entity:

public class Simple {
    @Id
    private Long id;
    private String firstName;
    ...
}

Repository method:

public List<Simple> findAll(Sort sort);

SpringTestClass:

    list = simpleRepository.findAll(JpaSort.unsafe("LENGTH(firstName)"));
    assertEquals("firstName", list.get(0).getFirstName());

Exception:

org.springframework.data.mapping.PropertyReferenceException: No property LENGTH(firstName) found for type Simple!

score 3 · Accepted Answer · answered Nov 25 '18 at 20:46

3

In my case, adding @Query to repository class method helps solve this issue. I don't understand why. You can try if it helps you

@Query("SELECT s FROM Simple s")

answered Nov 25 '18 at 20:46

inv

46
1
4

save me hours+! – softwarevamp Apr 27 '20 at 03:27
This is not worked with specifications: https://stackoverflow.com/questions/26379522/can-i-combine-a-query-definition-with-a-specification-in-a-spring-data-jpa-repo – Дима Годиков Apr 07 '22 at 14:02

score 1 · Answer 2 · answered Feb 15 '19 at 21:03

1

This post here says you have to put parentheses around the string you are passing in. Maybe it applies here.

How to sort projection by alias from SELECT clause in Spring Data JPA with pagination?

answered Feb 15 '19 at 21:03

awhig

507
1
7
13

JpaSort.unsafe throwing Exception

2 Answers2