dbexception.java,org.hibernate.tool.schema.spi.CommandAcceptanceException：使用h2和JPA在SpringBoot中通过JDBC...

使用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，但没有帮助。