问题描述
- ibatis的一个错误, 大神求助啊~~~
-
SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];--- The error occurred in sqlMapConfig/forex/Trade.xml.
--- The error occurred while applying a result map.
--- Check the Trade.getSpotTradeIntByEraseNoResult.
--- The error happened while setting a property on the result object.
--- Cause: java.sql.SQLException: The query with id Trade.getSpotTradeIntByEraseNo already queried at least 50000 records. The maximum limit of query records is 50000.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlMapConfig/forex/Trade.xml.
--- The error occurred while applying a result map.
--- Check the Trade.getSpotTradeIntByEraseNoResult.
--- The error happened while setting a property on the result object.
--- Cause: java.sql.SQLException: The query with id Trade.getSpotTradeIntByEraseNo already queried at least 50000 records. The maximum limit of query records is 50000.
解决方案
查出超过5万条,用分页吧。太多内存也会爆的。
解决方案二:
应该是电脑问题 你要去百度找下