How to prevent the creation of duplicate tables in h2 when using Spring and Liquibase?

edit

To prevent the creation of duplicate tables in h2 when using Spring and Liquibase, you can follow these steps:

1. Define a unique context for your Liquibase scripts in your application.properties or application.yml file. For example:

   spring.liquibase.contexts=production
   

2. Use the same context in your Liquibase changelog file. For example:

   <changeSet id="1" author="johndoe" context="production">
    <createTable tableName="my_table">
      ...
    </createTable>
   </changeSet>
   

3. Make sure that the Liquibase script is only executed once during application startup. You can do this by configuring the Liquibase bean to run only during the first run of the application:

   @Bean
   public SpringLiquibase liquibase(DataSource dataSource) {
      SpringLiquibase liquibase = new SpringLiquibase();
      liquibase.setDataSource(dataSource);
      liquibase.setChangeLog("classpath:liquibase-changelog.xml");
      liquibase.setContexts("production");
   
      // Only run Liquibase once during application startup
      liquibase.setShouldRun(!dataSource.getConnection().getMetaData().getTables(null, null, "my_table", null).next());
   
      return liquibase;
   }
   

   In this example, the getTables method is used to check if the my_table table already exists in the database. If it does, Liquibase will not run the script again.

By following these steps, you can ensure that Liquibase only creates tables once and prevents the creation of duplicate tables.