java - Hibernate 无法创建表:org.hibernate.tool.schema.spi.CommandAcceptanceException: Error execution DDL "create table PSQLException
问题描述
我有 5 个实体:Field、Game、Move、Player 和 User。一个游戏有两个玩家,一个玩家只与一个游戏相关联;一个用户关联多个玩家,一个玩家可以出很多招,而每招只能有一个玩家;一个游戏有两个玩家,许多动作和许多领域。
Hibernate 为其中的 4 个创建表和约束,没有任何问题。但是,当它尝试为 Move 实体创建表时,会引发异常:
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table moves (id int4 not null, column int4 not null, row int4 not null, game_id int4, player_id int4, primary key (id))" via JDBC Statement
然后稍后
org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table moves add constraint FKjv33kkwwhe6121266nmuk7y1d foreign key (game_id) references games" via JDBC Statement
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table moves add constraint FKjv33kkwwhe6121266nmuk7y1d foreign key (game_id) references games" via JDBC Statement
几次。
我不明白 Move 实体有什么问题。这是我的代码:
领域:
package noughtsandcrosses.entity;
import javax.persistence.*;
@Entity
@Table(name = "fields")
public class Field {
@Id
@GeneratedValue
private int id;
private int[][] field;
@ManyToOne
@JoinColumn(name = "game_id")
private Game game;
public void update(Move move) {
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int[][] getField() {
return field;
}
public void setField(int[][] field) {
this.field = field;
}
public Game getGame() {
return game;
}
public void setGame(Game game) {
this.game = game;
}
}
游戏:
package noughtsandcrosses.entity;
import javax.persistence.*;
import java.util.ArrayList;
import java.util.List;
@Entity
@Table(name = "games")
public class Game {
@Id @GeneratedValue
private int id;
@OneToOne
@JoinColumn(name = "crosses_player_id")
private Player crossesPlayer;
@OneToOne
@JoinColumn(name = "noughts_player_id")
private Player noughtsPlayer;
@OneToMany(mappedBy = "game")
private List<Move> moves;
@OneToMany(mappedBy = "game")
private List<Field> fields;
public Game(Player crossesPlayer, Player noughtsPlayer) {
this.crossesPlayer = crossesPlayer;
this.noughtsPlayer = noughtsPlayer;
}
public Player getCrossesPlayer() {
return crossesPlayer;
}
public void setCrossesPlayer(Player crossesPlayer) {
this.crossesPlayer = crossesPlayer;
}
public Player getNoughtsPlayer() {
return noughtsPlayer;
}
public void setNoughtsPlayer(Player noughtsPlayer) {
this.noughtsPlayer = noughtsPlayer;
}
public List<Move> getMoves() {
return moves;
}
public void setMoves(List<Move> moves) {
this.moves = moves;
}
public List<Field> getFields() {
return fields;
}
public void setFields(List<Field> fields) {
this.fields = fields;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
}
移动:
package noughtsandcrosses.entity;
import javax.persistence.*;
@Entity
@Table(name = "moves")
public class Move {
@Id
@GeneratedValue
private int id;
@ManyToOne
@JoinColumn(name = "player_id")
private Player player;
@ManyToOne
@JoinColumn(name = "game_id")
private Game game;
private int row;
private int column;
public Move() {}
public Move(Player player, int row, int column) {
this.player = player;
this.row = row;
this.column = column;
}
public Player getPlayer() {
return player;
}
public int getRow() {
return row;
}
public int getColumn() {
return column;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public void setPlayer(Player player) {
this.player = player;
}
public void setRow(int row) {
this.row = row;
}
public void setColumn(int column) {
this.column = column;
}
public Game getGame() {
return game;
}
public void setGame(Game game) {
this.game = game;
}
}
播放器:
package noughtsandcrosses.entity;
import javax.persistence.*;
import java.util.List;
@Entity
@Table(name = "players")
public class Player {
@Id @GeneratedValue
private int id;
private enum Alignment {
NOUGHTS, CROSSES
};
private Alignment alignment;
@ManyToOne
private User user;
@OneToMany(mappedBy = "player")
private List<Move> moves;
public Player() {
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public Alignment getAlignment() {
return alignment;
}
public void setAlignment(Alignment alignment) {
this.alignment = alignment;
}
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
public List<Move> getMoves() {
return moves;
}
public void setMoves(List<Move> moves) {
this.moves = moves;
}
}
用户:
package noughtsandcrosses.entity;
import javax.persistence.*;
import java.util.*;
@Entity
@Table(name = "users")
@Inheritance(strategy = InheritanceType.JOINED)
public class User {
@Id
@GeneratedValue
private int id;
private String username;
private String password;
@OneToMany(mappedBy="user")
private List<Player> players;
public User() {}
public User(String username, String password) {
this.username = username;
this.password = password;
}
public User(String username) {
this.username = username;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public List<Player> getPlayers() {
return players;
}
public void setPlayers(List<Player> players) {
this.players = players;
}
}
解决方案
Hibernate 应该给你一个真正的错误信息,而不仅仅是告诉你哪个命令失败了。不这样做吗?Hibernate 非常流行(但不是我个人),所以我怀疑它会被破坏到无法返回真正的错误消息,所以我认为您只是没有正确阅读它们。无论如何,您可以查看 PostgreSQL 的日志文件以找到真正的错误消息
如果我从您显示的消息中获取语句并在 psql 中运行它,我会得到:
create table moves (id int4 not null, column int4 not null, row int4 not null, game_id int4, player_id int4, primary key (id));
ERROR: syntax error at or near "column"
这里的问题是这column
是 PostgreSQL 中的保留字。您不能将其用作列的名称,除非您将其放在双引号中。我不知道如何告诉休眠将它放在双引号中,但我确信有办法。但最好将其命名为board_column
. row
不是 PostgreSQL 中的完全保留字,所以你可以使用它,但我不会这样做。将其重命名为board_row
.
推荐阅读
- browser - 如何使用机器人框架从浏览器的通知提示中选择一个选项
- python - Python 使用哪种算法进行乘法运算?
- mysql - EasyPHP-Devserver 17:无法更改 MYSQL 数据目录?
- wso2 - 如何在 WSO2 Api Manager 中禁用主机名验证?
- javascript - 在用户仅在 200px 和 300px 之间滚动时添加一个类
- php - codeigniter 3中的路由冲突
- bash - 当文件夹中有新文件时向 Slack 发送消息
- python - 在python中过滤日期列表
- groovy - 列表中每个版本的记录
- python - 字典键类型混淆 isinstance python