[
http://issues.apache.org/jira/browse/IBATIS-149?page=comments#action_12313298 ]
Nilesh Kapadia commented on IBATIS-149:
---------------------------------------
public class DisplaceSplitPosParam {
private Integer returnValue;
private String positionNo;
private String positionPrefix;
private Integer positionNum;
private String positionSuffix;
public Integer getReturnValue() {
return returnValue;
}
public void setReturnValue(Integer returnValue) {
this.returnValue = returnValue;
}
public String getPositionNo() {
return positionNo;
}
public void setPositionNo(String positionNo) {
this.positionNo = positionNo;
}
public String getPositionPrefix() {
return positionPrefix;
}
public void setPositionPrefix(String positionPrefix) {
this.positionPrefix = positionPrefix;
}
public Integer getPositionNum() {
return positionNum;
}
public void setPositionNum(Integer positionNum) {
this.positionNum = positionNum;
}
public String getPositionSuffix() {
return positionSuffix;
}
public void setPositionSuffix(String positionSuffix) {
this.positionSuffix = positionSuffix;
}
}
> Stored procedure call with out parameters throws exception (worked in 2.0.9b)
> -----------------------------------------------------------------------------
>
> Key: IBATIS-149
> URL: http://issues.apache.org/jira/browse/IBATIS-149
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Versions: 2.1.0
> Environment: Oracle 9iR2, Spring 1.1.5, DBCP 1.2.1
> Reporter: Nilesh Kapadia
>
> I have a stored procedure that has out parameters:
> <parameterMap id="displaceSplitPosParameterMap"
> class="com.mycompany.ws.common.data.DisplaceSplitPosParam">
> <parameter property="returnValue" jdbcType="INTEGER"
> javaType="java.lang.Integer" mode="OUT"/>
> <parameter property="positionNo" jdbcType="VARCHAR"
> javaType="java.lang.String" mode="IN"/>
> <parameter property="positionPrefix" jdbcType="VARCHAR"
> javaType="java.lang.String" mode="OUT"/>
> <parameter property="positionNum" jdbcType="INTEGER"
> javaType="java.lang.Integer" mode="OUT"/>
> <parameter property="positionSuffix" jdbcType="VARCHAR"
> javaType="java.lang.String" mode="OUT"/>
> </parameterMap>
>
> <procedure id="callDisplaceSplitPos"
> parameterMap="displaceSplitPosParameterMap">
> {?= call DISPLACE.SPLIT_POS(?, ?, ?, ? )}
> </procedure>
> When I call it (in this case, a JUnit test), it throws an exception with this
> stack trace:
> org.springframework.jdbc.UncategorizedSQLException: (SqlMapClient operation):
> encountered SQLException [
> --- The error occurred in com/mycompany/ws/dao/ibatis/map/Displace.xml.
> --- The error occurred while applying a parameter map.
> --- Check the Displace.displaceSplitPosParameterMap.
> --- Check the output parameters (retrieval of output parameters failed).
> --- Cause: java.lang.NullPointerException]; nested exception is
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in com/mycompany/ws/dao/ibatis/map/Displace.xml.
> --- The error occurred while applying a parameter map.
> --- Check the Displace.displaceSplitPosParameterMap.
> --- Check the output parameters (retrieval of output parameters failed).
> --- Cause: java.lang.NullPointerException
> com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in com/mycompany/ws/dao/ibatis/map/Displace.xml.
> --- The error occurred while applying a parameter map.
> --- Check the Displace.displaceSplitPosParameterMap.
> --- Check the output parameters (retrieval of output parameters failed).
> --- Cause: java.lang.NullPointerException
> Caused by: java.lang.NullPointerException
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:184)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:100)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:97)
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:207)
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:165)
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:205)
> at com.mycompany. < I cut out part of the stack trace here >
> Caused by: java.lang.NullPointerException
> 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:585)
> at
> com.ibatis.common.jdbc.logging.ResultSetLogProxy.invoke(ResultSetLogProxy.java:47)
> at $Proxy46.close(Unknown Source)
> at
> com.ibatis.sqlmap.engine.execution.SqlExecutor.closeResultSet(SqlExecutor.java:392)
> at
> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure(SqlExecutor.java:298)
> at
> com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:34)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:169)
> ... 39 more
> The Java code used to call:
> public DisplaceSplitPosParam callDisplaceSplitPos(String positionNo) {
> DisplaceSplitPosParam param = new DisplaceSplitPosParam();
> param.setPositionNo(positionNo);
> queryForObject("callDisplaceSplitPos", param);
> return param;
> }
>
> This worked flawlessly in 2.0.9b, but when switching to 2.1.0 it fails. This
> is for an Oracle 9iR2 database. I am using Spring 1.1.5's iBatis support.
> DBCP 1.2.1 is being used in this test.
--
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
