Spring R2DBC-使用schema.sql创建h2表时出现“表已存在”错误

Question

得到错误"表客户已经存在"当我试图创建一个表在H2内存数据库使用schema.sql.我使用的是Spring启动版本：2.5.4和以下是我的pom.xml.它的工作正常，如果我使用Spring启动版本：2.4.3

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.5.4</version>
    <relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.sample</groupId>
<artifactId>demo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>demo</name>
<description>Demo project</description>
<properties>
    <java.version>11</java.version>
</properties>
<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-r2dbc</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-webflux</artifactId>
    </dependency>
    <dependency>
        <groupId>com.h2database</groupId>
        <artifactId>h2</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>io.r2dbc</groupId>
        <artifactId>r2dbc-h2</artifactId>
        </dependency>
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <optional>true</optional>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>io.projectreactor</groupId>
        <artifactId>reactor-test</artifactId>
        <scope>test</scope>
    </dependency>
</dependencies>

这是我的代码：

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Customer {
  @Id
  String id;
  String name;
}


//schema.sql
CREATE TABLE CUSTOMER (id SERIAL PRIMARY KEY, name VARCHAR(255));

@SpringBootApplication
public class ReactivedemoApplication {

  public static void main(String[] args) {
    SpringApplication.run(ReactivedemoApplication.class, args);
  }

  @Bean
  ConnectionFactoryInitializer initializer(ConnectionFactory connectionFactory) {

        ConnectionFactoryInitializer initializer = new ConnectionFactoryInitializer();
        initializer.setConnectionFactory(connectionFactory);
        initializer.setDatabasePopulator(new ResourceDatabasePopulator(new 
        ClassPathResource("schema.sql")));
        return initializer;
   }
}

当我启动应用程序时，我收到以下错误。如何强制H2使用schema.sql创建表格？

原因：io。r2dbc。spi。R2dbcBadGrammarException：表“CUSTOMER”已存在；SQL语句：在io处创建表CUSTOMER（id序列主键，名称VARCHAR（255））[42101-200]。r2dbc。h2.h2数据库例外工厂。在io上转换（H2DatabaseExceptionFactory.java:81）~[r2dbc-h2-0.8.4.RELEASE.jar:0.8.4.RELEASE]。r2dbc。h2.h2声明。lambda$execute$2（H2Statement.java:155）~[r2dbc-h2-0.8.4.RELEASE.jar:0.8.4.RELEASE]在Reactor。果心出版商FluxMapFuseable$MapFuseableSubscriber。onNext（FluxMapfusable.java:113）~[reactor-core-3.4.9.jar:3.4.9]。。。44由于：org而省略的公共帧。h2.jdbc。JdbcSQLSyntaxErrorException：表“CUSTOMER”已存在；SQL语句：创建表CUSTOMER（id序列主键，名称VARCHAR（255））[42101-200]

Answer 1

因为spring已经从根位置模式创建了表。不需要sql、ConnectionFactoryInitializer bean。删除ConnectionFactoryInitializer bean声明修复了该问题。