Hibernate JPA - Generate join table in Many-To-Many mapping
I'm trying to map a unidirectional Many-To-Many mapping in a legacy oracle database using Hibernate (within a Spring Boot framework if that makes a difference).
The reading I've done so far seems to suggest that there needs to be a join table in the database, which this DB does not have. Is it possible for Hibernate to create a temporary join table in memory 'on the fly' to fulfil its requirements for the mapping? If so then what are the steps - or if not, then what are the alternatives?
hibernate jpa join spring-data-jpa many-to-many
asked Nov 14 '18 at 22:01
user2521119user2521119
507
add a comment |
I'm trying to map a unidirectional Many-To-Many mapping in a legacy oracle database using Hibernate (within a Spring Boot framework if that makes a difference).
The reading I've done so far seems to suggest that there needs to be a join table in the database, which this DB does not have. Is it possible for Hibernate to create a temporary join table in memory 'on the fly' to fulfil its requirements for the mapping? If so then what are the steps - or if not, then what are the alternatives?
hibernate jpa join spring-data-jpa many-to-many
asked Nov 14 '18 at 22:01
user2521119user2521119
507
1
If the DB does not have a join table then I don't think it is many to many. Are you saying the existing schema does not have it or Oracle doesn't support a join table (not likely). Perhaps you should add the schema.
– K.Nicholas
Nov 15 '18 at 1:30
It definitely is a many-to-many association - Entity A can be associated to multiple Entity Bs, and Entity B can be associated to multiple Entity As. Regarding the schema, the join table doesn't exist and I won't be allowed to add it to the legacy DB, hence my question as to whether hibernate can generate a temporary join table in memory instead..
– user2521119
Nov 15 '18 at 9:38
Good, but your question is still not clear. For JPA in memory temp tables, no, not that I'm aware of, and why would you want a temporary persistence table? Kind of defeats the point doesn't it. In terms of DB stuff you can't do a many-to-many in a RDBMS without a join table. So, like I said, you need to explain your question more clearly or rethink your issue. Hope this helps.
– K.Nicholas
Nov 15 '18 at 16:40
add a comment |
I'm trying to map a unidirectional Many-To-Many mapping in a legacy oracle database using Hibernate (within a Spring Boot framework if that makes a difference).
The reading I've done so far seems to suggest that there needs to be a join table in the database, which this DB does not have. Is it possible for Hibernate to create a temporary join table in memory 'on the fly' to fulfil its requirements for the mapping? If so then what are the steps - or if not, then what are the alternatives?
hibernate jpa join spring-data-jpa many-to-many
asked Nov 14 '18 at 22:01
user2521119user2521119
507
I'm trying to map a unidirectional Many-To-Many mapping in a legacy oracle database using Hibernate (within a Spring Boot framework if that makes a difference).
The reading I've done so far seems to suggest that there needs to be a join table in the database, which this DB does not have. Is it possible for Hibernate to create a temporary join table in memory 'on the fly' to fulfil its requirements for the mapping? If so then what are the steps - or if not, then what are the alternatives?
hibernate jpa join spring-data-jpa many-to-many
hibernate jpa join spring-data-jpa many-to-many
asked Nov 14 '18 at 22:01
user2521119user2521119
507
asked Nov 14 '18 at 22:01
user2521119user2521119
507
asked Nov 14 '18 at 22:01
user2521119user2521119
507
asked Nov 14 '18 at 22:01
user2521119user2521119
507
asked Nov 14 '18 at 22:01
user2521119user2521119
507
507
1
If the DB does not have a join table then I don't think it is many to many. Are you saying the existing schema does not have it or Oracle doesn't support a join table (not likely). Perhaps you should add the schema.
– K.Nicholas
Nov 15 '18 at 1:30
It definitely is a many-to-many association - Entity A can be associated to multiple Entity Bs, and Entity B can be associated to multiple Entity As. Regarding the schema, the join table doesn't exist and I won't be allowed to add it to the legacy DB, hence my question as to whether hibernate can generate a temporary join table in memory instead..
– user2521119
Nov 15 '18 at 9:38
Good, but your question is still not clear. For JPA in memory temp tables, no, not that I'm aware of, and why would you want a temporary persistence table? Kind of defeats the point doesn't it. In terms of DB stuff you can't do a many-to-many in a RDBMS without a join table. So, like I said, you need to explain your question more clearly or rethink your issue. Hope this helps.
– K.Nicholas
Nov 15 '18 at 16:40
add a comment |
1
If the DB does not have a join table then I don't think it is many to many. Are you saying the existing schema does not have it or Oracle doesn't support a join table (not likely). Perhaps you should add the schema.
– K.Nicholas
Nov 15 '18 at 1:30
It definitely is a many-to-many association - Entity A can be associated to multiple Entity Bs, and Entity B can be associated to multiple Entity As. Regarding the schema, the join table doesn't exist and I won't be allowed to add it to the legacy DB, hence my question as to whether hibernate can generate a temporary join table in memory instead..
– user2521119
Nov 15 '18 at 9:38
Good, but your question is still not clear. For JPA in memory temp tables, no, not that I'm aware of, and why would you want a temporary persistence table? Kind of defeats the point doesn't it. In terms of DB stuff you can't do a many-to-many in a RDBMS without a join table. So, like I said, you need to explain your question more clearly or rethink your issue. Hope this helps.
– K.Nicholas
Nov 15 '18 at 16:40
1
1
If the DB does not have a join table then I don't think it is many to many. Are you saying the existing schema does not have it or Oracle doesn't support a join table (not likely). Perhaps you should add the schema.
– K.Nicholas
Nov 15 '18 at 1:30
If the DB does not have a join table then I don't think it is many to many. Are you saying the existing schema does not have it or Oracle doesn't support a join table (not likely). Perhaps you should add the schema.
– K.Nicholas
Nov 15 '18 at 1:30
It definitely is a many-to-many association - Entity A can be associated to multiple Entity Bs, and Entity B can be associated to multiple Entity As. Regarding the schema, the join table doesn't exist and I won't be allowed to add it to the legacy DB, hence my question as to whether hibernate can generate a temporary join table in memory instead..
– user2521119
Nov 15 '18 at 9:38
It definitely is a many-to-many association - Entity A can be associated to multiple Entity Bs, and Entity B can be associated to multiple Entity As. Regarding the schema, the join table doesn't exist and I won't be allowed to add it to the legacy DB, hence my question as to whether hibernate can generate a temporary join table in memory instead..
– user2521119
Nov 15 '18 at 9:38
Good, but your question is still not clear. For JPA in memory temp tables, no, not that I'm aware of, and why would you want a temporary persistence table? Kind of defeats the point doesn't it. In terms of DB stuff you can't do a many-to-many in a RDBMS without a join table. So, like I said, you need to explain your question more clearly or rethink your issue. Hope this helps.
– K.Nicholas
Nov 15 '18 at 16:40
Good, but your question is still not clear. For JPA in memory temp tables, no, not that I'm aware of, and why would you want a temporary persistence table? Kind of defeats the point doesn't it. In terms of DB stuff you can't do a many-to-many in a RDBMS without a join table. So, like I said, you need to explain your question more clearly or rethink your issue. Hope this helps.
– K.Nicholas
Nov 15 '18 at 16:40
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%2f53309381%2fhibernate-jpa-generate-join-table-in-many-to-many-mapping%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%2f53309381%2fhibernate-jpa-generate-join-table-in-many-to-many-mapping%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
1
If the DB does not have a join table then I don't think it is many to many. Are you saying the existing schema does not have it or Oracle doesn't support a join table (not likely). Perhaps you should add the schema.
– K.Nicholas
Nov 15 '18 at 1:30
It definitely is a many-to-many association - Entity A can be associated to multiple Entity Bs, and Entity B can be associated to multiple Entity As. Regarding the schema, the join table doesn't exist and I won't be allowed to add it to the legacy DB, hence my question as to whether hibernate can generate a temporary join table in memory instead..
– user2521119
Nov 15 '18 at 9:38
Good, but your question is still not clear. For JPA in memory temp tables, no, not that I'm aware of, and why would you want a temporary persistence table? Kind of defeats the point doesn't it. In terms of DB stuff you can't do a many-to-many in a RDBMS without a join table. So, like I said, you need to explain your question more clearly or rethink your issue. Hope this helps.
– K.Nicholas
Nov 15 '18 at 16:40