/Java/Spring/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 vote331 views1 answer
Reponse entity as result spring controller
Java Spring
3 votes486 views3 answers
Spring mvc
Java Spring
4 votes333 views1 answer
Connect sql server to xampp
Java Spring
1 vote333 views1 answer
Spring boot
Java Spring
0 vote325 views1 answer
Pass a list of string as PathVariable to api spring boot
Java Spring
0 vote336 views1 answer
Database springboot
Java Spring
4 votes387 views1 answer
Dependency for spring security
Java Spring
0 vote315 views1 answer
Java spring username encode and decode
Java Spring
0 vote366 views1 answer
UserRedirectRequiredException: A redirect is required to get the users approval spring boot 5 security
Java Spring
1 vote321 views1 answer
Spring serve robots.txt
Java Spring