ibatis 存储过程返回cursor

[celityowce]

ibatis版本ibatis-2.3.4.726，以下是过程代码：
CREATE OR REPLACE PACKAGE P_ASJ_ZDYBB AS
TYPE LIST_CURSOR IS REF CURSOR;
PROCEDURE GETLIST_ZDYBB(AJBH IN VARCHAR2, OUTLIST OUT LIST_CURSOR);
END P_ASJ_ZDYBB;

CREATE OR REPLACE PACKAGE BODY P_ASJ_ZDYBB AS
PROCEDURE GETLIST_ZDYBB(AJBH IN VARCHAR2, OUTLIST OUT LIST_CURSOR) IS
--SQL_STR VARCHAR2(5000);
BEGIN
OPEN OUTLIST FOR
SELECT T.AJBH, T.WRITID, T.AJMC, T.AJLX
FROM B_ASJ_WS T
WHERE ROWNUM < 20;
END GETLIST_ZDYBB;
END P_ASJ_ZDYBB;
返回的是一个游标。
xml配置信息如下：
以下是错误信息：
--- The error occurred in sqlmap/asj_cd_zdybbMap.xml.
--- The error occurred while applying a result map.
--- Check the zdybb.rec_result.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/asj_cd_zdybbMap.xml.
--- The error occurred while applying a result map.
--- Check the zdybb.rec_result.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException
[DEBUG] [16:53:10] org.springframework.web.servlet.handler.SimpleMappingExceptionResolver - Resolving to default view 'defaultException' for exception of type [org.springframework.jdbc.UncategorizedSQLException]
[DEBUG] [16:53:10] org.springframework.web.servlet.handler.SimpleMappingExceptionResolver - Exposing Exception as model attribute 'exception'
[DEBUG] [16:53:10] org.springframework.web.servlet.DispatcherServlet - Handler execution resulted in exception - forwarding to resolved error view: ModelAndView: reference to view with name 'defaultException'; model is {exception=org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in sqlmap/asj_cd_zdybbMap.xml.
--- The error occurred while applying a result map.
--- Check the zdybb.rec_result.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/asj_cd_zdybbMap.xml.
--- The error occurred while applying a result map.
--- Check the zdybb.rec_result.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException}
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in sqlmap/asj_cd_zdybbMap.xml.
--- The error occurred while applying a result map.
--- Check the zdybb.rec_result.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/asj_cd_zdybbMap.xml.
--- The error occurred while applying a result map.
--- Check the zdybb.rec_result.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException
Caused by:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/asj_cd_zdybbMap.xml.
--- The error occurred while applying a result map.
--- Check the zdybb.rec_result.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:188)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:566)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:541)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:244)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:242)
at com.hnii.poli.view.dao.Zdybb_Dao.out_list(Zdybb_Dao.java:42)
at com.hnii.poli.logic.impl.Zdybb_Impl.out_list(Zdybb_Impl.java:23)
at com.hnii.poli.logic.impl.Zdybb_action.handleRequest(Zdybb_action.java:32)
at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:859)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:793)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
at com.hnii.poli.filter.MainFiler.doFilter(MainFiler.java:110)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3270)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2019)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1925)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1394)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
Caused by: java.lang.NullPointerException
at org.apache.commons.dbcp.DelegatingResultSet.close(DelegatingResultSet.java:132)
at sun.reflect.GeneratedMethodAccessor58.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.ibatis.common.jdbc.logging.ResultSetLogProxy.invoke(ResultSetLogProxy.java:47)
at $Proxy38.close(Unknown Source)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.closeResultSet(SqlExecutor.java:529)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure(SqlExecutor.java:290)
at com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:34)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
... 32 more
[DEBUG] [16:53:10] org.springframework.web.servlet.view.InternalResourceViewResolver - Cached view [defaultException]
[DEBUG] [16:53:10] org.springframework.web.servlet.DispatcherServlet - Rendering view [org.springframework.web.servlet.view.JstlView: name 'defaultException'; URL [/jsp/defaultException.jsp]] in DispatcherServlet with name 'Dispatcher'
[DEBUG] [16:53:10] org.springframework.web.servlet.view.JstlView - Rendering view with name 'defaultException' with model {exception=org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in sqlmap/asj_cd_zdybbMap.xml.
--- The error occurred while applying a result map.
--- Check the zdybb.rec_result.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/asj_cd_zdybbMap.xml.
--- The error occurred while applying a result map.
--- Check the zdybb.rec_result.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException} and static attributes {}


纠结了一整天，网上的方法都试过了。。。

[forgetsam]

jdbcType="ORACLECURSOR" 再检查一遍。

[panzhixiong_cn]

去掉resultMap="rec_result"试试？

[panzhixiong_cn]

http://blog.csdn.net/xiaojunhu/article/details/4375976 这个链接可以参考一下。