Hibernate - how to remove redundant columns in an assossiation table
0
I have two entities: Intersection and Agent.
- An intersection has an id and a set of agents;
- An agent has a composite id compound by the intersection id and the agent id;
The generated table intersection_agents has tree columns: intersection_id, agents_agents_id and agents_intersection_id.
The intersection_id and agents_intersection_id are redudant. Which is the proper way to remove this redundancy?
EDIT 1:
Intersection.java
@Entity
public class Intersecion
@Id
private String id;
@OneToMay
private Set<Agent> agents;
...
Agent.java
@Entity
public class Agent
@EmbbededId
private PrimaryKey key;
@Embeddable
public static class PrimaryKey
String intersectionId;
Long agentId;
java mysql hibernate
asked Nov 14 '18 at 21:07
Hugo SartoriHugo Sartori
9910
add a comment |
0
I have two entities: Intersection and Agent.
- An intersection has an id and a set of agents;
- An agent has a composite id compound by the intersection id and the agent id;
The generated table intersection_agents has tree columns: intersection_id, agents_agents_id and agents_intersection_id.
The intersection_id and agents_intersection_id are redudant. Which is the proper way to remove this redundancy?
EDIT 1:
Intersection.java
@Entity
public class Intersecion
@Id
private String id;
@OneToMay
private Set<Agent> agents;
...
Agent.java
@Entity
public class Agent
@EmbbededId
private PrimaryKey key;
@Embeddable
public static class PrimaryKey
String intersectionId;
Long agentId;
java mysql hibernate
asked Nov 14 '18 at 21:07
Hugo SartoriHugo Sartori
9910
It does not seem that you really need intersection_agents table, because that mapping incapsulated in agent id. Provide your entities, plz.
– Aleksandr Semyannikov
Nov 15 '18 at 12:00
Edited. OBS: Don't know if it matters, but, the id's aren't autogenerated because is important for the user to recognize intersections and agents just looking at the id (for use on external systems).
– Hugo Sartori
Nov 15 '18 at 22:26
add a comment |
0
0
0
I have two entities: Intersection and Agent.
- An intersection has an id and a set of agents;
- An agent has a composite id compound by the intersection id and the agent id;
The generated table intersection_agents has tree columns: intersection_id, agents_agents_id and agents_intersection_id.
The intersection_id and agents_intersection_id are redudant. Which is the proper way to remove this redundancy?
EDIT 1:
Intersection.java
@Entity
public class Intersecion
@Id
private String id;
@OneToMay
private Set<Agent> agents;
...
Agent.java
@Entity
public class Agent
@EmbbededId
private PrimaryKey key;
@Embeddable
public static class PrimaryKey
String intersectionId;
Long agentId;
java mysql hibernate
asked Nov 14 '18 at 21:07
Hugo SartoriHugo Sartori
9910
I have two entities: Intersection and Agent.
- An intersection has an id and a set of agents;
- An agent has a composite id compound by the intersection id and the agent id;
The generated table intersection_agents has tree columns: intersection_id, agents_agents_id and agents_intersection_id.
The intersection_id and agents_intersection_id are redudant. Which is the proper way to remove this redundancy?
EDIT 1:
Intersection.java
@Entity
public class Intersecion
@Id
private String id;
@OneToMay
private Set<Agent> agents;
...
Agent.java
@Entity
public class Agent
@EmbbededId
private PrimaryKey key;
@Embeddable
public static class PrimaryKey
String intersectionId;
Long agentId;
java mysql hibernate
java mysql hibernate
asked Nov 14 '18 at 21:07
Hugo SartoriHugo Sartori
9910
asked Nov 14 '18 at 21:07
Hugo SartoriHugo Sartori
9910
edited Nov 15 '18 at 22:21
Hugo Sartori
asked Nov 14 '18 at 21:07
Hugo SartoriHugo Sartori
9910
asked Nov 14 '18 at 21:07
Hugo SartoriHugo Sartori
9910
asked Nov 14 '18 at 21:07
Hugo SartoriHugo Sartori
9910
9910
It does not seem that you really need intersection_agents table, because that mapping incapsulated in agent id. Provide your entities, plz.
– Aleksandr Semyannikov
Nov 15 '18 at 12:00
Edited. OBS: Don't know if it matters, but, the id's aren't autogenerated because is important for the user to recognize intersections and agents just looking at the id (for use on external systems).
– Hugo Sartori
Nov 15 '18 at 22:26
add a comment |
It does not seem that you really need intersection_agents table, because that mapping incapsulated in agent id. Provide your entities, plz.
– Aleksandr Semyannikov
Nov 15 '18 at 12:00
Edited. OBS: Don't know if it matters, but, the id's aren't autogenerated because is important for the user to recognize intersections and agents just looking at the id (for use on external systems).
– Hugo Sartori
Nov 15 '18 at 22:26
It does not seem that you really need intersection_agents table, because that mapping incapsulated in agent id. Provide your entities, plz.
– Aleksandr Semyannikov
Nov 15 '18 at 12:00
It does not seem that you really need intersection_agents table, because that mapping incapsulated in agent id. Provide your entities, plz.
– Aleksandr Semyannikov
Nov 15 '18 at 12:00
Edited. OBS: Don't know if it matters, but, the id's aren't autogenerated because is important for the user to recognize intersections and agents just looking at the id (for use on external systems).
– Hugo Sartori
Nov 15 '18 at 22:26
Edited. OBS: Don't know if it matters, but, the id's aren't autogenerated because is important for the user to recognize intersections and agents just looking at the id (for use on external systems).
– Hugo Sartori
Nov 15 '18 at 22:26
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
);
);
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%2f53308728%2fhibernate-how-to-remove-redundant-columns-in-an-assossiation-table%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
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%2f53308728%2fhibernate-how-to-remove-redundant-columns-in-an-assossiation-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
It does not seem that you really need intersection_agents table, because that mapping incapsulated in agent id. Provide your entities, plz.
– Aleksandr Semyannikov
Nov 15 '18 at 12:00
Edited. OBS: Don't know if it matters, but, the id's aren't autogenerated because is important for the user to recognize intersections and agents just looking at the id (for use on external systems).
– Hugo Sartori
Nov 15 '18 at 22:26