You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "joygxd (JIRA)" <ib...@incubator.apache.org> on 2005/05/09 04:11:06 UTC
[jira] Created: (IBATIS-124) ibatis access store procedure occur question
ibatis access store procedure occur question
--------------------------------------------
Key: IBATIS-124
URL: http://issues.apache.org/jira/browse/IBATIS-124
Project: iBatis for Java
Type: Task
Components: SQL Maps
Versions: 2.0.9b
Environment: tomcat 5.5.8
struts+spring+ibatis
Reporter: joygxd
Priority: Critical
help me,thanks.
mail:joygxd@163.com
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
[jira] Closed: (IBATIS-124) ibatis access store procedure occur question
Posted by "Brandon Goodin (JIRA)" <ib...@incubator.apache.org>.
[ http://issues.apache.org/jira/browse/IBATIS-124?page=all ]
Brandon Goodin closed IBATIS-124:
---------------------------------
Assign To: Brandon Goodin
Resolution: Invalid
I'm assuming the posting of this issue to JIRA was an accident considering I asked you to post this to the user list when it was issue IBATIS-123. Please do not post support questions to JIRA. Instead post them to the ibatis-user-java list.
> ibatis access store procedure occur question
> --------------------------------------------
>
> Key: IBATIS-124
> URL: http://issues.apache.org/jira/browse/IBATIS-124
> Project: iBatis for Java
> Type: Task
> Components: SQL Maps
> Versions: 2.0.9b
> Environment: tomcat 5.5.8
> struts+spring+ibatis
> Reporter: joygxd
> Assignee: Brandon Goodin
> Priority: Critical
>
> help me,thanks.
> mail:joygxd@163.com
> 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