求教一个Ibatis后台报错的问题,数据库为oracle
后台报错,我走断点跟着发现是我在执行一个SQL查询的时候报的错:
<select id="selectTdSSeqctrl" parameterClass="TdSSeqctrl" resultMap="TdSSeqctrlResult">
SELECT * FROM TD_S_SEQCTRL
<include refid="where-all-condition"/>
</select>
查询结果又两万多条。我电脑myeclipse.ini,myeclipse的jdk,tomcat都更改过了内存的设置,
我tomcat,jdk已设置了-Xms256m -Xmx512m -XX:CompileThreshold=8000 -XX:PermSize=48m -XX:MaxPermSize=256m -Doracle.jdbc.V8Compatible=true
依然没有效果。还请各位大神帮忙看看原因,报错内容如下:
07-07 14:56:59 ERROR sitech.jcf.proxy.Impl.AllBeanProxy:71 - java.lang.OutOfMemoryError: Java heap space
at oracle.jdbc.driver.CharCommonAccessor.getString(CharCommonAccessor.java:404)
at oracle.jdbc.driver.T4CVarcharAccessor.getString(T4CVarcharAccessor.java:436)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:971)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:494)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:224)
at com.ibatis.sqlmap.engine.type.StringTypeHandler.getResult(StringTypeHandler.java:35)
at com.ibatis.sqlmap.engine.mapping.result.ResultMap.getPrimitiveResultMappingValue(ResultMap.java:619)
at com.ibatis.sqlmap.engine.mapping.result.ResultMap.getResults(ResultMap.java:345)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:419)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:336)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.iBatisExecuteQuery(SqlExecutor.java:224)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:186)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:222)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:190)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:295)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:1)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293)
at com.sitech.jcf.core.dao.BaseDao.queryForList(BaseDao.java:295)
at com.sitech.groupcust.common.dao.TdSSeqctrlDao.queryList(TdSSeqctrlDao.java:24)
at com.sitech.groupcust.busi.other.SeqctrlServiceImpl.selectCrmSeq(SeqctrlServiceImpl.java:99)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)