LiquiBase：不支持H2的模式名称，但MySQL可以

Question

• 我正在使用Maven Cargo部署我的Spring应用程序。
• 我正在尝试对MySQL和H2嵌入式数据库运行此操作。
  H2的配置如下所示

@Configuration
@Profile("development")
public class H2DatabaseConfig extends JpaCommonConfig {
    @Override
    public DataSource dataSource() {
        // (todo: harit) get rid of hard coding
        System.out.println("This is H2 Database Profile");
        final BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName("org.h2.Driver");
        dataSource.setUrl("jdbc:h2:mem:test_common");
        dataSource.setUsername("sa");
        dataSource.setPassword("");
        return dataSource;
    }

    @Override
    protected Class<? extends Dialect> getDatabaseDialect() {
        return H2Dialect.class;
    }

    @Override
    protected Properties getJpaProperties() {
        final Properties properties = new Properties();
        properties.setProperty(HBM2DDL_AUTO, Hbm2ddlType.CREATE_DROP.toValue());
        properties.setProperty(SHOW_SQL, TRUE.toString());
        properties.setProperty(FORMAT_SQL, TRUE.toString());
        properties.setProperty(USE_SQL_COMMENTS, TRUE.toString());
        properties.setProperty(CONNECTION_CHAR_SET, getHibernateCharSet());
        properties.setProperty(NAMING_STRATEGY, ImprovedNamingStrategy.class.getName());

        return properties;
    }
}

@Configuration
@Profile("default")
public class MySqlDatabaseConfig extends JpaCommonConfig {
    @Override
    public DataSource dataSource() {
        // (todo: harit) remove hardcoding to read from environment variables
        System.out.println("This is MySQL Database Profile");
        final BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/test_common?createDatabaseIfNotExist=true");
        dataSource.setUsername("root");
        return dataSource;
    }

    @Override
    protected Class<? extends Dialect> getDatabaseDialect() {
        return MySQL5InnoDBDialect.class;
    }

    @Override
    protected Properties getJpaProperties() {
        final Properties properties = new Properties();
        properties.setProperty(HBM2DDL_AUTO, Hbm2ddlType.UPDATE.toValue());
        properties.setProperty(SHOW_SQL, TRUE.toString());
        properties.setProperty(FORMAT_SQL, TRUE.toString());
        properties.setProperty(USE_SQL_COMMENTS, TRUE.toString());
        properties.setProperty(CONNECTION_CHAR_SET, getHibernateCharSet());
        properties.setProperty(NAMING_STRATEGY, ImprovedNamingStrategy.class.getName());
        return properties;
    }
}

当我使用cargo运行集成测试时,我看到了两个区别,

1. 当对MySQL运行时，会注意模式名称当Liquibase运行时，我会看到test_common

INFO 5/26/14 9:18 AM:liquibase: Successfully acquired change log lock
INFO 5/26/14 9:18 AM:liquibase: Dropping Database Objects in schema: test_common.test_common
INFO 5/26/14 9:18 AM:liquibase: Creating database history table with name: test_common.DATABASECHANGELOG
INFO 5/26/14 9:18 AM:liquibase: Successfully released change log lock
INFO 5/26/14 9:18 AM:liquibase: Successfully acquired change log lock
INFO 5/26/14 9:18 AM:liquibase: Reading from test_common.DATABASECHANGELOG
INFO 5/26/14 9:18 AM:liquibase: Reading from test_common.DATABASECHANGELOG
INFO 5/26/14 9:18 AM:liquibase: Reading from test_common.DATABASECHANGELOG
INFO 5/26/14 9:18 AM:liquibase: liquibase/changelog.xml: liquibase/2014/1-1.xml::05192014.1525::h2: Reading from

