skip to Main Content

I’m using Spring Boot 3.2 version with MySQL database. I have two objects

@Getter
@Setter
@Entity
@Table(name = "shops")
public class Shop{

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String address;
    @OneToMany(mappedBy = "shop", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
    private List<Book> books;
}

and

@Getter
@Setter
@Entity
@Table(name = "books")
public class Book{

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String description;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "shop_id")
    private Shop shop;
}

So I have some lopping problem when I’m trying to get all Shops with all books. I have object Shop with all Books object inside each book has his own shop object inside with all book etc. And it looks like

[
    {
        "id": 4,
        "address": "Street",
        "books": [
                {
                "id": 3,
                "description": "Book1",
                "shop" : {
                       "id": 4,
                       "address": "Street"
                       "books": [
                               {
                                "id": 3,
                                "description": "Book1",
                                "shop" : { ...
                               }
                       ]
                }
        ]
     }
]

So the problem is that I want to use one class for saving shops/books and geting from database.
Then I need that shop have all books as objects with all data but books have only shopId.
So getting all shops should look like this

[
    {
        "id": 4,
        "address": "Street",
        "books": [
                {
                "id": 3,
                "description": "Book1",
                "shop" : 4
                }
         ]
     }
]

and geeting all books should look like this

[
    {
        "id": 3,
        "description": "Book1",
        "shop": 4
    },
    {
        "id": 4,
        "description": "Book2",
        "shop": 5
    },
    {
        "id": 5,
        "description": "Book4",
        "shop": 5
    },
]

As I said I want to use same class for saving shop/books and same class for getting.
I faced with couple problems.

  1. I dont want to create additional ShopDTO/BookDTO objects for getting because if it will be 1M books then I need to created 1M objects each time while getting.
  2. I can’t add just one more variable such as Long shopId; because it will be hibernate error
    Table [books] contains physical column name [shop_id] referred to by multiple logical column names: [shop_id], [shopId]
  3. I can’t change
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "shop_id")
private Shop shop; 

on

@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "shop_id")
private Long shop;

or remove @ManyToOne at all.

2

Answers


  1. Chosen as BEST ANSWER

    So I found the solution. I have added @JsonIdentityInfo to my shop

    @JsonIdentityInfo(generator = ObjectIdGenerators.PropertyGenerator.class, property = "id")
    public class Shop{...
    

    and added same for Book and added one more annotation to my Shop

    @JsonIdentityInfo(generator = ObjectIdGenerators.PropertyGenerator.class, property = "id")
    public class Book{...
       @JsonIdentityReference(alwaysAsId = true)
       private Shop shop;
    }
    

  2. @Entity
    @Table(name = "shops")
    public class Shop {
        @Id
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private Long id;
        private String address;
    
    }
    
    
    @Entity
    @Table(name = "books")
    public class Book {
        @Id
        @GeneratedValue(strategy = GenerationType.IDENTITY)
        private Long id;
        private String description;
    
        @ManyToOne(fetch = FetchType.LAZY)
        @JoinColumn(name = "shop_id")
        private Shop shop;
    
    }
    
    
    SELECT s.id, s.address, b.id AS bookId
    FROM shops s
    LEFT JOIN books b ON s.id = b.shop_id;
    
    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search