ibatiS 查询数据量大 出现内存不足

[susanlin8]

系统内存不足。请对大型 ResultSet 使用服务器端游标: Java heap space。ResultSet 大小:21,751,046。JVM 总内存大小:66,650,112。; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
xml 源码
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="schoolstyle">

<typeAlias alias="schoolstyle" type="com.gxedu.resource.schoolstyle.Schoolstyle" />
<!--
===================================================select==========================================
-->
<select id="getSchoolstyleBynews" parameterClass="Schoolstyle" resultClass="Schoolstyle">
select * from informations
<dynamic prepend="where">
<isNotNull prepend="and" property="parts_ids">
parts_ids like '%$parts_ids$%'
</isNotNull>
<isNotNull prepend="and" property="channel_id">
channel_id=#channel_id#
</isNotNull>
<isNotNull prepend="and" property="status">
status=#status#
</isNotNull>
<isNotNull prepend="and" property="is_instant_flash">
is_instant_flash=#is_instant_flash#
</isNotNull>
</dynamic>
</select>

</sqlMap>
如何解决，望各位高手指点！最好能举个例子

[商科程序员]

分页吧.