How to manage a large dataset using Spring MySQL and RowCallbackHandler
Posted
by rmarimon
on Stack Overflow
See other posts from Stack Overflow
or by rmarimon
Published on 2010-01-19T17:25:46Z
Indexed on
2010/05/14
13:54 UTC
Read the original article
Hit count: 387
I'm trying to go over each row of a table in MySQL using Spring and a JdbcTemplate. If I'm not mistaken this should be as simple as:
JdbcTemplate template = new JdbcTemplate(datasource);
template.setFetchSize(1);
// template.setFetchSize(Integer.MIN_VALUE) does not work either
template.query("SELECT * FROM cdr", new RowCallbackHandler() {
public void processRow(ResultSet rs) throws SQLException {
System.out.println(rs.getString("src"));
}
});
I get an OutOfMemoryError because it is trying to read the whole thing. Any ideas?
© Stack Overflow or respective owner