Return-Path: 
 <dev-return-2230-apmail-ibatis-dev-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-dev-archive@www.apache.org
Received: (qmail 57198 invoked from network); 18 Dec 2005 15:55:59 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 18 Dec 2005 15:55:59 -0000
Received: (qmail 14385 invoked by uid 500); 18 Dec 2005 15:55:59 -0000
Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org
Received: (qmail 14274 invoked by uid 500); 18 Dec 2005 15:55:58 -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 14263 invoked by uid 500); 18 Dec 2005 15:55:58 -0000
Delivered-To: apmail-incubator-ibatis-dev@incubator.apache.org
Received: (qmail 14260 invoked by uid 99); 18 Dec 2005 15:55:58 -0000
X-ASF-Spam-Status: No, hits=1.3 required=10.0
	tests=SPF_FAIL
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; Sun, 18 Dec 2005 07:55:57 -0800
Received: from ajax.apache.org (ajax.apache.org [127.0.0.1])
	by ajax.apache.org (Postfix) with ESMTP id C1367E0
	for <ibatis-dev@incubator.apache.org>; Sun, 18 Dec 2005 16:55:36 +0100 (CET)
Message-ID: <650240619.1134921336789.JavaMail.jira@ajax.apache.org>
Date: Sun, 18 Dec 2005 16:55:36 +0100 (CET)
From: "Clinton Begin (JIRA)" <ibatis-dev@incubator.apache.org>
To: ibatis-dev@incubator.apache.org
Subject: [jira] Commented: (IBATIS-232) String input parameter is not working
 in web sphere. When the stored procedure accessed through JNDI.
In-Reply-To: <1350355205.1134425985140.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-232?page=comments#action_12360736 ] 

Clinton Begin commented on IBATIS-232:
--------------------------------------


PS:  I did notice that the stack trace you posted was incomplete.  Feel free to post the rest of it here, just in case there's something we missed.

> String input parameter is not working in web sphere. When the stored procedure accessed through JNDI.
> -----------------------------------------------------------------------------------------------------
>
>          Key: IBATIS-232
>          URL: http://issues.apache.org/jira/browse/IBATIS-232
>      Project: iBatis for Java
>         Type: Bug
>   Components: SQL Maps
>     Versions: 2.1.5
>  Environment: Web Sphere Portal 5.01, iBatis 2.1.5 and Oracle 9
>     Reporter: Sathiya Shanmugam
>     Assignee: Clinton Begin
>      Fix For: 2.2.0

>
> Java Source code:
> **********************************************************
> Map map = new HashMap();
> map.put("input1","S12345");
> sqlMap.queryForObject("acctupd", map);
> System.out.println("Output message >>> " + map.get("msg"));
> **********************************************************
> <parameterMap id="acctupd"  class="map" >
> 	<parameter property="input1"            jdbcType="VARCHAR" 	javaType="java.lang.String" mode="IN"/>
> 	<parameter property="msg" 	 jdbcType="VARCHAR"  	javaType="java.lang.String" mode="OUT"/>	
> </parameterMap>
> <procedure id="acctupd" parameterMap = "acctupd">
> 	{ call temp_secss2.GetEmpRS2(?,?)}
> </procedure>
> ***********************************************************
> The above code is not working for update, queryForList and queryForObject when i use JNDI connection. It is working fine with XML datasource connection details.
> JNDI
> <sqlMapConfig>
> 	<settings cacheModelsEnabled="true" enhancementEnabled="true" maxSessions="64" maxTransactions="8" maxRequests="128" />
>   	<transactionManager type="JDBC">
> 		<dataSource type="JNDI">
>   			<property value="jdbc/ds2" name="DataSource"/>
> 	    </dataSource>
> 	</transactionManager>
> 	<!-- Identify all SQL Map XML files to be loaded by this SQL map. --> 
> 	<sqlMap resource="com/jpmc/fcg/framework/daoxml/sqlmappingxml/accountupdatesqlmap.xml"/>
> </sqlMapConfig>
> *****************************************
> <sqlMapConfig>
> 	<properties resource="test/SqlMapConfig.properties"/>
>   	<settings cacheModelsEnabled="true"
>     	enhancementEnabled="true"
>     	lazyLoadingEnabled="true" maxRequests="32"
>     	maxSessions="10" maxTransactions="5"
>     	useStatementNamespaces="false" />
> 	<transactionManager type="JDBC" commitRequired="true">
> 		<dataSource type="SIMPLE">
> 			<property name="JDBC.Driver" value="${driver}"/>
> 			<property name="JDBC.ConnectionURL" value="${url}"/>
> 			<property name="JDBC.Username" value="${username}"/>
> 			<property name="JDBC.Password" value="${password}"/>
> 		</dataSource>
> 	</transactionManager>
> 	
> 	<sqlMap resource="test/Account.xml"/>
> </sqlMapConfig>
> ********************************************************************************************************************************
> Error Details..
> --- The error occurred in com/jpmc/fcg/framework/daoxml/sqlmappingxml/accountupdatesqlmap.xml.  
> --- The error occurred while applying a parameter map.  
> --- Check the acctupd.  
> --- Check the parameter mapping for the 'input1' property.  
> --- Cause: java.lang.NullPointerException
> Caused by: java.lang.NullPointerException
> Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
> --- The error occurred in com/jpmc/fcg/framework/daoxml/sqlmappingxml/accountupdatesqlmap.xml.  
> --- The error occurred while applying a parameter map.  
> --- Check the acctupd.  
> --- Check the parameter mapping for the 'input1' property.  
> --- Cause: java.lang.NullPointerException
> Caused by: java.lang.NullPointerException
> [12/12/05 17:16:26:516 EST] 722baf69 SystemErr     R com.ibatis.dao.client.DaoException: Failed to update - id [acctupd] - parameterObject [{input1=S12345}].  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:   
> --- The error occurred in com/jpmc/fcg/framework/daoxml/sqlmappingxml/accountupdatesqlmap.xml.  
> --- The error occurred while applying a parameter map.  
> --- Check the acctupd.  
> --- Check the parameter mapping for the 'input1' property.  
> --- Cause: java.lang.NullPointerException
> Caused by: java.lang.NullPointerException
> Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
> --- The error occurred in com/jpmc/fcg/framework/daoxml/sqlmappingxml/accountupdatesqlmap.xml.  
> --- The error occurred while applying a parameter map.  
> --- Check the acctupd.  
> --- Check the parameter mapping for the 'input1' property.  
> --- Cause: java.lang.NullPointerException
> Caused by: 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