一对一Mapspring boot

jtw3ybtb  于 2021-07-29  发布在  Java
关注(0)|答案(1)|浏览(459)

大家好，我有一个问题，我的一对一连接，当我试图登录到“用户”我得到这个错误
我需要的是一个一对一的连接，它不必是持久的，这意味着用户可以拥有一个播放器，但不必拥有它，反之亦然
因为在我的例子中，minecraft服务器应该填充player表，而网站填充用户以便他们可以连接。

  1. 2020-07-27 23:06:12,537 DEBUG [http-nio-8080-exec-2] nirvanacw.de.demo.user.UserServiceImpl: --> getUserByEmail email=Test@gmx.de
  2. 2020-07-27 23:06:12,550 WARN  [http-nio-8080-exec-2] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 42122, SQLState: 42S22
  3. 2020-07-27 23:06:12,550 ERROR [http-nio-8080-exec-2] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Feld "player0_.player" nicht gefunden
  4. Column "player0_.player" not found; SQL statement:
  5. select player0_.id as id1_2_1_, player0_.banned as banned2_2_1_, player0_.first_joined as first_jo3_2_1_, player0_.ip_address as ip_addre4_2_1_, player0_.last_joined as last_joi5_2_1_, player0_.player as player8_2_1_, player0_.player_name as player_n6_2_1_, player0_.uuid as uuid7_2_1_, user1_.id as id1_3_0_, user1_.active as active2_3_0_, user1_.created as created3_3_0_, user1_.email as email4_3_0_, user1_.first_name as first_na5_3_0_, user1_.last_name as last_nam6_3_0_, user1_.password as password7_3_0_, user1_.reset_password as reset_pa8_3_0_, user1_.roles as roles9_3_0_, user1_.updated as updated10_3_0_, user1_.username as usernam11_3_0_ from player player0_ left outer join user user1_ on player0_.player=user1_.id where player0_.player=? [42122-200]
  6. 2020-07-27 23:06:12,558 ERROR [http-nio-8080-exec-2] org.springframework.security.oauth2.provider.endpoint.TokenEndpoint: Handling error: InternalAuthenticationServiceException, could not prepare statement; SQL [select player0_.id as id1_2_1_, player0_.banned as banned2_2_1_, player0_.first_joined as first_jo3_2_1_, player0_.ip_address as ip_addre4_2_1_, player0_.last_joined as last_joi5_2_1_, player0_.player as player8_2_1_, player0_.player_name as player_n6_2_1_, player0_.uuid as uuid7_2_1_, user1_.id as id1_3_0_, user1_.active as active2_3_0_, user1_.created as created3_3_0_, user1_.email as email4_3_0_, user1_.first_name as first_na5_3_0_, user1_.last_name as last_nam6_3_0_, user1_.password as password7_3_0_, user1_.reset_password as reset_pa8_3_0_, user1_.roles as roles9_3_0_, user1_.updated as updated10_3_0_, user1_.username as usernam11_3_0_ from player player0_ left outer join user user1_ on player0_.player=user1_.id where player0_.player=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement
  7. org.springframework.security.authentication.InternalAuthenticationServiceException: could not prepare statement; SQL [select player0_.id as id1_2_1_, player0_.banned as banned2_2_1_, player0_.first_joined as first_jo3_2_1_, player0_.ip_address as ip_addre4_2_1_, player0_.last_joined as last_joi5_2_1_, player0_.player as player8_2_1_, player0_.player_name as player_n6_2_1_, player0_.uuid as uuid7_2_1_, user1_.id as id1_3_0_, user1_.active as active2_3_0_, user1_.created as created3_3_0_, user1_.email as email4_3_0_, user1_.first_name as first_na5_3_0_, user1_.last_name as last_nam6_3_0_, user1_.password as password7_3_0_, user1_.reset_password as reset_pa8_3_0_, user1_.roles as roles9_3_0_, user1_.updated as updated10_3_0_, user1_.username as usernam11_3_0_ from player player0_ left outer join user user1_ on player0_.player=user1_.id where player0_.player=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement

用户实体：

  1. package nirvanacw.de.demo.user;
  3.     import nirvanacw.de.demo.player.Player;
  4.     import org.hibernate.annotations.GenericGenerator;
  6.     import javax.persistence.*;
  7.     import javax.validation.constraints.Email;
  8.     import java.time.ZonedDateTime;
  9.     import java.util.Objects;
  11.     @Entity
  12.     @Table(name = "user")
  13.     public class User {
  15.         @Id
  16.         @GeneratedValue(strategy = GenerationType.AUTO, generator = "native")
  17.         @GenericGenerator(name = "native", strategy = "native")
  18.         @Column(name = "id", updatable = false, nullable = false)
  19.         private Long id;
  21.         @Email
  22.         @Column(name = "email")
  23.         private String email;
  25.         @Column(name ="username")
  26.         private String username;
  28.         @Column(name ="password")
  29.         private String password;
  31.         @Column(name ="first_name")
  32.         private String firstName;
  34.         @Column(name ="last_name")
  35.         private String lastName;
  37.         @OneToOne(mappedBy = "user", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
  38.         private Player player;
  40.         @Column(name ="reset_password")
  41.         private boolean resetPassword;
  43.         @Column(name ="roles")
  44.         private String roles;
  46.         @Column(name ="active")
  47.         private boolean active;
  49.         @Column(name = "created")
  50.         private ZonedDateTime created;
  52.         @Column(name = "updated")
  53.         private ZonedDateTime updated;
  55.         public Long getId() {
  56.             return id;
  57.         }
  59.         public void setId(Long id) {
  60.             this.id = id;
  61.         }
  63.         public String getEmail() {
  64.             return email;
  65.         }
  67.         public void setEmail(String email) {
  68.             this.email = email;
  69.         }
  71.         public String getUsername() {
  72.             return username;
  73.         }
  75.         public void setUsername(String username) {
  76.             this.username = username;
  77.         }
  79.         public String getFirstName() {
  80.             return firstName;
  81.         }
  83.         public void setFirstName(String firstName) {
  84.             this.firstName = firstName;
  85.         }
  87.         public String getLastName() {
  88.             return lastName;
  89.         }
  91.         public void setLastName(String lastName) {
  92.             this.lastName = lastName;
  93.         }
  95.         public boolean isResetPassword() {
  96.             return resetPassword;
  97.         }
  99.         public void setResetPassword(boolean resetPassword) {
  100.             this.resetPassword = resetPassword;
  101.         }
  103.         public String getPassword() {
  104.             return password;
  105.         }
  107.         public void setPassword(String password) {
  108.             this.password = password;
  109.         }
  111.         public String getRoles() {
  112.             return roles;
  113.         }
  115.         public void setRoles(String roles) {
  116.             this.roles = roles;
  117.         }
  119.         public boolean getActive() {
  120.             return active;
  121.         }
  123.         public void setActive(boolean active) {
  124.             this.active = active;
  125.         }
  127.         public Player getPlayer() {
  128.             return player;
  129.         }
  131.         public void setPlayer(Player player) {
  132.             this.player = player;
  133.         }
  135.         @PrePersist
  136.         public void onPrePersist() {
  137.             this.created = ZonedDateTime.now();
  138.         }
  140.         @PreUpdate
  141.         public void onPreUpdate() {
  142.             this.updated = ZonedDateTime.now();
  143.         }
  145.         @Override
  146.         public String toString() {
  147.             return "User{" +
  148.                     "id=" + id +
  149.                     ", email='" + email + '\'' +
  150.                     ", username='" + username + '\'' +
  151.                     ", firstName='" + firstName + '\'' +
  152.                     ", lastName='" + lastName + '\'' +
  153.                     ", player=" + player +
  154.                     ", resetPassword=" + resetPassword +
  155.                     ", roles='" + roles + '\'' +
  156.                     ", active=" + active +
  157.                     ", created=" + created +
  158.                     ", updated=" + updated +
  159.                     '}';
  160.         }
  162.         @Override
  163.         public boolean equals(Object o) {
  164.             if (this == o) return true;
  165.             if (o == null || getClass() != o.getClass()) return false;
  166.             User user = (User) o;
  167.             return resetPassword == user.resetPassword &&
  168.                     active == user.active &&
  169.                     Objects.equals(id, user.id) &&
  170.                     Objects.equals(email, user.email) &&
  171.                     Objects.equals(username, user.username) &&
  172.                     Objects.equals(password, user.password) &&
  173.                     Objects.equals(firstName, user.firstName) &&
  174.                     Objects.equals(lastName, user.lastName) &&
  175.                     Objects.equals(player, user.player) &&
  176.                     Objects.equals(roles, user.roles) &&
  177.                     Objects.equals(created, user.created) &&
  178.                     Objects.equals(updated, user.updated);
  179.         }
  181.         @Override
  182.         public int hashCode() {
  183.             return Objects.hash(id, email, username, password, firstName, lastName, player, resetPassword, roles, active, created, updated);
  184.         }
  185.     }

玩家实体：

  1. import java.sql.Timestamp;
  2. import java.util.Objects;
  3. import java.util.UUID;
  5. @Entity
  6. @Table(name = "player")
  7. public class Player {
  9.     @Id
  10.     @GeneratedValue(strategy = GenerationType.AUTO, generator = "native")
  11.     @GenericGenerator(name = "native", strategy = "native")
  12.     @Column(name = "id", updatable = false, nullable = false)
  13.     private Long id;
  15.     @Column(name = "uuid")
  16.     private UUID uuid;
  18.     @OneToOne
  19.     @JoinColumn(name = "player")
  20.     private User user;
  22.     @Length(max = 16)
  23.     @Column(name = "player_name")
  24.     private String userName;
  26.     @Column(name = "banned")
  27.     private boolean banned;
  29.     @Column(name = "first_joined")
  30.     private Timestamp firstJoined;
  32.     @Column(name = "last_joined")
  33.     private Timestamp lastJoined;
  35.     @Column(name = "ip_address")
  36.     private String ipAddress;
  38.     public Long getId() {
  39.         return id;
  40.     }
  42.     public void setId(Long id) {
  43.         this.id = id;
  44.     }
  46.     public UUID getUuid() {
  47.         return uuid;
  48.     }
  50.     public void setUuid(UUID uuid) {
  51.         this.uuid = uuid;
  52.     }
  54.     public User getUser() {
  55.         return user;
  56.     }
  58.     public void setUser(User user) {
  59.         this.user = user;
  60.     }
  62.     public String getUserName() {
  63.         return userName;
  64.     }
  66.     public void setUserName(String userName) {
  67.         this.userName = userName;
  68.     }
  70.     public boolean isBanned() {
  71.         return banned;
  72.     }
  74.     public void setBanned(boolean banned) {
  75.         this.banned = banned;
  76.     }
  78.     public Timestamp getFirstJoined() {
  79.         return firstJoined;
  80.     }
  82.     public void setFirstJoined(Timestamp firstJoined) {
  83.         this.firstJoined = firstJoined;
  84.     }
  86.     public Timestamp getLastJoined() {
  87.         return lastJoined;
  88.     }
  90.     public void setLastJoined(Timestamp lastJoined) {
  91.         this.lastJoined = lastJoined;
  92.     }
  94.     public String getIpAddress() {
  95.         return ipAddress;
  96.     }
  98.     public void setIpAddress(String ipAddress) {
  99.         this.ipAddress = ipAddress;
  100.     }
  102.     @Override
  103.     public String toString() {
  104.         return "Player{" +
  105.                 "id=" + id +
  106.                 ", uuid=" + uuid +
  107.                 ", user=" + user +
  108.                 ", userName='" + userName + '\'' +
  109.                 ", banned=" + banned +
  110.                 ", firstJoined=" + firstJoined +
  111.                 ", lastJoined=" + lastJoined +
  112.                 ", ipAddress='" + ipAddress + '\'' +
  113.                 '}';
  114.     }
  116.     @Override
  117.     public boolean equals(Object o) {
  118.         if (this == o) return true;
  119.         if (o == null || getClass() != o.getClass()) return false;
  120.         Player player = (Player) o;
  121.         return banned == player.banned &&
  122.                 Objects.equals(id, player.id) &&
  123.                 Objects.equals(uuid, player.uuid) &&
  124.                 Objects.equals(user, player.user) &&
  125.                 Objects.equals(userName, player.userName) &&
  126.                 Objects.equals(firstJoined, player.firstJoined) &&
  127.                 Objects.equals(lastJoined, player.lastJoined) &&
  128.                 Objects.equals(ipAddress, player.ipAddress);
  129.     }
  131.     @Override
  132.     public int hashCode() {
  133.         return Objects.hash(id, uuid, user, userName, banned, firstJoined, lastJoined, ipAddress);
  134.     }
  135. }

flyway用户：

  1. Create TABLE user(
  2.     id bigint NOT NULL AUTO_INCREMENT,
  3.     email character varying(256),
  4.     username character varying(256),
  5.     password character varying(256),
  6.     reset_password boolean,
  7.     first_name character varying(50),
  8.     last_name character varying(50),
  9.     gender character varying(10),
  10.     player_id character varying(17),
  11.     active boolean,
  12.     roles character varying(40),
  13.     created TIMESTAMP,
  14.     updated TIMESTAMP,
  16.     CONSTRAINT PK_account_account_id PRIMARY KEY (id)
  17. );

玩家飞行路线：

  1. CREATE TABLE player(
  2.     id bigint NOT NULL AUTO_INCREMENT,
  3.     uuid char(36) NOT NULL,
  4.     player_name character varying (16),
  5.     user_id bigint,
  6.     banned boolean,
  7.     first_joined timestamp,
  8.     last_joined timestamp,
  9.     ip_address character varying (15),
  11.     CONSTRAINT PK_player_player_id PRIMARY KEY (id),
  12.     CONSTRAINT FK_player_user_id_user_id FOREIGN KEY (user_id) REFERENCES user(id)
  14. );
sqlDatabasespring-bootjpaone-to-one

1条答案

按热度按时间
bjp0bcyl

bjp0bcyl1#

这个错误很明显

  1. Column "player0_.player" not found;

player表没有player列
错误如下：

  1. @OneToOne
  2. @JoinColumn(name = "player")
  3. private User user;

更改为：

  1. @OneToOne
  2. @JoinColumn(name = "user_id")
  3. private User user;

它是与用户建立连接的列。
建议使用jpa实现的配置参数来验证实体的正确建模，而不需要查询，了解如何使用您选择的实现激活它。

展开查看全部
赞(0）分享  回复(0）举报  2021-07-29
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com