test_common.databasechangelog信息5/26/14 9:18 am：LiquiBase：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/2014/1-1.xml::05192014.1525::h2:表网络创建的信息5/26/14 9:18 am：LiquiBase/Changelog.xml：LiquiBase/2014/1-1.xml::05192014.1525::h2:ChangeSet.DatabaseChangelog INFO 5/26/14 9:18 AM：LiquiBase：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml.xml：05192014.1525::H2:读取test_common.DatabaseChangelog INFO 5/26/14 9:18 AM：：Liquibase/2014/1-2.xml::05192014.1525::h2:新行插入网络work INFO 5/26/14 9:18 AM：LiquiBase：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/2014/1-2.xml::05192014.1525:::H2:将新行插入网络INFO 5/26/14 9:18 AM：LiquiBase：LiquiBase/Changelog.xml：LiquiBase/2014/1-2.xml::05192014.1525::H2:将新行插入网络INFO 5/26/14 9:18 AM：LiquiBase/Changelog.xml：LiquiBase/2014/1-2.xml::05192014.1525::H2:将新行插入网络INFO 5/26/14 9:18 AM：LiquiBase/Changelog.xml：LiquiBase/2014/1-2.xml::05192014.1525::H2:ChangeSet LiquiBase/2014/1-2.xml::05192014.1525::H2在6ms INFO 5/26/14 9:18 Am:LiquiBase:LiquiBase/Changelog.xml:LiquiBase/2014/1-2.xml::05192014.1525::H2:读取test_common.databaseChangelog INFO 5/26/14 9:18 Am:LiquiBase:成功释放变更日志锁

1. 当针对h2运行时，它将应用于公共架构，而不应用于test_common

INFO 5/26/14 9:45 AM:liquibase: Successfully acquired change log lock
INFO 5/26/14 9:45 AM:liquibase: Dropping Database Objects in schema: TEST_COMMON.PUBLIC
INFO 5/26/14 9:45 AM:liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
INFO 5/26/14 9:45 AM:liquibase: Creating database history table with name: PUBLIC.DATABASECHANGELOG
INFO 5/26/14 9:45 AM:liquibase: Successfully released change log lock
INFO 5/26/14 9:45 AM:liquibase: Successfully acquired change log lock
INFO 5/26/14 9:45 AM:liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO 5/26/14 9:45 AM:liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO 5/26/14 9:45 AM:liquibase: Reading from PUBLIC.DATABASECHANGELOG
INFO 5/26/14 9:45 AM:liquibase: liquibase/changelog.xml: liquibase/2014/1-1.xml::05192014.1525::h2: Reading from

public.databasechangelog信息5/26/14 9:45上午：LiquiBase：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml信息5/26/14 9:45 AM：LiquiBase：LiquiBase/Changelog.xml：LiquiBase/Changelog.xml：LiquiBase/2014/1-2.xml::05192014.1525::h2:正在读取Public.DatabaseChangelog信息5/26/14 9:45 AM：LiquiBase：LiquiBase/Changelog.xml：LiquiBase/2014/1-2.xml::05192014.1525::h2:插入到网络信息中的新行.xml::05192014.1525::h2:新行插入网络信息5/26/14 9:45 AM：LiquiBase：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase/changelog.xml：LiquiBase 1525::h2:ChangeSet LiquiBase/2014/1-2.xml::05192014.1525::h2在5ms INFO 5/26/14 9:45 am：LiquiBase:LiquiBase/Changelog.xml:LiquiBase/2014/1-2.xml::05192014.1525::h2:读取Public.DatabaseChangelog INFO 5/26/14 9:45 am：LiquiBase:成功释放变更日志锁

这里出了什么问题？

Answer 1

Liquibase尝试同时处理“模式”和“目录”，其中目录是最顶部的容器，可以包含模式，也可以不包含模式。对于像MySQL这样只有一级对象分组的数据库，“目录”和“模式”是可以互换的。对于H2，您可以在数据库中同时拥有目录/数据库和模式。您的h2安装程序使用的是test_common数据库，但使用的是该数据库中的默认公共模式。

如果您希望配置Liquibase以使用非默认的H2模式，请使用“DefaultSchema”SpringLiquibase配置属性。