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
– Praveen Kumar K S, Commented Dec 24, 2016 at 17:33
I was hoping to use the embedded database for JPA testing... @PraveenKumar — Matt
– Matt, Commented Dec 24, 2016 at 17:37
you need to explicitly set the embedded database in your class path. — Praveen Kumar K S
– Praveen Kumar K S, Commented Dec 25, 2016 at 2:49

Francislainy Campos · Accepted Answer · 2021-10-24 02:03:30Z

129

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 = 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')

edited Oct 24, 2021 at 2:03

Francislainy Campos

4,2466 gold badges55 silver badges103 bronze badges

answered Dec 24, 2016 at 20:16

Stephane Nicoll

33.3k10 gold badges104 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Matt Over a year ago

If instead of wanting to provide the AutoConfigureTestDatabase, can i specify this in a properties file? i.e spring.test.database.connection: H2

Stephane Nicoll Over a year ago

Well you need to tell boot to not override your datasource so that annotation is required. Once you've done that you're free to configure the datasource any way you want. If you want more details, I'd create a seperate issue

Stephane Nicoll Over a year ago

Also, I've create an issue in our tracker as I am wondering if we couldn't do something smarter here. Feel free to subscribe for updates or share your toughts on what Spring Boot should do in such situation.

Matt Over a year ago

Thanks yes i'll subscribe, it'll be interesting to see the discussion

Jack BeNimble Over a year ago

@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)

Daniel Gutierrez · Accepted Answer · 2023-05-26 07:15:59Z

You could also configure this via application properties

spring: test: database: replace: none

Procrastinator · Accepted Answer · 2021-12-08 07:13:39Z

Please add this before your class.

@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)

it will run for sure.

Collectives™ on Stack Overflow

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

3 Answers 3

5 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

Comments

Linked

Related