Make a fake javax.sql.DataSource?

Question

I have to write tests with String Test framework where many DB connections was used.

In test I don't need all data sources but Spring want them all to inject.

Are there any standard or well known fake javax.sql.DataSource implementation just to satisfy Spring DI mechanic?

The answer to this strongly depends on what the fake DataSources needs to be able to do. — Thorbjørn Ravn Andersen, Jun 18 '14 at 16:33
@ThorbjørnRavnAndersen Nothing to do. Just to satisfy Spring DI engine with object. No calls to `dataSource` expected. — gavenkoa, Jun 18 '14 at 16:36
[http://stackoverflow.com/questions/2457239/injecting-mockito-mocks-into-a-spring-bean](http://stackoverflow.com/questions/2457239/injecting-mockito-mocks-into-a-spring-bean) — Andrei Stefan, Jun 18 '14 at 16:39

score 5 · Answer 1 · edited May 04 '19 at 19:39

Using Mockito (or other mocking framwork) is preferred (as pointed out in other answers). However if you just want to make your application context up (without complaining about data source), you can use org.springframework.jdbc.datasource.SimpleDriverDataSource.

You need to provide bean to the context with the name which overrides the original bean and make sure your fake bean is scanned first.

@Configuration
public class MyFakeConfig {

  @Bean(name = "NAME OF THE ORIGINAL BEAN TO OVERRIDE")
  public DataSource fakeDataSource() {
    return new SimpleDriverDataSource()

  }
}

score 3 · Accepted Answer · edited May 23 '17 at 12:09

3

You can use Mockito framework. Using Springockito you can mock your datasources on a Spring environment.

Credit of this resource is for kubek2k in this SO answer.

edited May 23 '17 at 12:09

Community

1
1

answered Jun 18 '14 at 16:31

Spacemonkey

1,725
3
20
44

I afraid that `mock(JdbcTemplate.class);` can't be used in Spring .xml config, seems I have to migrate to Java config.... – gavenkoa Jun 18 '14 at 16:33
I found `Springockito` is a best approach as also can fake some other parts. +1 – gavenkoa Jun 18 '14 at 16:42

score 3 · Answer 3 · answered Jun 18 '14 at 16:31

3

I do not know well known DataSource mock. You can mock it yourself using one of mock frameworks (e.g. Mockito) but IMHO better solution is to use pure java in-memory database like H2, HSQLDB or Derby. You will get real data source with real data that you can fill in test code programmatically and simulate any situation that can happen in your production code.

answered Jun 18 '14 at 16:31

AlexR

114,158
16
130
208

Thanks for suggestion! I thought about such solution but expected to find simple and non bloated solution. – gavenkoa Jun 18 '14 at 16:35
1

It is simple. The first setup indeed will take an hour or two, but it will help you in future. – AlexR Jun 18 '14 at 16:37

score 2 · Answer 4 · answered Oct 19 '18 at 13:38

2

You can use Spring's org.springframework.jdbc.datasource.AbstractDataSource which already provides some defaults for most of the interface methods. You only need to override two.

answered Oct 19 '18 at 13:38

jhyot

3,733
1
27
44

gavenkoa · Answer 5 · 2021-08-29T12:04:09.790

This is my sample which does the job:

<!-- Create object with mocked parts that not used. -->
<bean id="config" class="org.Config">
    <constructor-arg>
        <bean class="org.mockito.Mockito" factory-method="mock">
            <constructor-arg value="javax.sql.DataSource"/>
        </bean>
    </constructor-arg>
    <property name="day" value="6"/>
</bean>

Update pom.xml with:

<dependency>
  <groupId>org.mockito</groupId>
  <artifactId>mockito-all</artifactId>
  <version>1.9.5</version>
  <scope>test</scope>
</dependency>

It works with:

<spring.version>3.0.0.RELEASE</spring.version>

Make a fake javax.sql.DataSource?

5 Answers5