JpaSort.unsafe throwing Exception
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!
hibernate spring-boot spring-data
edited Sep 23 '18 at 16:45
M. Deinum
70k13141150
asked Sep 23 '18 at 11:40
Oliver ChuaOliver Chua
33
add a comment |
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!
hibernate spring-boot spring-data
edited Sep 23 '18 at 16:45
M. Deinum
70k13141150
asked Sep 23 '18 at 11:40
Oliver ChuaOliver Chua
33
add a comment |
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!
hibernate spring-boot spring-data
edited Sep 23 '18 at 16:45
M. Deinum
70k13141150
asked Sep 23 '18 at 11:40
Oliver ChuaOliver Chua
33
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!
hibernate spring-boot spring-data
hibernate spring-boot spring-data
edited Sep 23 '18 at 16:45
M. Deinum
70k13141150
asked Sep 23 '18 at 11:40
Oliver ChuaOliver Chua
33
edited Sep 23 '18 at 16:45
M. Deinum
70k13141150
asked Sep 23 '18 at 11:40
Oliver ChuaOliver Chua
33
edited Sep 23 '18 at 16:45
M. Deinum
70k13141150
edited Sep 23 '18 at 16:45
M. Deinum
70k13141150
edited Sep 23 '18 at 16:45
M. Deinum
70k13141150
70k13141150
asked Sep 23 '18 at 11:40
Oliver ChuaOliver Chua
33
asked Sep 23 '18 at 11:40
Oliver ChuaOliver Chua
33
asked Sep 23 '18 at 11:40
Oliver ChuaOliver Chua
33
33
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
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
invinv
161
Nice work. Worked for me as well.
– Oliver Chua
Nov 27 '18 at 22:52
add a comment |
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 at 21:03
awhigawhig
1101310
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f52465748%2fjpasort-unsafe-throwing-exception%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
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
invinv
161
Nice work. Worked for me as well.
– Oliver Chua
Nov 27 '18 at 22:52
add a comment |
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
invinv
161
Nice work. Worked for me as well.
– Oliver Chua
Nov 27 '18 at 22:52
add a comment |
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
invinv
161
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
invinv
161
answered Nov 25 '18 at 20:46
invinv
161
answered Nov 25 '18 at 20:46
invinv
161
answered Nov 25 '18 at 20:46
invinv
161
161
Nice work. Worked for me as well.
– Oliver Chua
Nov 27 '18 at 22:52
add a comment |
Nice work. Worked for me as well.
– Oliver Chua
Nov 27 '18 at 22:52
Nice work. Worked for me as well.
– Oliver Chua
Nov 27 '18 at 22:52
Nice work. Worked for me as well.
– Oliver Chua
Nov 27 '18 at 22:52
add a comment |
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 at 21:03
awhigawhig
1101310
add a comment |
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 at 21:03
awhigawhig
1101310
add a comment |
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 at 21:03
awhigawhig
1101310
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 at 21:03
awhigawhig
1101310
answered Feb 15 at 21:03
awhigawhig
1101310
answered Feb 15 at 21:03
awhigawhig
1101310
answered Feb 15 at 21:03
awhigawhig
1101310
1101310
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f52465748%2fjpasort-unsafe-throwing-exception%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
