How to map a native query, that has more columns than a table?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
I have a class with 4 fields, a table with 2 columns and a native query, that return 4 columns.
let's say:
a class:
class Foo{
int id;
String name;
int stat;
String statName;
}
a table:
foo
---------
id | name
and mapping:
<class name="Foo" table="foo">
<id name=id/>
<property name="name"/>
<property name="stat"/>
<property name="statName"/>
</class>
<sql-query name="getWithStat">
<return class="Foo"/>
<!--stat and statName calculated as aggregation and concatenation from other table-->
</sql-query>
But with this mapping, I can't use basic entity, because table hasn't columns for stat and statName. How shoul I map this extra fields from my query into my class?
java hibernate xml-configuration
asked Nov 23 '18 at 13:53
TEXHIKTEXHIK
8001527
add a comment |
0
I have a class with 4 fields, a table with 2 columns and a native query, that return 4 columns.
let's say:
a class:
class Foo{
int id;
String name;
int stat;
String statName;
}
a table:
foo
---------
id | name
and mapping:
<class name="Foo" table="foo">
<id name=id/>
<property name="name"/>
<property name="stat"/>
<property name="statName"/>
</class>
<sql-query name="getWithStat">
<return class="Foo"/>
<!--stat and statName calculated as aggregation and concatenation from other table-->
</sql-query>
But with this mapping, I can't use basic entity, because table hasn't columns for stat and statName. How shoul I map this extra fields from my query into my class?
java hibernate xml-configuration
asked Nov 23 '18 at 13:53
TEXHIKTEXHIK
8001527
Is stat and statName field from other entity classes?
– Pooja Aggarwal
Nov 23 '18 at 14:05
@PoojaAggarwal no, it's calculated in query (some concatenation and aggregation of fields from other table).
– TEXHIK
Nov 23 '18 at 14:06
add a comment |
0
0
0
I have a class with 4 fields, a table with 2 columns and a native query, that return 4 columns.
let's say:
a class:
class Foo{
int id;
String name;
int stat;
String statName;
}
a table:
foo
---------
id | name
and mapping:
<class name="Foo" table="foo">
<id name=id/>
<property name="name"/>
<property name="stat"/>
<property name="statName"/>
</class>
<sql-query name="getWithStat">
<return class="Foo"/>
<!--stat and statName calculated as aggregation and concatenation from other table-->
</sql-query>
But with this mapping, I can't use basic entity, because table hasn't columns for stat and statName. How shoul I map this extra fields from my query into my class?
java hibernate xml-configuration
asked Nov 23 '18 at 13:53
TEXHIKTEXHIK
8001527
I have a class with 4 fields, a table with 2 columns and a native query, that return 4 columns.
let's say:
a class:
class Foo{
int id;
String name;
int stat;
String statName;
}
a table:
foo
---------
id | name
and mapping:
<class name="Foo" table="foo">
<id name=id/>
<property name="name"/>
<property name="stat"/>
<property name="statName"/>
</class>
<sql-query name="getWithStat">
<return class="Foo"/>
<!--stat and statName calculated as aggregation and concatenation from other table-->
</sql-query>
But with this mapping, I can't use basic entity, because table hasn't columns for stat and statName. How shoul I map this extra fields from my query into my class?
java hibernate xml-configuration
java hibernate xml-configuration
asked Nov 23 '18 at 13:53
TEXHIKTEXHIK
8001527
asked Nov 23 '18 at 13:53
TEXHIKTEXHIK
8001527
edited Nov 23 '18 at 14:09
TEXHIK
asked Nov 23 '18 at 13:53
TEXHIKTEXHIK
8001527
asked Nov 23 '18 at 13:53
TEXHIKTEXHIK
8001527
asked Nov 23 '18 at 13:53
TEXHIKTEXHIK
8001527
8001527
Is stat and statName field from other entity classes?
– Pooja Aggarwal
Nov 23 '18 at 14:05
@PoojaAggarwal no, it's calculated in query (some concatenation and aggregation of fields from other table).
– TEXHIK
Nov 23 '18 at 14:06
add a comment |
Is stat and statName field from other entity classes?
– Pooja Aggarwal
Nov 23 '18 at 14:05
@PoojaAggarwal no, it's calculated in query (some concatenation and aggregation of fields from other table).
– TEXHIK
Nov 23 '18 at 14:06
Is stat and statName field from other entity classes?
– Pooja Aggarwal
Nov 23 '18 at 14:05
Is stat and statName field from other entity classes?
– Pooja Aggarwal
Nov 23 '18 at 14:05
@PoojaAggarwal no, it's calculated in query (some concatenation and aggregation of fields from other table).
– TEXHIK
Nov 23 '18 at 14:06
@PoojaAggarwal no, it's calculated in query (some concatenation and aggregation of fields from other table).
– TEXHIK
Nov 23 '18 at 14:06
add a comment |
1 Answer
1
active
oldest
votes
1
you can use Transient annotation of JPA to ignore property at time of persist.
class Foo{
int id;
String name;
@Transient
int stat;
@Transient
String statName;
}
answered Nov 23 '18 at 14:10
samjisamji
265
But it is not transient, I want result from my query to be mapped there. However, I don't want this properties to be mapped when persisting or getting an entity from the table (because they are not exist there)
– TEXHIK
Nov 23 '18 at 14:14
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
});
}
});
draft saved
draft discarded
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%2f53447981%2fhow-to-map-a-native-query-that-has-more-columns-than-a-table%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
1
you can use Transient annotation of JPA to ignore property at time of persist.
class Foo{
int id;
String name;
@Transient
int stat;
@Transient
String statName;
}
answered Nov 23 '18 at 14:10
samjisamji
265
But it is not transient, I want result from my query to be mapped there. However, I don't want this properties to be mapped when persisting or getting an entity from the table (because they are not exist there)
– TEXHIK
Nov 23 '18 at 14:14
add a comment |
1
you can use Transient annotation of JPA to ignore property at time of persist.
class Foo{
int id;
String name;
@Transient
int stat;
@Transient
String statName;
}
answered Nov 23 '18 at 14:10
samjisamji
265
But it is not transient, I want result from my query to be mapped there. However, I don't want this properties to be mapped when persisting or getting an entity from the table (because they are not exist there)
– TEXHIK
Nov 23 '18 at 14:14
add a comment |
1
1
1
you can use Transient annotation of JPA to ignore property at time of persist.
class Foo{
int id;
String name;
@Transient
int stat;
@Transient
String statName;
}
answered Nov 23 '18 at 14:10
samjisamji
265
you can use Transient annotation of JPA to ignore property at time of persist.
class Foo{
int id;
String name;
@Transient
int stat;
@Transient
String statName;
}
answered Nov 23 '18 at 14:10
samjisamji
265
answered Nov 23 '18 at 14:10
samjisamji
265
answered Nov 23 '18 at 14:10
samjisamji
265
answered Nov 23 '18 at 14:10
samjisamji
265
265
But it is not transient, I want result from my query to be mapped there. However, I don't want this properties to be mapped when persisting or getting an entity from the table (because they are not exist there)
– TEXHIK
Nov 23 '18 at 14:14
add a comment |
But it is not transient, I want result from my query to be mapped there. However, I don't want this properties to be mapped when persisting or getting an entity from the table (because they are not exist there)
– TEXHIK
Nov 23 '18 at 14:14
But it is not transient, I want result from my query to be mapped there. However, I don't want this properties to be mapped when persisting or getting an entity from the table (because they are not exist there)
– TEXHIK
Nov 23 '18 at 14:14
But it is not transient, I want result from my query to be mapped there. However, I don't want this properties to be mapped when persisting or getting an entity from the table (because they are not exist there)
– TEXHIK
Nov 23 '18 at 14:14
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53447981%2fhow-to-map-a-native-query-that-has-more-columns-than-a-table%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
Is stat and statName field from other entity classes?
– Pooja Aggarwal
Nov 23 '18 at 14:05
@PoojaAggarwal no, it's calculated in query (some concatenation and aggregation of fields from other table).
– TEXHIK
Nov 23 '18 at 14:06