How to Mock Datasource in spring JdbcTemplate

Question

Please help me to mock below code .Not able to mock getDataSource() which is calling upon JdbcTemplate object.

@Override
public List<AttributeThresholdRange> getThresholdsRangeForXHS(QueryThresholdsRequest queryThresholdsRequest) {

    ArrayOfString attributeGroupIds = queryThresholdsRequest.getAttributeGroupIds();
    Map<String, Object> queryParams = new HashMap<>();
    queryParams.put("groupids", attributeGroupIds.getStrings());

    return new NamedParameterJdbcTemplate(admDatabaseConnector.getJdbcTemplate().getDataSource())
            .query(DBQueryConstants.ADM_QUERY_GET_THRESHOLDS_RANGE_FOR_XHS, 
                    queryParams,
                    new ResultSetExtractor<List<AttributeThresholdRange>>() {
                @Override
                public List<AttributeThresholdRange> extractData(ResultSet resultSet) throws SQLException,DataAccessException  {

                    return null;
                }
            });
}

is admDatabaseConnector autowrired? – Maciej Kowalski Mar 08 '17 at 09:52 — Maciej Kowalski, Mar 08 '17 at 09:52
also do you want to unit test it or integration test it? – Maciej Kowalski Mar 08 '17 at 09:54 — Maciej Kowalski, Mar 08 '17 at 09:54

score 1 · Accepted Answer · edited Mar 08 '17 at 19:42

1

what´s the Mock framework are you using?

If you are using Mockito just Mock the jdbcTemplate and put this method in the when() clause.

when(admDatabaseConnector.getJdbcTemplate().getDataSource())
            .query(anyObject(), anyObject(), anyObject())).thenReturn("Your return queryobject");

You must declare the admDatabaseConnector in the Mock.

edited Mar 08 '17 at 19:42

Brad

15,186
11
60
74

answered Mar 08 '17 at 12:45

Marcos Pierre A. P. Matins

26
1

Thanks You .I used this logic and my Junit code is working fine. – Gaurav Mar 09 '17 at 06:11
@Gaurav If this answer worked for you, you should accept the answer so that it's obvious – Stewart Oct 25 '17 at 15:09

How to Mock Datasource in spring JdbcTemplate

1 Answers1