spring.datasource.schema指定启动后执行的sql文件位置。 出现中文乱码,因为没有执行sql script encoding: spring: datasource: url: "jdbc:h2:mem:test" username: "sa" password: "" //脚本文件目录 schema: database/import.sql //脚本编码格式 sql-script-encoding: utf-8 type: com.alibaba.druid.pool.DruidDataSource driver-class-name: org.h2.Driver maxActive: 20 initialSize: 1 maxWait: 60000 minIdle: 1 timeBetweenEvictionRunsMillis: 60000 minEvictableIdleTimeMillis: 300000 validationQuery: select 1 testWhileIdle: true testOnBorrow: false testOnReturn: false poolPreparedStatements: true maxOpenPreparedStatements: 20 maxPoolPreparedStatementPerConnectionSize: 20 filters: stat 修改完配置后,删除数据库重新执行,脚本可以正常执行。 |
|