Spring-boot datasource commit trouble

You can work with @Transactional tests. This allow you to run the test check the result and get BD rolled back to pre-test state.

Reference http://docs.spring.io/spring/docs/4.3.11.RELEASE/spring-framework-reference/htmlsingle#testcontext-tx-enabling-transactions

Hi for test classes instead of actual database you can go with In-Memory databases like DB2,derby and h2. it provides the solution for your trouble.

for Code example you can find below URL Spring data jpa repository In-memory test case

You would try use JPA for persisting. The following settings would be available:

spring.jpa.show-sql=true

Then you could see what went wrong.