How to set Spring boot property with underscore in its name through environment variables?

Question

I want to install hibernate.format_sqlSpring downloads in an application. I want to set it using environment variables.

Spring Boot pretty conveniently converts all environment variables from, for example, FOO_BAR_BAZto properties called foo.bar.bazinside the Spring context.

How to set underscore property in target name in Spring Boot using environment variables? Supposedly to HIBERNATE_FORMAT_SQLbe translated into hibernate.format.sql?

Answer 1

, , - (, ) , .

HIBERNATE_FORMAT_SQL

, "", Spring.

. . "hibernate.format.sql" :

• hibernate.format.sql( )
• hibernate_format_sql ( )
• hibernate_format_sql ( , )
• hibernate_format_sql ( , )

UPPERCASE:

5. HIBERNATE.FORMAT.SQL( )
6. HIBERNATE_FORMAT_SQL ( )
7. HIBERNATE_FORMAT_SQL ( , )
8. HIBERNATE_FORMAT_SQL ( , )

​​ set export, env. , :

env "my.dotted.name=\"a value\"" the-command-you-want-to-run

SystemEnvironmentPropertySource.java . , , .

, :

logging:
  level:
    org.springframework.core.env: DEBUG

... :)

Answer 2

SPRING_JPA_SHOW_SQL=true . , , , Spring - . , .