Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 29623 invoked from network); 26 Jul 2005 21:04:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 26 Jul 2005 21:04:28 -0000 Received: (qmail 59610 invoked by uid 500); 26 Jul 2005 21:04:27 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 59588 invoked by uid 500); 26 Jul 2005 21:04:26 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 59574 invoked by uid 99); 26 Jul 2005 21:04:26 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Jul 2005 14:04:26 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [206.190.49.61] (HELO web53111.mail.yahoo.com) (206.190.49.61) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 26 Jul 2005 14:04:18 -0700 Received: (qmail 62460 invoked by uid 60001); 26 Jul 2005 21:04:22 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=pKwjKSKC7Q+OO5wLQw6edh9uRaAz4HoeY2buZVj3qdIMH1iuMGgJQz9oCaMtBKGiiUv4MiJkD6AqoevUyKh4KyL+bwnpvjG4OyJ0lOUHD2ldqdsud4I8vIud59lqUJ36QrzQ2HSQA7LY3SIaqvyXMUtIfaafZ3qYbLIAFYCpdOo= ; Message-ID: <20050726210422.62458.qmail@web53111.mail.yahoo.com> Received: from [20.137.2.51] by web53111.mail.yahoo.com via HTTP; Tue, 26 Jul 2005 14:04:22 PDT Date: Tue, 26 Jul 2005 14:04:22 -0700 (PDT) From: Prashanth Sukumaran Subject: Re: QueryForObject returns wrong data To: user-java@ibatis.apache.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi Shilpa, Just in case, have you defined the bean variable as int/integer by mistake. Rgds Prashanth. --- shilpa wrote: > Hi, > > It may sound little strange, but I am getting wrong data back when I call > QueryForObject( ) method and try to get firld of Decimal data type. > > e.g > I am calling this method by passing financialStatus as object. > > sqlMap.queryForObject("selectFinancialInfo",finStatus); > > I am using Stored Procedures to retrieve data from DB2. > > I have a field in table 'SocialSecurity' with value 99.44 > > but when I execute > > sqlMap.queryForObject("selectFinancialInfo",finStatus); > > and call finStatus.getSocialSecurity(); > its just returning me 99 and not 99.44 > > My stored procedure is not returning a ResultSet but everything in OUT > parameters. > > Same procedure works fine with normal JDBC code. (returns 99.44) > > Can you please guide me, where I am doing wrong. > > Thanks, > shilpa > > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com