/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

0 vote205 views2 answers
Java meeting scheduler
Java
3 votes209 views1 answer
How to append character at first position in stringbuilder java
Java
22 votes188 views1 answer
Java how to stop code
Java
2 votes199 views1 answer
HOW TO CODE JAVA???????????
Java
0 vote228 views1 answer
How to save rich text format in database using java
Java
0 vote201 views4 answers
Java mahout get clusters centers
Java
0 vote199 views1 answer
My animal list
Java
0 vote194 views2 answers
Android pass object to activity
Java
1 vote188 views3 answers
Recursion java
Java
0 vote223 views2 answers
Android httpurlconnection post multipart/form-data
Java