Adding ability to read result sets row-by-row for MySql driver [SPR-14028]

[spring-projects-issues]

Uladzimir Zhuraulevich opened SPR-14028 and commented

In org.springframework.jdbc.core.JdbcTemplate:

protected void applyStatementSettings(Statement stmt) throws SQLException {
int fetchSize = getFetchSize();
if (fetchSize >= 0) {
stmt.setFetchSize(fetchSize);
}
int maxRows = getMaxRows();
if (maxRows >= 0) {
stmt.setMaxRows(maxRows);
}
DataSourceUtils.applyTimeout(stmt, getDataSource(), getQueryTimeout());
}

There is no ability to set streaming mode for fetching row-by-row.
Look at ResultSet here http://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html

---

Referenced from: commits 0b1639d

[spring-projects-issues]

Juergen Hoeller commented

As of 4.3, JdbcTemplate passes negative values other than -1 on to the driver. -1 is defined to have special semantics in JdbcTemplate itself, namely using the JDBC driver's own configuration (not setting any specific value on our end).