Java spring hibernate.ddl-auto: none property is somehow overrided

Question

I have problem with hibernate.ddl-auto: none in spring. It works fine in development environment and does not execute sql's like drop table. But in production environment same property seems like it's not working. And execute drop and create tables sql's. In application.yaml on production:

spring:
  jpa:
    hibernate.ddl-auto: none

I checked this value in application by this:

@Bean
public CommandLineRunner initProject() {
    return (args) -> {
        logger.info(env.getProperty("spring.jpa.hibernate.ddl-auto")); //this prints "create"

So it looks like some internal code changed it value. I run application by this command:

./mvnw spring-boot:run

I have something like this in application.yaml profiles: active: development This was in development, in production I have not. But when I copied this to production application.yaml it doesn't change anything — PianistaMichal
– PianistaMichal, Commented Apr 8, 2021 at 16:51

Dirk Deyne · Accepted Answer · 2021-04-08 17:18:19Z

4

The value has to come from somewhere...

You can easily trace this if you have actuator enabled

 <dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-actuator</artifactId>
 </dependency>

And expose the env endpoint via

management:
  endpoints:
    web:
      exposure:
        include: env

Then you can visit that endpoint via /actuator/env Here you can even find the location where you have defined the value.

{
  "name": "Config resource 'class path resource [application.yaml]' via location 'optional:classpath:/'",
  "properties": {
  "spring.jpa.hibernate.ddl-auto": {
    "value": "none",
    "origin": "class path resource [application.yaml] - 3:25"
},
  "management.endpoints.web.exposure.include": {
  "value": "env",
  "origin": "class path resource [application.yaml] - 9:18"
}...

answered Apr 8, 2021 at 17:18

Dirk Deyne

6,9961 gold badge22 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

PianistaMichal Over a year ago

Thanks for answet. With this I find out that I have in target folder old file application.properties which overrides data from application.yaml. I though this file will be deleted automatically. For this to work I had to remove folder target

Daniel Zin · Accepted Answer · 2021-04-08 16:52:59Z

0

The value none is undocumented, use validate instead. See also:What are the possible values of the Hibernate hbm2ddl.auto configuration and what do they do

answered Apr 8, 2021 at 16:52

Daniel Zin

4992 silver badges8 bronze badges

2 Comments

PianistaMichal Over a year ago

With validate value it also doesn't change anything. In console it prints "create" and also works like create. That mean it drops all tables and creates it back

Daniel Zin Over a year ago

So, probably your property is overridden in production mode. Do you have production-specific profile configuration?

Collectives™ on Stack Overflow

Java spring hibernate.ddl-auto: none property is somehow overrided

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related