/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 vote333 views1 answer
Mobile view next and previous button
Java
0 vote349 views1 answer
Java windowbuilder launch on second monitor
Java
1 vote331 views1 answer
InetAddress.getByAddress example
Java
0 vote313 views1 answer
Check if user has internet connection in kotlin
Java
0 vote359 views2 answers
Math square java
Java
0 vote311 views1 answer
Merge sort algorithm in java short answer
Java
0 vote316 views1 answer
WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
Java
-1 vote322 views1 answer
Start an activity in adapter
Java
0 vote326 views1 answer
Loop will array length java example
Java
0 vote348 views1 answer
+= operator casting in java
Java