ibatis access store procedure occur question
--------------------------------------------
Key: IBATIS-123
URL: http://issues.apache.org/jira/browse/IBATIS-123
Project: iBatis for Java
Type: Bug
Components: SQL Maps
Versions: 2.0.9b
Environment: tomcat 5.5.8
struts+spring+ibatis
Reporter: joygxd
help me,thanks.
mail:[EMAIL PROTECTED]
xml config:
<resultMap id="getAllotType" class="com.szjz.goldf.allot.dao.bean.AllotType">
<result property="id" column="BILLTYPEID" columnIndex="1"/>
<result property="allotTypeName" column="BILLTYPENAME" columnIndex="2"/>
<result property="allotTypeAlias" column="BILLTYPEALIAS"
columnIndex="3"/>
</resultMap>
<parameterMap id="get_result"
class="com.szjz.goldf.allot.dao.bean.AllotType">
<parameter property="result" mode="OUT" jdbcType="ORACLECURSOR"
javaType="java.lang.Object"/>
</parameterMap>
<procedure id="getSpList" parameterMap="get_result"
resultMap="getAllotType">
{call efm.sp_getAllotTypeList(?)}
</procedure>
code:
public List findAllotTypeList()
{
return getSqlMapClientTemplate().queryForList("getSpList",null);
}
error log:
2005-05-08 18:00:45,690 WARN struts.action.RequestProcessor:538 -> Unhandled
Exception thrown: class org.springframework.jdbc.UncategorizedSQLException
StandardWrapperValve[action]: Servlet.service() for servlet action threw
exception
org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient operation):
encountered SQLException [
--- The error occurred in com/szjz/goldf/allot/dao/bean/AllotType.xml.
--- The error occurred while preparing the mapped statement for execution.
--- Check the getSpList.
--- Check the parameter map.
--- Cause: java.lang.NullPointerException]; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/szjz/goldf/allot/dao/bean/AllotType.xml.
--- The error occurred while preparing the mapped statement for execution.
--- Check the getSpList.
--- Check the parameter map.
--- Cause: java.lang.NullPointerException
org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient operation):
encountered SQLException [
--- The error occurred in com/szjz/goldf/allot/dao/bean/AllotType.xml.
--- The error occurred while preparing the mapped statement for execution.
--- Check the getSpList.
--- Check the parameter map.
--- Cause: java.lang.NullPointerException]; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/szjz/goldf/allot/dao/bean/AllotType.xml.
--- The error occurred while preparing the mapped statement for execution.
--- Check the getSpList.
--- Check the parameter map.
--- Cause: java.lang.NullPointerException
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/szjz/goldf/allot/dao/bean/AllotType.xml.
--- The error occurred while preparing the mapped statement for execution.
--- Check the getSpList.
--- Check the parameter map.
--- Cause: java.lang.NullPointerException
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
