我正在尝试创建一个简单的Spring应用程序,但是在从H2数据库传递到MySQL时遇到了问题。
下面是我的属性:
spring.datasource.url=jdbc:mysql://localhost:3306/spring?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
spring.datasource.username=...
spring.datasource.password=...
spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect
spring.jpa.hibernate.ddl-auto=update不工作的实体:
@Data
@AllArgsConstructor
@NoArgsConstructor
@Entity
@Table(name = "Option")
public class Option {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
long id;
@ManyToOne
@JoinColumn(name = "question_id", nullable = false)
private Question question;
@Column(name = "option", length = 1000, nullable = false)
private String option;
@Column(name = "is_right", nullable = false)
private boolean isRight;
}以及错误:
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table option (id bigint not null, is_right bit not null, option varchar(1000) not null, question_id bigint not null, primary key (id)) engine=MyISAM" via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.4.21.Final.jar:5.4.21.Final]
at ....出什么问题了?在我的实体中,我没有什么特别或棘手的东西。
发布于 2020-12-13 20:25:18
我自己解决了我的错误,Option是MySql中的一个关键字,这就是它不起作用的原因
https://stackoverflow.com/questions/65275482
复制相似问题