/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 vote360 views1 answer
Java format double no decimal places
Java
0 vote358 views1 answer
Flink prometheus alert on failed jobs
Java
10 votes359 views2 answers
How to set 2 decimal places in java
Java
1 vote394 views1 answer
Jdbc ResultSet test null
Java
0 vote372 views1 answer
Check if combobox has specified value
Java
1 vote367 views1 answer
Java check if able to parse int
Java
-1 vote348 views2 answers
Android set focus on edittext
Java
0 vote374 views1 answer
Java parse unix timestamp
Java
1 vote360 views1 answer
Spigot kill entity
Java
45 votes359 views5 answers
Java iterate through hashmap
Java