How to add list of Strings to entity - Spring, Hibernate

Question

I have Spring Boot project with DB. I've already get table, let's call it "People". I need to add a second table "People_Strings" with two columns: People_id and String. I need to include many strings for every row from People.

How can I map it in my People entity in project?

Edit: I need to do this without creating separete class for String or for People_Strings

If you want to do this without separate classes you can store a list! And please ask your questions clearly at first — Oguz Ozcan
– Oguz Ozcan, Commented Dec 19, 2017 at 16:26

Ramsés J · Accepted Answer · 2017-12-19 16:27:20Z

6

If you only need that, you can add the following property to the People entity class:

@ElementCollection
public List<String> strings;

answered Dec 19, 2017 at 16:27

Ramsés J

4073 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Oguz Ozcan · Accepted Answer · 2017-12-19 16:20:28Z

1

What you need is @OneToMany relation between people and strings. Something like the following will work for you.

@Entity
@Table(name = "People")
public class People{

  @Id
  @GeneratedValue
  private Long id;

  @OneToMany(fetch= FetchType.EAGER, cascade=CascadeType.ALL, mappedBy = "peopleId")
  private List<PeopleStrings> PeopleStrings;

@Entity
@Table(name = "People_Strings")
public class PeopleStrings{

  @Id
  @GeneratedValue
  private Long peopleId;

  @ManyToOne
  @JoinColumn(name="peopleId")
  private String string;

answered Dec 19, 2017 at 16:20

Oguz Ozcan

1,55713 silver badges22 bronze badges

2 Comments

lance-java Over a year ago

This is why I hate hibernate, that FetchType.EAGER is bound to cause a query to perform really badly in the future

lance-java Over a year ago

Option 1: Ditch hibernate... avoid that nonsense all together!! (hibernate makes intelligent people write stupid queries) Option 2: Never eager fetch by default. If you want eager, you should explicitly say so when querying.

lance-java · Accepted Answer · 2017-12-19 16:20:20Z

0

You'll want a @OneToMany relationship on the Person object (please don't use plurals, eg People). And possibly a @ManyToOne relationship on the PersonString object (again no plurals)

answered Dec 19, 2017 at 16:20

lance-java

29.4k6 gold badges73 silver badges114 bronze badges

Comments

Nikolai Shevchenko · Accepted Answer · 2017-12-19 16:19:14Z

-1

This is kinda basic question and I suggest you to read Hibernate "Get Started" first. (one-to-many / many-to-one relations especially)

answered Dec 19, 2017 at 16:19

Nikolai Shevchenko

7,6278 gold badges36 silver badges47 bronze badges

2 Comments

Alex Over a year ago

yup, it is basic question, when it comes to include list of Objects from other entity. I don't want to create separate class for Strings. So I'm asking if there's other way.

Nikolai Shevchenko Over a year ago

Then you should consider using a combination of @ElementCollection, @MapKeyColumn and @CollectionTable

Collectives™ on Stack Overflow

How to add list of Strings to entity - Spring, Hibernate

4 Answers 4

Comments

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related