mybatis游标使用,游标要关闭,否则第二次发布会出现
Caused by: java.io.IOException: Connection reset by peer
用postman调用返回数据过大,postman在最终返回时终止连接
aused by: java.io.IOException: 远程主机强迫关闭了一个现有的连接。
at sun.nio.ch.SocketDispatcher.write0(Native Method)
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:51)
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93)
at sun.nio.ch.IOUtil.write(IOUtil.java:65)
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:469)
使用示例:
Cursor<HomonymousPointInfo> domainList =null;
try{
QueryWrapper<H> query = new QueryWrapper<>();
if(null != mIds && mds.size()>0){
query.in("m_id",mIds);
}
if(null !=sId){
query.eq("s_id",sId);
}
if(null != begin && null != limit){
query.gt("id",begin);
query.last("limit "+limit);
}
if(null !=t){
query.eq("t",t);
}
MyExport myExport = new MyExport();
domainList = hoMapper.listData(query,myExport);
Iterator<H> iter = domainList.iterator();
int num=0;
while (iter.hasNext()){
H tmp =iter.next();
result.add(tmp);
num++;
}
}else{
log.info("",,);
}
}catch (Exception e){
log.error("失败,条件:{},异常:{}",mIds,e.getMessage(),e);
}finally {
if (null != domainList) {
try {
domainList.close();
} catch (Exception e) {
log.error("游标关闭失败:{}",e.getMessage(), e);
}
}
}