Example usage for org.springframework.jdbc.core JdbcTemplate setSkipUndeclaredResults

Introduction

In this page you can find the example usage for org.springframework.jdbc.core JdbcTemplate setSkipUndeclaredResults.

Prototype

public void setSkipUndeclaredResults(boolean skipUndeclaredResults) 

Source Link

Document

Set whether undeclared results should be skipped.

Usage

From source file:com.github.akiraly.db4j.CommonDbConfig.java

@Bean
public JdbcTemplate jdbcTemplate(DataSource dataSource) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource, false);
    jdbcTemplate.setSkipUndeclaredResults(true);
    return jdbcTemplate;
}

---

From source file:org.springframework.jdbc.object.StoredProcedureTests.java

public void testStoredProcedureSkippingUndeclaredResults() throws Exception {
    MockControl ctrlResultSet1 = MockControl.createControl(ResultSet.class);
    ResultSet mockResultSet1 = (ResultSet) ctrlResultSet1.getMock();
    mockResultSet1.next();//from  w  w w . j a va 2s .  c  om
    ctrlResultSet1.setReturnValue(true);
    mockResultSet1.getString(2);
    ctrlResultSet1.setReturnValue("Foo");
    mockResultSet1.next();
    ctrlResultSet1.setReturnValue(true);
    mockResultSet1.getString(2);
    ctrlResultSet1.setReturnValue("Bar");
    mockResultSet1.next();
    ctrlResultSet1.setReturnValue(false);
    mockResultSet1.close();
    ctrlResultSet1.setVoidCallable();

    mockCallable.execute();
    ctrlCallable.setReturnValue(true);
    mockCallable.getUpdateCount();
    ctrlCallable.setReturnValue(-1);
    mockCallable.getResultSet();
    ctrlCallable.setReturnValue(mockResultSet1);
    mockCallable.getMoreResults();
    ctrlCallable.setReturnValue(true);
    mockCallable.getUpdateCount();
    ctrlCallable.setReturnValue(-1);
    mockCallable.getMoreResults();
    ctrlCallable.setReturnValue(false);
    mockCallable.getUpdateCount();
    ctrlCallable.setReturnValue(-1);
    if (debugEnabled) {
        mockCallable.getWarnings();
        ctrlCallable.setReturnValue(null);
    }
    mockCallable.close();
    ctrlCallable.setVoidCallable();

    mockConnection.prepareCall("{call " + StoredProcedureWithResultSetMapped.SQL + "()}");
    ctrlConnection.setReturnValue(mockCallable);

    replay();
    ctrlResultSet1.replay();

    JdbcTemplate jdbcTemplate = new JdbcTemplate(mockDataSource);
    jdbcTemplate.setSkipUndeclaredResults(true);
    StoredProcedureWithResultSetMapped sproc = new StoredProcedureWithResultSetMapped(jdbcTemplate);
    Map res = sproc.execute();

    ctrlResultSet1.verify();

    assertEquals("incorrect number of returns", 1, res.size());

    List rs1 = (List) res.get("rs");
    assertEquals(2, rs1.size());
    assertEquals("Foo", rs1.get(0));
    assertEquals("Bar", rs1.get(1));
}

---