How create a constraint with Hibernate?
up vote
0
down vote
favorite
How can I create a constraint with Hibernate? I'm mapping two classes, "Team" and "Match", but I want that a match JUST can happens if the teams are from the same League. The way that I'm doing right now I can create a match with teams from differents leagues (which isn't interesting in this case).
Is there some annotation that "wraps" my teams, home and away, just being from one league? Or I have to do this in my system?
Thanks.
@Table(name = "match")
@Entity
public class Match implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
@ManyToOne
@JoinColumn(name = "id_league")
private League league;
@ManyToOne
@JoinColumn(name = "id_home", referencedColumnName="id")
private Team home;
@ManyToOne
@JoinColumn(name = "id_away", referencedColumnName="id")
private Team away;
@Column
private Integer goalsHome;
@Column
private Integer goalsAway;
@Temporal(value = TemporalType.DATE)
private Date matchDate;
and
@Table(name="team")
@Entity
public class Team implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
@Column(length = 55)
private String name;
@ManyToOne
@JoinColumn(name = "id_league")
private League league;
@OneToMany
private List<Match> match;
java hibernate
|
show 6 more comments
up vote
0
down vote
favorite
How can I create a constraint with Hibernate? I'm mapping two classes, "Team" and "Match", but I want that a match JUST can happens if the teams are from the same League. The way that I'm doing right now I can create a match with teams from differents leagues (which isn't interesting in this case).
Is there some annotation that "wraps" my teams, home and away, just being from one league? Or I have to do this in my system?
Thanks.
@Table(name = "match")
@Entity
public class Match implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
@ManyToOne
@JoinColumn(name = "id_league")
private League league;
@ManyToOne
@JoinColumn(name = "id_home", referencedColumnName="id")
private Team home;
@ManyToOne
@JoinColumn(name = "id_away", referencedColumnName="id")
private Team away;
@Column
private Integer goalsHome;
@Column
private Integer goalsAway;
@Temporal(value = TemporalType.DATE)
private Date matchDate;
and
@Table(name="team")
@Entity
public class Team implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
@Column(length = 55)
private String name;
@ManyToOne
@JoinColumn(name = "id_league")
private League league;
@OneToMany
private List<Match> match;
java hibernate
do you mean like aJOIN
?
– Scary Wombat
Nov 20 at 1:02
@TimBiegeleisen Actually, I translated my classes wrong. Now it's correct, thanks.
– Hawk
Nov 20 at 1:08
@ScaryWombat but join isn't used only for consults?
– Hawk
Nov 20 at 1:08
Sorry I have no idea what you are meaning. Can you show what you want by making SQL?
– Scary Wombat
Nov 20 at 1:11
Is a league associated with a team, or with a match? I think it should only be associated with a team, so removeLeague
from yourMatch
entity.
– Tim Biegeleisen
Nov 20 at 1:12
|
show 6 more comments
up vote
0
down vote
favorite
up vote
0
down vote
favorite
How can I create a constraint with Hibernate? I'm mapping two classes, "Team" and "Match", but I want that a match JUST can happens if the teams are from the same League. The way that I'm doing right now I can create a match with teams from differents leagues (which isn't interesting in this case).
Is there some annotation that "wraps" my teams, home and away, just being from one league? Or I have to do this in my system?
Thanks.
@Table(name = "match")
@Entity
public class Match implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
@ManyToOne
@JoinColumn(name = "id_league")
private League league;
@ManyToOne
@JoinColumn(name = "id_home", referencedColumnName="id")
private Team home;
@ManyToOne
@JoinColumn(name = "id_away", referencedColumnName="id")
private Team away;
@Column
private Integer goalsHome;
@Column
private Integer goalsAway;
@Temporal(value = TemporalType.DATE)
private Date matchDate;
and
@Table(name="team")
@Entity
public class Team implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
@Column(length = 55)
private String name;
@ManyToOne
@JoinColumn(name = "id_league")
private League league;
@OneToMany
private List<Match> match;
java hibernate
How can I create a constraint with Hibernate? I'm mapping two classes, "Team" and "Match", but I want that a match JUST can happens if the teams are from the same League. The way that I'm doing right now I can create a match with teams from differents leagues (which isn't interesting in this case).
Is there some annotation that "wraps" my teams, home and away, just being from one league? Or I have to do this in my system?
Thanks.
@Table(name = "match")
@Entity
public class Match implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
@ManyToOne
@JoinColumn(name = "id_league")
private League league;
@ManyToOne
@JoinColumn(name = "id_home", referencedColumnName="id")
private Team home;
@ManyToOne
@JoinColumn(name = "id_away", referencedColumnName="id")
private Team away;
@Column
private Integer goalsHome;
@Column
private Integer goalsAway;
@Temporal(value = TemporalType.DATE)
private Date matchDate;
and
@Table(name="team")
@Entity
public class Team implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer id;
@Column(length = 55)
private String name;
@ManyToOne
@JoinColumn(name = "id_league")
private League league;
@OneToMany
private List<Match> match;
java hibernate
java hibernate
edited Nov 20 at 1:07
asked Nov 20 at 1:01
Hawk
84
84
do you mean like aJOIN
?
– Scary Wombat
Nov 20 at 1:02
@TimBiegeleisen Actually, I translated my classes wrong. Now it's correct, thanks.
– Hawk
Nov 20 at 1:08
@ScaryWombat but join isn't used only for consults?
– Hawk
Nov 20 at 1:08
Sorry I have no idea what you are meaning. Can you show what you want by making SQL?
– Scary Wombat
Nov 20 at 1:11
Is a league associated with a team, or with a match? I think it should only be associated with a team, so removeLeague
from yourMatch
entity.
– Tim Biegeleisen
Nov 20 at 1:12
|
show 6 more comments
do you mean like aJOIN
?
– Scary Wombat
Nov 20 at 1:02
@TimBiegeleisen Actually, I translated my classes wrong. Now it's correct, thanks.
– Hawk
Nov 20 at 1:08
@ScaryWombat but join isn't used only for consults?
– Hawk
Nov 20 at 1:08
Sorry I have no idea what you are meaning. Can you show what you want by making SQL?
– Scary Wombat
Nov 20 at 1:11
Is a league associated with a team, or with a match? I think it should only be associated with a team, so removeLeague
from yourMatch
entity.
– Tim Biegeleisen
Nov 20 at 1:12
do you mean like a
JOIN
?– Scary Wombat
Nov 20 at 1:02
do you mean like a
JOIN
?– Scary Wombat
Nov 20 at 1:02
@TimBiegeleisen Actually, I translated my classes wrong. Now it's correct, thanks.
– Hawk
Nov 20 at 1:08
@TimBiegeleisen Actually, I translated my classes wrong. Now it's correct, thanks.
– Hawk
Nov 20 at 1:08
@ScaryWombat but join isn't used only for consults?
– Hawk
Nov 20 at 1:08
@ScaryWombat but join isn't used only for consults?
– Hawk
Nov 20 at 1:08
Sorry I have no idea what you are meaning. Can you show what you want by making SQL?
– Scary Wombat
Nov 20 at 1:11
Sorry I have no idea what you are meaning. Can you show what you want by making SQL?
– Scary Wombat
Nov 20 at 1:11
Is a league associated with a team, or with a match? I think it should only be associated with a team, so remove
League
from your Match
entity.– Tim Biegeleisen
Nov 20 at 1:12
Is a league associated with a team, or with a match? I think it should only be associated with a team, so remove
League
from your Match
entity.– Tim Biegeleisen
Nov 20 at 1:12
|
show 6 more comments
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53384770%2fhow-create-a-constraint-with-hibernate%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
do you mean like a
JOIN
?– Scary Wombat
Nov 20 at 1:02
@TimBiegeleisen Actually, I translated my classes wrong. Now it's correct, thanks.
– Hawk
Nov 20 at 1:08
@ScaryWombat but join isn't used only for consults?
– Hawk
Nov 20 at 1:08
Sorry I have no idea what you are meaning. Can you show what you want by making SQL?
– Scary Wombat
Nov 20 at 1:11
Is a league associated with a team, or with a match? I think it should only be associated with a team, so remove
League
from yourMatch
entity.– Tim Biegeleisen
Nov 20 at 1:12