Skip to content

Instantly share code, notes, and snippets.

@asaushkin
Last active October 19, 2022 11:18
Show Gist options
  • Save asaushkin/fb1f9070a37f35b164c0b12e26cf551f to your computer and use it in GitHub Desktop.
Save asaushkin/fb1f9070a37f35b164c0b12e26cf551f to your computer and use it in GitHub Desktop.
application.properties for PostgreSQL datasource
####################################################
# application.properties for PostgreSQL
## Spring DATASOURCE (DataSourceAutoConfiguration & DataSourceProperties)
spring.datasource.url=jdbc:postgresql://localhost:5432/dlabapi
spring.datasource.username=postgres
spring.datasource.password=
# Disable feature detection by this undocumented parameter. Check the org.hibernate.engine.jdbc.internal.JdbcServiceImpl.configure method for more details.
spring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults = false
# Because detection is disabled you have to set correct dialect by hand.
spring.jpa.database-platform=org.hibernate.dialect.PostgreSQL95Dialect
# The SQL dialect makes Hibernate generate better SQL for the chosen database
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.PostgreSQL95Dialect
spring.jpa.hibernate.show_sql=true
spring.jpa.hibernate.format_sql=true
# Hibernate ddl auto (create, create-drop, validate, update)
spring.jpa.hibernate.ddl-auto = create
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment