/Java/Spring/Spring application properties mysql jpa

Spring application properties mysql jpa

spring.datasource.url=jdbc:mysql://localhost:yourDatabase?serverTimezone=UTC
//set username and password as environment variables under application configuration so that the real ones won't be pushed to github, only their aliases: USERNAME and PASSWORD in this case. 
spring.datasource.username=${USERNAME} // instead of ${USERNAME} you may use a generic one as well, like 'root' but then it will be pushed to github with the app so anyone can see you username and password.
spring.datasource.password=${PASSWORD}
spring.jpa.hibernate.ddl-auto=create-drop //running after the first time (when the tables are created in the database) or later when you want the data remain for later tests you have to change the key word 'create-drop' to 'update' so that the data remains in place. Oops! the database itself without the tables needs to be created manually first.
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
spring.logging.level.org.hibernate.SQL=debug
spring.jpa.show-sql=true

Similar codes

0 vote324 views1 answer
If you are using the git profile, you need to set a Git URI in your configuration. If you have set spring.cloud.config.server.bootstrap=true, you need to use a composite configuration.
Java Spring
2 votes368 views2 answers
Spring boot param object
Java Spring
0 vote395 views1 answer
Entity cannot be resolved to a type in spring boot eclipse
Java Spring
0 vote360 views1 answer
Spring commandlinerunner example
Java Spring
0 vote314 views1 answer
Show all spring boot beans
Java Spring
1 vote346 views1 answer
Spring boot mongodb update subdocument
Java Spring
0 vote339 views1 answer
@crossorigin spring allow all
Java Spring
3 votes389 views3 answers
Spring xml
Java Spring
0 vote367 views1 answer
Spring swagger ui login oauth2
Java Spring
0 vote386 views1 answer
Spring boot interview questions 2020
Java Spring