JDBC连接mysql,查大数据集报:java.lang.OutOfMemoryError: Java heap space
http://blog.csdn.net/hwwn2009/article/details/42423039
1.使用spring jdbcTemplate做批量校验 (支持50万数据)
public void mxCheck(String tableName,Map<String,String> checkMap) {
String sql="SELECT * from "+ConstKey.SCHEMA_RPT.trim()+"." + tableName+" where 1=1";
final Map<String,String> map = checkMap;
jdbcTemplate.query(sql, new ResultSetExtractor<List>() {
@Override
public List extractData(ResultSet rs)
throws SQLException, DataAccessException {
List result = new ArrayList();
ResultSetMetaData md = rs.getMetaData(); //获得结果集结构信息,元数据
int columnCount = md.getColumnCount(); //获得列数
List<Map<String,Object>> list = new ArrayList<Map<String,Object