/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

15 votes319 views2 answers
How to create a list in java
Java
0 vote271 views2 answers
Android studio change title bar text
Java
1 vote289 views1 answer
Define an array of size n in java
Java
3 votes298 views2 answers
What is void in java
Java
0 vote297 views1 answer
Example: My favorite cities
Java
1 vote299 views1 answer
Javax.xml.bind does not exist
Java
4 votes353 views1 answer
Connect sql server to xampp
Java Spring
1 vote326 views2 answers
Java check two dates same day
Java
0 vote255 views1 answer
Java socket timeout
Java
2 votes293 views1 answer
Java random unique key
Java