facing problem in executing hibernate query for Mssql server
i am facing problem when i run my hibernate query for Mssql server
this is the hibernate query:
select max(this_.created) as y0_,
this_.who_entity as y1_,
this_.what_entity as y2_,
this_.who_id as y3_,
this_.what_id as y4_,
this_.action as y5_,
this_.donotdisplay as y6_,
this_.created as y7_
from Activity this_
where :Tenant_Security.current_tenant=this_.tenant_id
and this_.deleted=0
and (this_.donotdisplay is NULL
and this_.action is not null)
GROUP by this_.created order by this_.created desc
And the error which i am facing is:
Column 'Activity.who_entity' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
previously this was working in Mysql but Now i trying to execute in Mssql server its not working.can anybody help me out this.
thank you.
sql-server hibernate edited Nov 23 '18 at 8:24
Larnu
18k41731
asked Nov 23 '18 at 8:21
learnerlearner
103
add a comment |
i am facing problem when i run my hibernate query for Mssql server
this is the hibernate query:
select max(this_.created) as y0_,
this_.who_entity as y1_,
this_.what_entity as y2_,
this_.who_id as y3_,
this_.what_id as y4_,
this_.action as y5_,
this_.donotdisplay as y6_,
this_.created as y7_
from Activity this_
where :Tenant_Security.current_tenant=this_.tenant_id
and this_.deleted=0
and (this_.donotdisplay is NULL
and this_.action is not null)
GROUP by this_.created order by this_.created desc
And the error which i am facing is:
Column 'Activity.who_entity' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
previously this was working in Mysql but Now i trying to execute in Mssql server its not working.can anybody help me out this.
thank you.
sql-server hibernate edited Nov 23 '18 at 8:24
Larnu
18k41731
asked Nov 23 '18 at 8:21
learnerlearner
103
3
YourGROUP BYis on the only column that has an aggregate on it; that doesn't make any sense. The error is telling you the problem here, so what about it is it you don't understand? P.s. Good use of white space makes your query infinitely easier to read. Writing queries on a single line, without indentation, should be avoided, unless the query is incredibly simple (LIkeSELECT [column] FROM [table]).
– Larnu
Nov 23 '18 at 8:25
add a comment |
i am facing problem when i run my hibernate query for Mssql server
this is the hibernate query:
select max(this_.created) as y0_,
this_.who_entity as y1_,
this_.what_entity as y2_,
this_.who_id as y3_,
this_.what_id as y4_,
this_.action as y5_,
this_.donotdisplay as y6_,
this_.created as y7_
from Activity this_
where :Tenant_Security.current_tenant=this_.tenant_id
and this_.deleted=0
and (this_.donotdisplay is NULL
and this_.action is not null)
GROUP by this_.created order by this_.created desc
And the error which i am facing is:
Column 'Activity.who_entity' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
previously this was working in Mysql but Now i trying to execute in Mssql server its not working.can anybody help me out this.
thank you.
sql-server hibernate edited Nov 23 '18 at 8:24
Larnu
18k41731
asked Nov 23 '18 at 8:21
learnerlearner
103
i am facing problem when i run my hibernate query for Mssql server
this is the hibernate query:
select max(this_.created) as y0_,
this_.who_entity as y1_,
this_.what_entity as y2_,
this_.who_id as y3_,
this_.what_id as y4_,
this_.action as y5_,
this_.donotdisplay as y6_,
this_.created as y7_
from Activity this_
where :Tenant_Security.current_tenant=this_.tenant_id
and this_.deleted=0
and (this_.donotdisplay is NULL
and this_.action is not null)
GROUP by this_.created order by this_.created desc
And the error which i am facing is:
Column 'Activity.who_entity' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
previously this was working in Mysql but Now i trying to execute in Mssql server its not working.can anybody help me out this.
thank you.
sql-server hibernate sql-server hibernate edited Nov 23 '18 at 8:24
Larnu
18k41731
asked Nov 23 '18 at 8:21
learnerlearner
103
edited Nov 23 '18 at 8:24
Larnu
18k41731
asked Nov 23 '18 at 8:21
learnerlearner
103
edited Nov 23 '18 at 8:24
Larnu
18k41731
edited Nov 23 '18 at 8:24
Larnu
18k41731
edited Nov 23 '18 at 8:24
Larnu
18k41731
18k41731
asked Nov 23 '18 at 8:21
learnerlearner
103
asked Nov 23 '18 at 8:21
learnerlearner
103
asked Nov 23 '18 at 8:21
learnerlearner
103
103
3
YourGROUP BYis on the only column that has an aggregate on it; that doesn't make any sense. The error is telling you the problem here, so what about it is it you don't understand? P.s. Good use of white space makes your query infinitely easier to read. Writing queries on a single line, without indentation, should be avoided, unless the query is incredibly simple (LIkeSELECT [column] FROM [table]).
– Larnu
Nov 23 '18 at 8:25
add a comment |
3
YourGROUP BYis on the only column that has an aggregate on it; that doesn't make any sense. The error is telling you the problem here, so what about it is it you don't understand? P.s. Good use of white space makes your query infinitely easier to read. Writing queries on a single line, without indentation, should be avoided, unless the query is incredibly simple (LIkeSELECT [column] FROM [table]).
– Larnu
Nov 23 '18 at 8:25
3
3
Your
GROUP BY is on the only column that has an aggregate on it; that doesn't make any sense. The error is telling you the problem here, so what about it is it you don't understand? P.s. Good use of white space makes your query infinitely easier to read. Writing queries on a single line, without indentation, should be avoided, unless the query is incredibly simple (LIke SELECT [column] FROM [table]).– Larnu
Nov 23 '18 at 8:25
Your
GROUP BY is on the only column that has an aggregate on it; that doesn't make any sense. The error is telling you the problem here, so what about it is it you don't understand? P.s. Good use of white space makes your query infinitely easier to read. Writing queries on a single line, without indentation, should be avoided, unless the query is incredibly simple (LIke SELECT [column] FROM [table]).– Larnu
Nov 23 '18 at 8:25
add a comment |
0
active
oldest
votes
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%2f53442939%2ffacing-problem-in-executing-hibernate-query-for-mssql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53442939%2ffacing-problem-in-executing-hibernate-query-for-mssql-server%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
3
Your
GROUP BYis on the only column that has an aggregate on it; that doesn't make any sense. The error is telling you the problem here, so what about it is it you don't understand? P.s. Good use of white space makes your query infinitely easier to read. Writing queries on a single line, without indentation, should be avoided, unless the query is incredibly simple (LIkeSELECT [column] FROM [table]).– Larnu
Nov 23 '18 at 8:25