Spring jpa @OneToMany one direction always null
up vote
-1
down vote
favorite
@Data
@Entity
@Table(name = "member")
public class MemberEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@OneToMany
@JoinColumn(name = "memberId")
private List<PhoneEntity> phoneEntities;
}
@Data
@Entity
@Table(name = "phone")
public class PhoneEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@Column
private Integer memberId;
}
@Repository
public interface MemberRepository extends JpaRepository<MemberEntity, Integer> {
@Query("select m from MemberEntity m join fetch m.phoneEntities where m.id=?1")
MemberEntity findByIdWithPhone(Integer id);
}
create OneToMany relationship from Member to Phone
im trying to select Member fetch join with Phone using @Query("select m from MemberEntity m join fetch m.phoneEntities where m.id=?1") Query
this query created like under my-sql query
SELECT
memberenti0_.id as id1_0_0_,
phoneentit1_.id as id1_1_1_,
phoneentit1_.member_id as member_i2_1_1_,
phoneentit1_.member_id as member_i2_1_0__,
phoneentit1_.id as id1_1_0__
from member memberenti0_
inner join phone phoneentit1_ on memberenti0_.id=phoneentit1_.member_id
where memberenti0_.id=?
and result MemberEntity is not null(this mean insert and inner join is work!) but MemberEntity#phoneEntities is always null
im trying to change List<PhoneEntity> Collections<PhoneEntity> Set<PhoneEntity> all collection type doesn't work.
I doubt column in Phone table call twice in the generated query(member_i2_1_1_, member_i2_1_0__), but I do not know why.
java hibernate jpa spring-data-jpa
asked Nov 22 at 15:14
user2637015
2842517
add a comment |
up vote
-1
down vote
favorite
@Data
@Entity
@Table(name = "member")
public class MemberEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@OneToMany
@JoinColumn(name = "memberId")
private List<PhoneEntity> phoneEntities;
}
@Data
@Entity
@Table(name = "phone")
public class PhoneEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@Column
private Integer memberId;
}
@Repository
public interface MemberRepository extends JpaRepository<MemberEntity, Integer> {
@Query("select m from MemberEntity m join fetch m.phoneEntities where m.id=?1")
MemberEntity findByIdWithPhone(Integer id);
}
create OneToMany relationship from Member to Phone
im trying to select Member fetch join with Phone using @Query("select m from MemberEntity m join fetch m.phoneEntities where m.id=?1") Query
this query created like under my-sql query
SELECT
memberenti0_.id as id1_0_0_,
phoneentit1_.id as id1_1_1_,
phoneentit1_.member_id as member_i2_1_1_,
phoneentit1_.member_id as member_i2_1_0__,
phoneentit1_.id as id1_1_0__
from member memberenti0_
inner join phone phoneentit1_ on memberenti0_.id=phoneentit1_.member_id
where memberenti0_.id=?
and result MemberEntity is not null(this mean insert and inner join is work!) but MemberEntity#phoneEntities is always null
im trying to change List<PhoneEntity> Collections<PhoneEntity> Set<PhoneEntity> all collection type doesn't work.
I doubt column in Phone table call twice in the generated query(member_i2_1_1_, member_i2_1_0__), but I do not know why.
java hibernate jpa spring-data-jpa
asked Nov 22 at 15:14
user2637015
2842517
So you do call ` MemberEntity#getPhoneEntities()` and get null???
– Eugen Covaci
Nov 22 at 15:23
Alsomember_idis not mapped tomemberIdinPhoneEntity
– Eugen Covaci
Nov 22 at 15:30
yes that method return null.
– user2637015
Nov 22 at 15:40
So you call it on detach entity.
– Eugen Covaci
Nov 22 at 16:04
How can it be that you have specified@JoinColumn(name = "memberId")but the SQL uses a columnphoneentit1_.member_id? How can this query even execute never mind return the wrong data?
– Alan Hay
Nov 22 at 17:23
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
@Data
@Entity
@Table(name = "member")
public class MemberEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@OneToMany
@JoinColumn(name = "memberId")
private List<PhoneEntity> phoneEntities;
}
@Data
@Entity
@Table(name = "phone")
public class PhoneEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@Column
private Integer memberId;
}
@Repository
public interface MemberRepository extends JpaRepository<MemberEntity, Integer> {
@Query("select m from MemberEntity m join fetch m.phoneEntities where m.id=?1")
MemberEntity findByIdWithPhone(Integer id);
}
create OneToMany relationship from Member to Phone
im trying to select Member fetch join with Phone using @Query("select m from MemberEntity m join fetch m.phoneEntities where m.id=?1") Query
this query created like under my-sql query
SELECT
memberenti0_.id as id1_0_0_,
phoneentit1_.id as id1_1_1_,
phoneentit1_.member_id as member_i2_1_1_,
phoneentit1_.member_id as member_i2_1_0__,
phoneentit1_.id as id1_1_0__
from member memberenti0_
inner join phone phoneentit1_ on memberenti0_.id=phoneentit1_.member_id
where memberenti0_.id=?
and result MemberEntity is not null(this mean insert and inner join is work!) but MemberEntity#phoneEntities is always null
im trying to change List<PhoneEntity> Collections<PhoneEntity> Set<PhoneEntity> all collection type doesn't work.
I doubt column in Phone table call twice in the generated query(member_i2_1_1_, member_i2_1_0__), but I do not know why.
java hibernate jpa spring-data-jpa
asked Nov 22 at 15:14
user2637015
2842517
@Data
@Entity
@Table(name = "member")
public class MemberEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@OneToMany
@JoinColumn(name = "memberId")
private List<PhoneEntity> phoneEntities;
}
@Data
@Entity
@Table(name = "phone")
public class PhoneEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@Column
private Integer memberId;
}
@Repository
public interface MemberRepository extends JpaRepository<MemberEntity, Integer> {
@Query("select m from MemberEntity m join fetch m.phoneEntities where m.id=?1")
MemberEntity findByIdWithPhone(Integer id);
}
create OneToMany relationship from Member to Phone
im trying to select Member fetch join with Phone using @Query("select m from MemberEntity m join fetch m.phoneEntities where m.id=?1") Query
this query created like under my-sql query
SELECT
memberenti0_.id as id1_0_0_,
phoneentit1_.id as id1_1_1_,
phoneentit1_.member_id as member_i2_1_1_,
phoneentit1_.member_id as member_i2_1_0__,
phoneentit1_.id as id1_1_0__
from member memberenti0_
inner join phone phoneentit1_ on memberenti0_.id=phoneentit1_.member_id
where memberenti0_.id=?
and result MemberEntity is not null(this mean insert and inner join is work!) but MemberEntity#phoneEntities is always null
im trying to change List<PhoneEntity> Collections<PhoneEntity> Set<PhoneEntity> all collection type doesn't work.
I doubt column in Phone table call twice in the generated query(member_i2_1_1_, member_i2_1_0__), but I do not know why.
java hibernate jpa spring-data-jpa
java hibernate jpa spring-data-jpa
asked Nov 22 at 15:14
user2637015
2842517
asked Nov 22 at 15:14
user2637015
2842517
asked Nov 22 at 15:14
user2637015
2842517
asked Nov 22 at 15:14
user2637015
2842517
asked Nov 22 at 15:14
user2637015
2842517
2842517
So you do call ` MemberEntity#getPhoneEntities()` and get null???
– Eugen Covaci
Nov 22 at 15:23
Alsomember_idis not mapped tomemberIdinPhoneEntity
– Eugen Covaci
Nov 22 at 15:30
yes that method return null.
– user2637015
Nov 22 at 15:40
So you call it on detach entity.
– Eugen Covaci
Nov 22 at 16:04
How can it be that you have specified@JoinColumn(name = "memberId")but the SQL uses a columnphoneentit1_.member_id? How can this query even execute never mind return the wrong data?
– Alan Hay
Nov 22 at 17:23
add a comment |
So you do call ` MemberEntity#getPhoneEntities()` and get null???
– Eugen Covaci
Nov 22 at 15:23
Alsomember_idis not mapped tomemberIdinPhoneEntity
– Eugen Covaci
Nov 22 at 15:30
yes that method return null.
– user2637015
Nov 22 at 15:40
So you call it on detach entity.
– Eugen Covaci
Nov 22 at 16:04
How can it be that you have specified@JoinColumn(name = "memberId")but the SQL uses a columnphoneentit1_.member_id? How can this query even execute never mind return the wrong data?
– Alan Hay
Nov 22 at 17:23
So you do call ` MemberEntity#getPhoneEntities()` and get null???
– Eugen Covaci
Nov 22 at 15:23
So you do call ` MemberEntity#getPhoneEntities()` and get null???
– Eugen Covaci
Nov 22 at 15:23
Also
member_id is not mapped to memberId in PhoneEntity– Eugen Covaci
Nov 22 at 15:30
Also
member_id is not mapped to memberId in PhoneEntity– Eugen Covaci
Nov 22 at 15:30
yes that method return null.
– user2637015
Nov 22 at 15:40
yes that method return null.
– user2637015
Nov 22 at 15:40
So you call it on detach entity.
– Eugen Covaci
Nov 22 at 16:04
So you call it on detach entity.
– Eugen Covaci
Nov 22 at 16:04
How can it be that you have specified
@JoinColumn(name = "memberId") but the SQL uses a column phoneentit1_.member_id? How can this query even execute never mind return the wrong data?– Alan Hay
Nov 22 at 17:23
How can it be that you have specified
@JoinColumn(name = "memberId") but the SQL uses a column phoneentit1_.member_id? How can this query even execute never mind return the wrong data?– Alan Hay
Nov 22 at 17:23
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
You have to correct your mapping as:
@Data
@Entity
@Table(name = "member")
public class MemberEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@OneToMany(
mappedBy = "member"
)
private List<PhoneEntity> phoneEntities;
}
@Data
@Entity
@Table(name = "phone")
public class PhoneEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@ManyToOne(fetch = FetchType.LAZY) // Or Eager
@JoinColumn(name = "member_id")
private MemberEntity member;
}
And there no need to specify join in the query :
@Query("select m from MemberEntity m where m.id=?1")
answered Nov 22 at 15:40
hasnae
1,2551016
there is no way without relationship inPhoneEntity?
– user2637015
Nov 22 at 16:02
1
A Unidirectional relationship is perfectly valid and I don't see that this is the cause of your problem.
– Alan Hay
Nov 22 at 17:25
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%2f53433878%2fspring-jpa-onetomany-one-direction-always-null%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
up vote
1
down vote
accepted
You have to correct your mapping as:
@Data
@Entity
@Table(name = "member")
public class MemberEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@OneToMany(
mappedBy = "member"
)
private List<PhoneEntity> phoneEntities;
}
@Data
@Entity
@Table(name = "phone")
public class PhoneEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@ManyToOne(fetch = FetchType.LAZY) // Or Eager
@JoinColumn(name = "member_id")
private MemberEntity member;
}
And there no need to specify join in the query :
@Query("select m from MemberEntity m where m.id=?1")
answered Nov 22 at 15:40
hasnae
1,2551016
there is no way without relationship inPhoneEntity?
– user2637015
Nov 22 at 16:02
1
A Unidirectional relationship is perfectly valid and I don't see that this is the cause of your problem.
– Alan Hay
Nov 22 at 17:25
add a comment |
up vote
1
down vote
accepted
You have to correct your mapping as:
@Data
@Entity
@Table(name = "member")
public class MemberEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@OneToMany(
mappedBy = "member"
)
private List<PhoneEntity> phoneEntities;
}
@Data
@Entity
@Table(name = "phone")
public class PhoneEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@ManyToOne(fetch = FetchType.LAZY) // Or Eager
@JoinColumn(name = "member_id")
private MemberEntity member;
}
And there no need to specify join in the query :
@Query("select m from MemberEntity m where m.id=?1")
answered Nov 22 at 15:40
hasnae
1,2551016
there is no way without relationship inPhoneEntity?
– user2637015
Nov 22 at 16:02
1
A Unidirectional relationship is perfectly valid and I don't see that this is the cause of your problem.
– Alan Hay
Nov 22 at 17:25
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
You have to correct your mapping as:
@Data
@Entity
@Table(name = "member")
public class MemberEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@OneToMany(
mappedBy = "member"
)
private List<PhoneEntity> phoneEntities;
}
@Data
@Entity
@Table(name = "phone")
public class PhoneEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@ManyToOne(fetch = FetchType.LAZY) // Or Eager
@JoinColumn(name = "member_id")
private MemberEntity member;
}
And there no need to specify join in the query :
@Query("select m from MemberEntity m where m.id=?1")
answered Nov 22 at 15:40
hasnae
1,2551016
You have to correct your mapping as:
@Data
@Entity
@Table(name = "member")
public class MemberEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@OneToMany(
mappedBy = "member"
)
private List<PhoneEntity> phoneEntities;
}
@Data
@Entity
@Table(name = "phone")
public class PhoneEntity {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
@ManyToOne(fetch = FetchType.LAZY) // Or Eager
@JoinColumn(name = "member_id")
private MemberEntity member;
}
And there no need to specify join in the query :
@Query("select m from MemberEntity m where m.id=?1")
answered Nov 22 at 15:40
hasnae
1,2551016
answered Nov 22 at 15:40
hasnae
1,2551016
answered Nov 22 at 15:40
hasnae
1,2551016
answered Nov 22 at 15:40
hasnae
1,2551016
1,2551016
there is no way without relationship inPhoneEntity?
– user2637015
Nov 22 at 16:02
1
A Unidirectional relationship is perfectly valid and I don't see that this is the cause of your problem.
– Alan Hay
Nov 22 at 17:25
add a comment |
there is no way without relationship inPhoneEntity?
– user2637015
Nov 22 at 16:02
1
A Unidirectional relationship is perfectly valid and I don't see that this is the cause of your problem.
– Alan Hay
Nov 22 at 17:25
there is no way without relationship in
PhoneEntity?– user2637015
Nov 22 at 16:02
there is no way without relationship in
PhoneEntity?– user2637015
Nov 22 at 16:02
1
1
A Unidirectional relationship is perfectly valid and I don't see that this is the cause of your problem.
– Alan Hay
Nov 22 at 17:25
A Unidirectional relationship is perfectly valid and I don't see that this is the cause of your problem.
– Alan Hay
Nov 22 at 17:25
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.
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.
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%2f53433878%2fspring-jpa-onetomany-one-direction-always-null%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
So you do call ` MemberEntity#getPhoneEntities()` and get null???
– Eugen Covaci
Nov 22 at 15:23
Also
member_idis not mapped tomemberIdinPhoneEntity– Eugen Covaci
Nov 22 at 15:30
yes that method return null.
– user2637015
Nov 22 at 15:40
So you call it on detach entity.
– Eugen Covaci
Nov 22 at 16:04
How can it be that you have specified
@JoinColumn(name = "memberId")but the SQL uses a columnphoneentit1_.member_id? How can this query even execute never mind return the wrong data?– Alan Hay
Nov 22 at 17:23