/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 vote151 views1 answer
Compress a directory in java
Java
0 vote170 views1 answer
Site:stackoverflow.com List is abstract; cannot be instantiated public List<Integer> result = new List<>();
Java
0 vote117 views1 answer
Java filter list based on unique value
Java
0 vote162 views2 answers
Java fill two dimensional array stream
Java
0 vote144 views1 answer
ClassNotFoundException: org.springframework.ui.freemarker.FreeMarkerConfigurationFactory
Java
0 vote147 views1 answer
How to run the war file in Apache Tomcat/8.5.59 THROUGH SPRING
Java
1 vote165 views1 answer
Difference between java and javax
Java
12 votes168 views2 answers
ActionListener java
Java
1 vote159 views2 answers
Change button text by id click java
Java
1 vote146 views1 answer
Filter arraylist java
Java