Spring Boot 1.4 @DataJpaTest - Error creating bean with name 'dataSource'

Question

I've created a new spring boot 1.4 application, want to try some testing using @DataJpaTest but keep getting the following error message

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource': Invocation of init method failed; nested exception is java.lang.IllegalStateException: Cannot determine embedded database for tests. If you want an embedded database please put a supported one on the classpath.

src/main/resources/application.properties

spring.datasource.url=jdbc:mysql://localhost/my_db
spring.datasource.username=user
spring.datasource.password=password
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

MyRepositoryTest

@RunWith(SpringRunner.class)
@DataJpaTest
final public class MyRepositoryTest {
}

build.gradle

dependencies {
    compile 'org.springframework.boot:spring-boot-starter-web',
            'org.springframework.boot:spring-boot-starter-data-jpa',
            'mysql:mysql-connector-java',
            'org.projectlombok:lombok:1.16.10'

    testCompile('org.springframework.boot:spring-boot-starter-test')
}

Any ideas what i am doing wrong?

@ Matt, You have to add MySQL configuration class to establish connection through your mysql-connector-java client. And check whether if it is MySQL driver jar is added in your class path. — Praveen Kumar K S
I was hoping to use the embedded database for JPA testing... @PraveenKumar — Matt
you need to explicitly set the embedded database in your class path. — Praveen Kumar K S

Stephane Nicoll Stephane Nicoll · Accepted Answer · 2016-12-24T20:16:17

We don't provide an embedded database by default. By default DataJpaTest replaces your DataSource with an embedded database but you don't have one.

So, if you want to test with MySQL, replace your test as follows:

@RunWith(SpringRunner.class)
@DataJpaTest
@AutoConfigureTestDatabase(replace = NONE)
final public class MyRepositoryTest {
}

If you want to use an in-memory database for those tests, you need to add one to the test classpath. Add this to your gradle file

testCompile('com.h2database:h2')

Spring Boot 1.4 @DataJpaTest - Error creating bean with name 'dataSource'

1 Answers