/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 vote205 views1 answer
Valueof in java
Java
21 votes176 views6 answers
Convert char to string in java
Java
1 vote219 views1 answer
Java get everything before a character
Java
3 votes213 views2 answers
Firebase auth dependency
Java
1 vote200 views2 answers
How to recognize a pressed key in java
Java
0 vote211 views1 answer
How to check number format exception in java
Java
1 vote240 views1 answer
Jda embed message
Java
3 votes215 views1 answer
What does cop mean
Java
0 vote213 views1 answer
React The href attribute is required for an anchor to be keyboard
Java
0 vote201 views1 answer
Textview set text bold programmatically
Java