Return-Path: 
 <dev-return-1500-apmail-ibatis-dev-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-dev-archive@www.apache.org
Received: (qmail 81210 invoked from network); 25 Jun 2005 04:48:02 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 25 Jun 2005 04:48:02 -0000
Received: (qmail 49257 invoked by uid 500); 25 Jun 2005 04:48:02 -0000
Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org
Received: (qmail 49168 invoked by uid 500); 25 Jun 2005 04:48:01 -0000
Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@ibatis.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@ibatis.apache.org>
List-Post: <mailto:dev@ibatis.apache.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: dev@ibatis.apache.org
Delivered-To: mailing list dev@ibatis.apache.org
Received: (qmail 49155 invoked by uid 500); 25 Jun 2005 04:48:01 -0000
Delivered-To: apmail-incubator-ibatis-dev@incubator.apache.org
Received: (qmail 49152 invoked by uid 99); 25 Jun 2005 04:48:01 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received: from [192.87.106.226] (HELO ajax.apache.org) (192.87.106.226)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 24 Jun 2005 21:48:01 -0700
Received: from ajax.apache.org (ajax.apache.org [127.0.0.1])
	by ajax.apache.org (Postfix) with ESMTP id 6AB9215
	for <ibatis-dev@incubator.apache.org>; Sat, 25 Jun 2005 06:48:00 +0200 (CEST)
Message-ID: <887952271.1119674880355.JavaMail.jira@ajax.apache.org>
Date: Sat, 25 Jun 2005 06:48:00 +0200 (CEST)
From: "Clinton Begin (JIRA)" <ibatis-dev@incubator.apache.org>
To: ibatis-dev@incubator.apache.org
Subject: [jira] Closed: (IBATIS-149) Stored procedure call with out parameters
 throws exception (worked in 2.0.9b)
In-Reply-To: <1630216185.1118410786615.JavaMail.jira@ajax.apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

     [ http://issues.apache.org/jira/browse/IBATIS-149?page=all ]
     
Clinton Begin closed IBATIS-149:
--------------------------------

    Fix Version: 2.1.5
     Resolution: Fixed
      Assign To: Clinton Begin

Fixed as described by Sven in IBATIS-152.

> 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
>     Assignee: Clinton Begin
>      Fix For: 2.1.5

>
> 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