/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 vote362 views1 answer
Byte data type in java example
Java
0 vote325 views1 answer
Android studio doesnt work when in full screen mac os
Java
1 vote342 views1 answer
How to iterate a stack without iterator class
Java
0 vote342 views1 answer
How many return values can a method hava java
Java
0 vote315 views1 answer
Httpsession vs cookie servlet
Java
0 vote350 views1 answer
Random numeros negativos java
Java
0 vote347 views1 answer
Create JDBC connection using properties file
Java
0 vote328 views1 answer
Jsp multipart/form-data submition
Java
0 vote345 views1 answer
How to set opacity of background android
Java
1 vote323 views1 answer
Take string until /
Java