Spring，Jpa：串列包含值時出現一對多錯誤

我想以 JSON 格式回傳一個組態檔物件，其中包含與社交網路關聯的登錄詳細資訊串列。

當“reseaux_sociaux”表為空時，一切正常。對于我的狀態表，我在 Profile 物件中以 JSON 格式獲取狀態。但是，當“reseaux_sociaux”包含值時，我會收到以下錯誤，并且不會回傳 JSON 格式的 Profile 物件...

（日志）

https://cloudvyzor.com/logpad/?query&database=sandbox-7fb06b2c06f198a7c0e4ff7c74d659e0

輪廓類

@Entity
@Table(name = "Profil")
public class Profil {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long Id;

    @ManyToOne(fetch = FetchType.LAZY, optional = false)
    @JoinColumn(name = "IdComptes", nullable = false)
    private Comptes IdComptes;
    private String Avatar;
    private String Banniere;
    private String Pseudo;
    private String MailPro;
    private String Bio;

    @ManyToMany(cascade = CascadeType.ALL,fetch = FetchType.EAGER)
    @JoinTable(name = "Statut_Profil", joinColumns = @JoinColumn(referencedColumnName = "Id"),inverseJoinColumns = @JoinColumn(referencedColumnName ="Id"))
    private List<Statut> Statut;

    @OneToMany( mappedBy = "IdProfil")
    @JsonManagedReference("id_profil")
    private List<ReseauxSociaux> Reseaux;

    public Profil(){}

    public Profil(Long id, Comptes idComptes, String avatar, String banniere, String pseudo, String mailPro, String bio) {
        Id = id;
        IdComptes = idComptes;
        Avatar = avatar;
        Banniere = banniere;
        Pseudo = pseudo;
        MailPro = mailPro;
        Bio = bio;
    }
}

ReseauxSociaux類

@Entity
@IdClass(ReseauxId.class)
public class ReseauxSociaux {
    @Id
    private int Id;
    @Id
    private Long IdProfil;

    @ManyToOne(cascade = CascadeType.ALL)
    @JoinColumn(name = "IdProfil", insertable = false, updatable = false)
    @JsonBackReference("id_profil")
    private Profil Profil;


    @ManyToOne
    @JoinColumn(name = "Id", insertable = false, updatable = false)
    @JsonBackReference("id")
    private Reseau Reseau;

    private String Identifiant;


    private ReseauxSociaux()
    {}

    public ReseauxSociaux(int id, Long idProfil, String identifiant) {
        Id = id;
        IdProfil = idProfil;

        Identifiant = identifiant;
    }
}

網狀類

@Entity
public class Reseau {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int Id;
    private String Nom;
    private String Couleur;

    //I tried it with and without and it made no difference
    @OneToMany( mappedBy = "Id")
    @JsonManagedReference("id")
    private List<ReseauxSociaux> Reseaux;

    public Reseau(){}

    public Reseau(int id, String nom, String couleur) {
        Id = id;
        Nom = nom;
        Couleur = couleur;
    }
//Get Set
}

輪廓控制器

@RestController
@RequestMapping("/profil")
public class ProfilController {

    private final ProfilRepository profilRepository;

    public ProfilController(ProfilRepository profilRepository) {
        this.profilRepository = profilRepository;
    }

    @PostMapping("/getprofil/{idCompte}")
    Profil GetProfil(@PathVariable("idCompte") Long idCompte)
    {
        Profil profil= profilRepository.findProfilById(idCompte);
        return profil;
    }
}

uj5u.com熱心網友回復：

我終于成功了……問題的原因還不清楚，但我有兩個假設：第一個是在變數名上使用大寫字母；第二種是在兩個物體中使用具有相同名稱的 onetomany 的串列。

輪廓類

@Entity
@Table(name = "Profil")
public class Profil {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @ManyToOne(fetch = FetchType.LAZY, optional = false)
    @JoinColumn(name = "idComptes", nullable = false)
    @JsonBackReference("id_comptes")
    private Comptes idComptes;
    private String avatar;
    private String banniere;
    private String pseudo;
    private String mailPro;
    private String bio;

    @ManyToMany(cascade = CascadeType.ALL,fetch = FetchType.EAGER)
    @JoinTable(name = "statut_profil", joinColumns = @JoinColumn(referencedColumnName = "id"),inverseJoinColumns = @JoinColumn(referencedColumnName ="id"))
    private List<Statut> statut;

    @OneToMany( mappedBy = "idProfil")
    @JsonManagedReference("id_profil")
    private List<ReseauxSociaux> lstprofil;

    public Profil(){}

    public Profil(Long id, Comptes idComptes, String avatar, String banniere, String pseudo, String mailPro, String bio) {
        this.id = id;
        this.idComptes = idComptes;
        this.avatar = avatar;
        this.banniere = banniere;
        this.pseudo = pseudo;
        this.mailPro = mailPro;
        this.bio = bio;
    }
//get set
}

ReseauxSociaux類

    @Entity
    @IdClass(ReseauxId.class)
    public class ReseauxSociaux {
        @Id
        private int id;
        @ManyToOne
        @JoinColumn(name = "id", insertable = false, updatable = false)
        @JsonBackReference("id_reseau")
        private Reseau reseau;
    
        @Id
        private Long idProfil;
    
        @ManyToOne
        @JoinColumn(name = "idProfil", insertable = false, updatable = false)
        @JsonBackReference("id_profil")
        private Profil profil;
    
    
        private String identifiant;
    
    
        private ReseauxSociaux()
        {}
    
    
        public ReseauxSociaux(int id, Reseau reseau, Long idProfil, String identifiant) {
            this.id = id;
            this.reseau = reseau;
            this.idProfil = idProfil;
            this.identifiant = identifiant;
        }
}

網狀類

@Entity
public class Reseau {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
    private String nom;
    private String couleur;

    @OneToMany( mappedBy = "id")
    @JsonManagedReference("id_reseau")
    private List<ReseauxSociaux> lstreseau;

    public Reseau(){}

    public Reseau(int id, String nom, String couleur) {
        this.id = id;
        this.nom = nom;
        this.couleur = couleur;
    }
}

標籤：爪哇 json 春天 jpa 杰克逊

上一篇：從Postgres的日期范圍中獲取星期幾

下一篇：更新物體springjpa時的分離物體問題