/Java/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

1 vote254 views1 answer
Java copy list
Java
0 vote258 views1 answer
Java code for square
Java
3 votes239 views1 answer
Javafx center node in gridpane
Java
0 vote249 views2 answers
Enhanced for loop with arraylist
Java
2 votes264 views2 answers
How to replace a character with another character in a string in java
Java
0 vote248 views3 answers
Set java path on linux ubuntu
Java
1 vote297 views1 answer
What is java plug-in
Java
0 vote263 views1 answer
Getresources in adapter android
Java
0 vote226 views1 answer
Edittext editable false android java
Java
0 vote235 views1 answer
A Java-8 stream of batches,
Java