Update a user entity field in JPQL with IN clause
I have a class user where I need to update the loginCount and lastLogin.
Some users have already logged in and updated data, so I want to update there loginCount to 1.
I tried to use JPQL.
I created a query, where I am sending loginCount variable = 1, lastLogin as currentDate and ids as a combination of all ids as CommaSeparatedString.
@Query("update User u set u.loginCount = :loginCount, u.lastLogin = :lastLogin where u.id IN (:ids)")
void updateUserInitialLoginCount(@Param("loginCount") Long loginCount, @Param("lastLogin") Date lastLogin, @Param("ids") String ids);
I want to use 'IN' clause but here I got a problem that by to use IN clause I have to have a comma-delimited-string but my id which I am finding is of type Long.
ERROR:
Parameter value [1,2] did not match expected type [java.lang.Long(n/a)]
Is there a way to resolve this?
java hibernate jpql
asked Nov 15 '18 at 7:10
Sudhanshu GuptaSudhanshu Gupta
75931753
add a comment |
I have a class user where I need to update the loginCount and lastLogin.
Some users have already logged in and updated data, so I want to update there loginCount to 1.
I tried to use JPQL.
I created a query, where I am sending loginCount variable = 1, lastLogin as currentDate and ids as a combination of all ids as CommaSeparatedString.
@Query("update User u set u.loginCount = :loginCount, u.lastLogin = :lastLogin where u.id IN (:ids)")
void updateUserInitialLoginCount(@Param("loginCount") Long loginCount, @Param("lastLogin") Date lastLogin, @Param("ids") String ids);
I want to use 'IN' clause but here I got a problem that by to use IN clause I have to have a comma-delimited-string but my id which I am finding is of type Long.
ERROR:
Parameter value [1,2] did not match expected type [java.lang.Long(n/a)]
Is there a way to resolve this?
java hibernate jpql
asked Nov 15 '18 at 7:10
Sudhanshu GuptaSudhanshu Gupta
75931753
You need to passidsas aList<Long> idsand change the param type ofidsin the method param as well.
– Erfan Ahmed
Nov 15 '18 at 7:16
Thanks Erfan Ahmed Emon
– Sudhanshu Gupta
Nov 15 '18 at 7:41
add a comment |
I have a class user where I need to update the loginCount and lastLogin.
Some users have already logged in and updated data, so I want to update there loginCount to 1.
I tried to use JPQL.
I created a query, where I am sending loginCount variable = 1, lastLogin as currentDate and ids as a combination of all ids as CommaSeparatedString.
@Query("update User u set u.loginCount = :loginCount, u.lastLogin = :lastLogin where u.id IN (:ids)")
void updateUserInitialLoginCount(@Param("loginCount") Long loginCount, @Param("lastLogin") Date lastLogin, @Param("ids") String ids);
I want to use 'IN' clause but here I got a problem that by to use IN clause I have to have a comma-delimited-string but my id which I am finding is of type Long.
ERROR:
Parameter value [1,2] did not match expected type [java.lang.Long(n/a)]
Is there a way to resolve this?
java hibernate jpql
asked Nov 15 '18 at 7:10
Sudhanshu GuptaSudhanshu Gupta
75931753
I have a class user where I need to update the loginCount and lastLogin.
Some users have already logged in and updated data, so I want to update there loginCount to 1.
I tried to use JPQL.
I created a query, where I am sending loginCount variable = 1, lastLogin as currentDate and ids as a combination of all ids as CommaSeparatedString.
@Query("update User u set u.loginCount = :loginCount, u.lastLogin = :lastLogin where u.id IN (:ids)")
void updateUserInitialLoginCount(@Param("loginCount") Long loginCount, @Param("lastLogin") Date lastLogin, @Param("ids") String ids);
I want to use 'IN' clause but here I got a problem that by to use IN clause I have to have a comma-delimited-string but my id which I am finding is of type Long.
ERROR:
Parameter value [1,2] did not match expected type [java.lang.Long(n/a)]
Is there a way to resolve this?
java hibernate jpql
java hibernate jpql
asked Nov 15 '18 at 7:10
Sudhanshu GuptaSudhanshu Gupta
75931753
asked Nov 15 '18 at 7:10
Sudhanshu GuptaSudhanshu Gupta
75931753
asked Nov 15 '18 at 7:10
Sudhanshu GuptaSudhanshu Gupta
75931753
asked Nov 15 '18 at 7:10
Sudhanshu GuptaSudhanshu Gupta
75931753
asked Nov 15 '18 at 7:10
Sudhanshu GuptaSudhanshu Gupta
75931753
75931753
You need to passidsas aList<Long> idsand change the param type ofidsin the method param as well.
– Erfan Ahmed
Nov 15 '18 at 7:16
Thanks Erfan Ahmed Emon
– Sudhanshu Gupta
Nov 15 '18 at 7:41
add a comment |
You need to passidsas aList<Long> idsand change the param type ofidsin the method param as well.
– Erfan Ahmed
Nov 15 '18 at 7:16
Thanks Erfan Ahmed Emon
– Sudhanshu Gupta
Nov 15 '18 at 7:41
You need to pass
ids as a List<Long> ids and change the param type of ids in the method param as well.– Erfan Ahmed
Nov 15 '18 at 7:16
You need to pass
ids as a List<Long> ids and change the param type of ids in the method param as well.– Erfan Ahmed
Nov 15 '18 at 7:16
Thanks Erfan Ahmed Emon
– Sudhanshu Gupta
Nov 15 '18 at 7:41
Thanks Erfan Ahmed Emon
– Sudhanshu Gupta
Nov 15 '18 at 7:41
add a comment |
1 Answer
1
active
oldest
votes
You need to pass list of long as Param for ids instead of String.
@Query("update User u set u.loginCount = :loginCount, u.lastLogin = :lastLogin where u.id IN (:ids)")
void updateUserInitialLoginCount(@Param("loginCount") Long loginCount, @Param("lastLogin") Date lastLogin, @Param("ids") List<Long> ids);
And when you call this method create an array list of Long and add the ids in it and pass as parameter.
answered Nov 15 '18 at 7:14
Pooja AggarwalPooja Aggarwal
870211
Thanks, Pooja, I should have known that. TCH
– Sudhanshu Gupta
Nov 15 '18 at 7:32
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%2f53314135%2fupdate-a-user-entity-field-in-jpql-with-in-clause%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You need to pass list of long as Param for ids instead of String.
@Query("update User u set u.loginCount = :loginCount, u.lastLogin = :lastLogin where u.id IN (:ids)")
void updateUserInitialLoginCount(@Param("loginCount") Long loginCount, @Param("lastLogin") Date lastLogin, @Param("ids") List<Long> ids);
And when you call this method create an array list of Long and add the ids in it and pass as parameter.
answered Nov 15 '18 at 7:14
Pooja AggarwalPooja Aggarwal
870211
Thanks, Pooja, I should have known that. TCH
– Sudhanshu Gupta
Nov 15 '18 at 7:32
add a comment |
You need to pass list of long as Param for ids instead of String.
@Query("update User u set u.loginCount = :loginCount, u.lastLogin = :lastLogin where u.id IN (:ids)")
void updateUserInitialLoginCount(@Param("loginCount") Long loginCount, @Param("lastLogin") Date lastLogin, @Param("ids") List<Long> ids);
And when you call this method create an array list of Long and add the ids in it and pass as parameter.
answered Nov 15 '18 at 7:14
Pooja AggarwalPooja Aggarwal
870211
Thanks, Pooja, I should have known that. TCH
– Sudhanshu Gupta
Nov 15 '18 at 7:32
add a comment |
You need to pass list of long as Param for ids instead of String.
@Query("update User u set u.loginCount = :loginCount, u.lastLogin = :lastLogin where u.id IN (:ids)")
void updateUserInitialLoginCount(@Param("loginCount") Long loginCount, @Param("lastLogin") Date lastLogin, @Param("ids") List<Long> ids);
And when you call this method create an array list of Long and add the ids in it and pass as parameter.
answered Nov 15 '18 at 7:14
Pooja AggarwalPooja Aggarwal
870211
You need to pass list of long as Param for ids instead of String.
@Query("update User u set u.loginCount = :loginCount, u.lastLogin = :lastLogin where u.id IN (:ids)")
void updateUserInitialLoginCount(@Param("loginCount") Long loginCount, @Param("lastLogin") Date lastLogin, @Param("ids") List<Long> ids);
And when you call this method create an array list of Long and add the ids in it and pass as parameter.
answered Nov 15 '18 at 7:14
Pooja AggarwalPooja Aggarwal
870211
answered Nov 15 '18 at 7:14
Pooja AggarwalPooja Aggarwal
870211
answered Nov 15 '18 at 7:14
Pooja AggarwalPooja Aggarwal
870211
answered Nov 15 '18 at 7:14
Pooja AggarwalPooja Aggarwal
870211
870211
Thanks, Pooja, I should have known that. TCH
– Sudhanshu Gupta
Nov 15 '18 at 7:32
add a comment |
Thanks, Pooja, I should have known that. TCH
– Sudhanshu Gupta
Nov 15 '18 at 7:32
Thanks, Pooja, I should have known that. TCH
– Sudhanshu Gupta
Nov 15 '18 at 7:32
Thanks, Pooja, I should have known that. TCH
– Sudhanshu Gupta
Nov 15 '18 at 7:32
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%2f53314135%2fupdate-a-user-entity-field-in-jpql-with-in-clause%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
You need to pass
idsas aList<Long> idsand change the param type ofidsin the method param as well.– Erfan Ahmed
Nov 15 '18 at 7:16
Thanks Erfan Ahmed Emon
– Sudhanshu Gupta
Nov 15 '18 at 7:41