hibernate将表名添加到查询中,如join column+name of column

vsikbqxv  于 2021-06-30  发布在  Java
关注(0)|答案(0)|浏览(191)

我有一个问题,hibernate正在创建一个sql查询,并在join语句中添加tablename\u columnname?如果我在hibernate属性中使用update,hibernate将创建新的列,如下所示:这是来自另一个表的,但是您将得到图片,这与针对团队的解决方案相同?
错误
这些是我的实体

  1. @Entity
  2. @Table(name = "tournament_team")
  3. public class TournamentTeam implements Serializable {
  4. @Id
  5. @Column(name = "tourId")
  6. private long tournamentsTourId;
  7. @Id
  8. @Column(name = "teamId")
  9. private long teamsTeamId;
  10. @Column(name = "mmr")
  11. private Integer mmr;
  12. @Column(name = "placement")
  13. private Integer placement;
  14. @Column(name = "teamConfirmed")
  15. private String teamConfirmed;
  16. private String checkedAt;
  17. @ManyToOne(fetch = FetchType.LAZY)
  18. private Team teams;
  19. @OneToMany(mappedBy = "tournamentTeam",fetch = FetchType.LAZY)
  20. private List<TourTeamPlayer> tourTeamPlayers;
  1. @Entity
  2. public class Team {
  3. @Id
  4. private long teamId;
  5. private String teamName;
  6. private Long teamCaptainId;
  7. private Timestamp createdAt;
  8. private String imgUrl;
  9. private String teamRegion;
  10. @ManyToMany(mappedBy = "teams",fetch = FetchType.LAZY)
  11. private List<Player> players = new ArrayList<>();
  12. // @OneToMany(mappedBy = "teams",fetch =FetchType.LAZY )
  13. // private List<PlayerTeam>playerTeams;
  14. @ManyToMany(mappedBy = "teams",fetch = FetchType.LAZY)
  15. private List<Tournament> tournaments = new ArrayList<>();
  16. public long getTeamId() {
  17. return teamId;
  18. }
  19. @OneToMany(mappedBy = "teams",fetch = FetchType.LAZY)
  20. private List<TournamentTeam>tournamentTeams;
  21. @OneToMany(mappedBy = "teams",fetch = FetchType.LAZY)
  22. private List<PlayerTeam>teamPlayers;

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题