SpringBoot2.0以上无法执行sql脚本

schema:
  - classpath:department.sql
# springboot2.0以上版本需要添加上这个才能执行sql本
initialization-mode: always

原理：

DataSourceInitializer执行创建函数时增加了类型判断

void initSchema() {
    List<Resource> scripts = this.getScripts("spring.datasource.data", this.properties.getData(), "data");
    if (!scripts.isEmpty()) {
        if (!this.isEnabled()) {
            logger.debug("Initialization disabled (not running data scripts)");
            return;
        }
    
        String username = this.properties.getDataUsername();
        String password = this.properties.getDataPassword();
        this.runScripts(scripts, username, password);
    }
}

private boolean isEnabled() {
    DataSourceInitializationMode mode = this.properties.getInitializationMode();
    if (mode == DataSourceInitializationMode.NEVER) {
        return false;
    } else {
        return mode != DataSourceInitializationMode.EMBEDDED || this.isEmbedded();
    }
}