使用h2数据库和JPA运行spring boot时,出现以下错误。
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.2.17.Final.jar:5.2.17.Final] at org.hibernate.tool.schema.internal.SchemaCreatorImpl.applySqlString(SchemaCreatorImpl.java:440) [hibernate-core-5.2.17.Final.jar:5.2.17.Final]
这是由于低于一
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE TABLE EXCHANGE_VALUE (ID INTEGER NOT NULL, CONVERSION_MULTIPLE DECIMAL(19,2), FROM[*] VARCHAR(255), PORT INTEGER NOT NULL, TO VARCHAR(255), PRIMARY KEY (ID)) "; expected "identifier"; SQL statement: create table exchange_value (id integer not null, conversion_multiple decimal(19,2), from varchar(255), port integer not null, to varchar(255), primary key (id)) [42001-197] at org.h2.message.DbException.getJdbcSQLException(DbException.java:357) ~[h2-1.4.197.jar:1.4.197] at org.h2.message.DbException.getSyntaxError(DbException.java:217) ~[h2-1.4.197.jar:1.4.197]
我的hibernate课
import java.math.BigDecimal; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name="Exchange_Value") public class ExchangeValue { @Id @GeneratedValue(strategy=GenerationType.AUTO) private int id; private String from; private String to; private BigDecimal conversionMultiple; private int port; public ExchangeValue() { } public ExchangeValue(String from, String to, BigDecimal conversionMultiple) { super(); // this.id = id; this.from = from; this.to = to; this.conversionMultiple = conversionMultiple; } public int getId() { return id; } public void setId(int id) { this.id = id; } }
application.properties在下面
spring.application.name=currency-exchange-service server.port=8000 spring.jpa.hibernate.ddl-auto= create-drop
只想知道我在代码中缺少的内容,尝试添加spring.jpa.hibernate.ddl-auto = create-drop,但没有帮助。
@shubh ..您的实体字段名称与匹配 SQL reserved keywords ,
SQL reserved keywords
因此,请尝试更改字段名称,否则请使用 name 属性 @Column Annotation (将别名提供给DATABASE)
name
@Column Annotation
@Column(name="valueFrom") private String from; @Column(name="valueTo") private String to; private BigDecimal conversionMultiple; private int port;