Hi Ranchers,
I am learning Spring boot, can some please let me know this property
spring.jpa.show-sql=true
i ave simple database connection with MYSQL using
JDBC template, where data is getting inserted, but i want to see the query on console
so i have included the above statement but still nothing is visible on console.
Note: i am not using Hibernate as of now.
also i noticed
spring.datasource.url=jdbc:mysql://localhost:3306/springbootdb
spring.datasource.username=root
spring.datasource.password=
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=create-drop
among the above entries in application.properties file it is not taking username as root, so i got a error stating
"access to user ' '@localhost is denied for database 'springbootdb'
then in mysql i grant all privilege to all users then the error went and started inserting the data,
also i have used create-drop but the table is not getting dropped it is just updating.
please let me know is there anything is wrong. thanks.