Mixing
Spring Data JPA @Query with foreign key: Parameter not matched
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have a table "Signal" with id, volume and object_id columns.
Object_id is a foreign key. I need to retrieve each signal that has a particular object_id.
Im trying to use this Query
public interface SignalRepository extends JpaRepository<Signal, Integer> {
@Query("select s from Signal s where s.object = ?1")
Optional<List<Signal>> findSignalByObjectId(Integer objectId);
}
It doens't work. If I change "?1" to 1 it gets the hardcoded value. If I try to query the "volume", it works fine.
I get this error:
Blockquote
nested exception is java.lang.IllegalArgumentException: Parameter value [1] did not match expected type
java spring hibernate spring-data-jpa jpql
asked Jan 2 at 22:49
Thadeu Antonio Ferreira MeloThadeu Antonio Ferreira Melo
306414
add a comment |
I have a table "Signal" with id, volume and object_id columns.
Object_id is a foreign key. I need to retrieve each signal that has a particular object_id.
Im trying to use this Query
public interface SignalRepository extends JpaRepository<Signal, Integer> {
@Query("select s from Signal s where s.object = ?1")
Optional<List<Signal>> findSignalByObjectId(Integer objectId);
}
It doens't work. If I change "?1" to 1 it gets the hardcoded value. If I try to query the "volume", it works fine.
I get this error:
Blockquote
nested exception is java.lang.IllegalArgumentException: Parameter value [1] did not match expected type
java spring hibernate spring-data-jpa jpql
asked Jan 2 at 22:49
Thadeu Antonio Ferreira MeloThadeu Antonio Ferreira Melo
306414
add a comment |
I have a table "Signal" with id, volume and object_id columns.
Object_id is a foreign key. I need to retrieve each signal that has a particular object_id.
Im trying to use this Query
public interface SignalRepository extends JpaRepository<Signal, Integer> {
@Query("select s from Signal s where s.object = ?1")
Optional<List<Signal>> findSignalByObjectId(Integer objectId);
}
It doens't work. If I change "?1" to 1 it gets the hardcoded value. If I try to query the "volume", it works fine.
I get this error:
Blockquote
nested exception is java.lang.IllegalArgumentException: Parameter value [1] did not match expected type
java spring hibernate spring-data-jpa jpql
asked Jan 2 at 22:49
Thadeu Antonio Ferreira MeloThadeu Antonio Ferreira Melo
306414
I have a table "Signal" with id, volume and object_id columns.
Object_id is a foreign key. I need to retrieve each signal that has a particular object_id.
Im trying to use this Query
public interface SignalRepository extends JpaRepository<Signal, Integer> {
@Query("select s from Signal s where s.object = ?1")
Optional<List<Signal>> findSignalByObjectId(Integer objectId);
}
It doens't work. If I change "?1" to 1 it gets the hardcoded value. If I try to query the "volume", it works fine.
I get this error:
Blockquote
nested exception is java.lang.IllegalArgumentException: Parameter value [1] did not match expected type
java spring hibernate spring-data-jpa jpql
java spring hibernate spring-data-jpa jpql
asked Jan 2 at 22:49
Thadeu Antonio Ferreira MeloThadeu Antonio Ferreira Melo
306414
asked Jan 2 at 22:49
Thadeu Antonio Ferreira MeloThadeu Antonio Ferreira Melo
306414
edited Jan 3 at 7:25
user3973283
asked Jan 2 at 22:49
Thadeu Antonio Ferreira MeloThadeu Antonio Ferreira Melo
306414
asked Jan 2 at 22:49
Thadeu Antonio Ferreira MeloThadeu Antonio Ferreira Melo
306414
asked Jan 2 at 22:49
Thadeu Antonio Ferreira MeloThadeu Antonio Ferreira Melo
306414
306414
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
You can use Spring data to generate the underlying query like this :
public interface SignalRepository extends JpaRepository<Signal, Integer> {
List<Signal> findSignalByObjectId(Integer objectId);
}
or you can write the query with this return type and parameter:
public interface SignalRepository extends JpaRepository<Signal, Integer> {
@Query("select s from Signal s where s.object = :id")
List<Signal> findSignalByObjectId(@Param("id") Integer objectId);
}
answered Jan 2 at 23:12
Gaurav AgarwalGaurav Agarwal
11319
Thank you. It works perfectly.
– Thadeu Antonio Ferreira Melo
Jan 3 at 19:31
Sure, happy to help, would be really great, if you mark it as accepted answer
– Gaurav Agarwal
Jan 4 at 20:23
add a comment |
I'd recommend you omit the query and let spring data generate one for you. So your case may be represented somehow like that (in case of proper relation mapping defined):
public interface SignalRepository extends JpaRepository<Signal, Integer> {
Optional<Signal> findByObject(YourObjectType object);
}
If you provide more info e.g. your entities - you can get more help.
answered Jan 2 at 23:06
Anton HlinistyAnton Hlinisty
98611324
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%2f54014183%2fspring-data-jpa-query-with-foreign-key-parameter-not-matched%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
You can use Spring data to generate the underlying query like this :
public interface SignalRepository extends JpaRepository<Signal, Integer> {
List<Signal> findSignalByObjectId(Integer objectId);
}
or you can write the query with this return type and parameter:
public interface SignalRepository extends JpaRepository<Signal, Integer> {
@Query("select s from Signal s where s.object = :id")
List<Signal> findSignalByObjectId(@Param("id") Integer objectId);
}
answered Jan 2 at 23:12
Gaurav AgarwalGaurav Agarwal
11319
Thank you. It works perfectly.
– Thadeu Antonio Ferreira Melo
Jan 3 at 19:31
Sure, happy to help, would be really great, if you mark it as accepted answer
– Gaurav Agarwal
Jan 4 at 20:23
add a comment |
You can use Spring data to generate the underlying query like this :
public interface SignalRepository extends JpaRepository<Signal, Integer> {
List<Signal> findSignalByObjectId(Integer objectId);
}
or you can write the query with this return type and parameter:
public interface SignalRepository extends JpaRepository<Signal, Integer> {
@Query("select s from Signal s where s.object = :id")
List<Signal> findSignalByObjectId(@Param("id") Integer objectId);
}
answered Jan 2 at 23:12
Gaurav AgarwalGaurav Agarwal
11319
Thank you. It works perfectly.
– Thadeu Antonio Ferreira Melo
Jan 3 at 19:31
Sure, happy to help, would be really great, if you mark it as accepted answer
– Gaurav Agarwal
Jan 4 at 20:23
add a comment |
You can use Spring data to generate the underlying query like this :
public interface SignalRepository extends JpaRepository<Signal, Integer> {
List<Signal> findSignalByObjectId(Integer objectId);
}
or you can write the query with this return type and parameter:
public interface SignalRepository extends JpaRepository<Signal, Integer> {
@Query("select s from Signal s where s.object = :id")
List<Signal> findSignalByObjectId(@Param("id") Integer objectId);
}
answered Jan 2 at 23:12
Gaurav AgarwalGaurav Agarwal
11319
You can use Spring data to generate the underlying query like this :
public interface SignalRepository extends JpaRepository<Signal, Integer> {
List<Signal> findSignalByObjectId(Integer objectId);
}
or you can write the query with this return type and parameter:
public interface SignalRepository extends JpaRepository<Signal, Integer> {
@Query("select s from Signal s where s.object = :id")
List<Signal> findSignalByObjectId(@Param("id") Integer objectId);
}
answered Jan 2 at 23:12
Gaurav AgarwalGaurav Agarwal
11319
answered Jan 2 at 23:12
Gaurav AgarwalGaurav Agarwal
11319
answered Jan 2 at 23:12
Gaurav AgarwalGaurav Agarwal
11319
answered Jan 2 at 23:12
Gaurav AgarwalGaurav Agarwal
11319
11319
Thank you. It works perfectly.
– Thadeu Antonio Ferreira Melo
Jan 3 at 19:31
Sure, happy to help, would be really great, if you mark it as accepted answer
– Gaurav Agarwal
Jan 4 at 20:23
add a comment |
Thank you. It works perfectly.
– Thadeu Antonio Ferreira Melo
Jan 3 at 19:31
Sure, happy to help, would be really great, if you mark it as accepted answer
– Gaurav Agarwal
Jan 4 at 20:23
Thank you. It works perfectly.
– Thadeu Antonio Ferreira Melo
Jan 3 at 19:31
Thank you. It works perfectly.
– Thadeu Antonio Ferreira Melo
Jan 3 at 19:31
Sure, happy to help, would be really great, if you mark it as accepted answer
– Gaurav Agarwal
Jan 4 at 20:23
Sure, happy to help, would be really great, if you mark it as accepted answer
– Gaurav Agarwal
Jan 4 at 20:23
add a comment |
I'd recommend you omit the query and let spring data generate one for you. So your case may be represented somehow like that (in case of proper relation mapping defined):
public interface SignalRepository extends JpaRepository<Signal, Integer> {
Optional<Signal> findByObject(YourObjectType object);
}
If you provide more info e.g. your entities - you can get more help.
answered Jan 2 at 23:06
Anton HlinistyAnton Hlinisty
98611324
add a comment |
I'd recommend you omit the query and let spring data generate one for you. So your case may be represented somehow like that (in case of proper relation mapping defined):
public interface SignalRepository extends JpaRepository<Signal, Integer> {
Optional<Signal> findByObject(YourObjectType object);
}
If you provide more info e.g. your entities - you can get more help.
answered Jan 2 at 23:06
Anton HlinistyAnton Hlinisty
98611324
add a comment |
I'd recommend you omit the query and let spring data generate one for you. So your case may be represented somehow like that (in case of proper relation mapping defined):
public interface SignalRepository extends JpaRepository<Signal, Integer> {
Optional<Signal> findByObject(YourObjectType object);
}
If you provide more info e.g. your entities - you can get more help.
answered Jan 2 at 23:06
Anton HlinistyAnton Hlinisty
98611324
I'd recommend you omit the query and let spring data generate one for you. So your case may be represented somehow like that (in case of proper relation mapping defined):
public interface SignalRepository extends JpaRepository<Signal, Integer> {
Optional<Signal> findByObject(YourObjectType object);
}
If you provide more info e.g. your entities - you can get more help.
answered Jan 2 at 23:06
Anton HlinistyAnton Hlinisty
98611324
answered Jan 2 at 23:06
Anton HlinistyAnton Hlinisty
98611324
answered Jan 2 at 23:06
Anton HlinistyAnton Hlinisty
98611324
answered Jan 2 at 23:06
Anton HlinistyAnton Hlinisty
98611324
98611324
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%2f54014183%2fspring-data-jpa-query-with-foreign-key-parameter-not-matched%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
