我在开发阶段使用了schema.sql和data.sql,但是我需要向服务器发布一个版本,所以我将ddl-auto=none修改为ddl-auto=update,但是在我重新执行之后,schema.sql和data.sql仍然被执行,为什么?
这是我的配置:
server:
port: 8081
spring:
jpa:
hibernate:
ddl-auto: update
show-sql: true
database-platform: org.hibernate.dialect.MySQL5InnoDBDialect
profiles:
active: prod
下面是我的日志:
2020-05-26 12:57:49.412 INFO 3642 --- [ main] o.s.jdbc.datasource.init.ScriptUtils : Executing SQL script from URL [file:/Users/shawnwu4mac/IdeaProjects/UTM-system-LSTM/target/classes/schema.sql]
2020-05-26 12:57:52.587 INFO 3642 --- [ main] o.s.jdbc.datasource.init.ScriptUtils : Executed SQL script from URL [file:/Users/shawnwu4mac/IdeaProjects/UTM-system-LSTM/target/classes/schema.sql] in 3175 ms.
2020-05-26 12:57:52.592 INFO 3642 --- [ main] o.s.jdbc.datasource.init.ScriptUtils : Executing SQL script from URL [file:/Users/shawnwu4mac/IdeaProjects/UTM-system-LSTM/target/classes/data.sql]
2020-05-26 12:57:53.785 INFO 3642 --- [ main] o.s.jdbc.datasource.init.ScriptUtils : Executed SQL script from URL [file:/Users/shawnwu4mac/IdeaProjects/UTM-system-LSTM/target/classes/data.sql] in 1193 ms.
2020-05-26 12:57:53.962 INFO 3642 --- [ main] j.LocalContainerEntityManagerFactoryBean : Building JPA container EntityManagerFactory for persistence unit 'default'
2020-05-26 12:57:53.972 INFO 3642 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [
name: default
...]
2020-05-26 12:57:54.028 INFO 3642 --- [ main] org.hibernate.Version : HHH000412: Hibernate Core {5.0.12.Final}
2020-05-26 12:57:54.029 INFO 3642 --- [ main] org.hibernate.cfg.Environment : HHH000206: hibernate.properties not found
2020-05-26 12:57:54.030 INFO 3642 --- [ main] org.hibernate.cfg.Environment : HHH000021: Bytecode provider name : javassist
2020-05-26 12:57:54.060 INFO 3642 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
2020-05-26 12:57:54.137 INFO 3642 --- [ main] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
2020-05-26 12:57:54.527 INFO 3642 --- [ main] org.hibernate.tool.hbm2ddl.SchemaUpdate : HHH000228: Running hbm2ddl schema update
2020-05-26 12:58:00.756 INFO 3642 --- [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
发布于 2020-05-26 13:37:38
您还必须为您的yml添加以下属性。对我来说效果很好。
spring:
jpa:
generate-ddl: true
https://stackoverflow.com/questions/62015127
复制相似问题