Return-Path: 
 <ibatis-user-java-return-1601-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 89317 invoked from network); 25 Mar 2005 15:34:41 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 25 Mar 2005 15:34:41 -0000
Received: (qmail 63955 invoked by uid 500); 25 Mar 2005 15:34:40 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 63939 invoked by uid 500); 25 Mar 2005 15:34:40 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 63924 invoked by uid 99); 25 Mar 2005 15:34:40 -0000
X-ASF-Spam-Status: No, hits=1.8 required=10.0
	tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST
X-Spam-Check-By: apache.org
Received-SPF: neutral (hermes.apache.org: local policy)
Received: from web12824.mail.yahoo.com (HELO web12824.mail.yahoo.com)
 (216.136.174.205)
  by apache.org (qpsmtpd/0.28) with SMTP; Fri, 25 Mar 2005 07:34:38 -0800
Received: (qmail 67193 invoked by uid 60001); 25 Mar 2005 15:34:35 -0000
Message-ID: <20050325153435.67191.qmail@web12824.mail.yahoo.com>
Received: from [64.80.249.226] by web12824.mail.yahoo.com via HTTP;
 Fri, 25 Mar 2005 07:34:35 PST
Date: Fri, 25 Mar 2005 07:34:35 -0800 (PST)
From: Karen Koch <kmkoch@sbcglobal.net>
Subject: Re: Integer to Boolean conversion is opposite from expected behavior
To: ibatis-user-java@incubator.apache.org
In-Reply-To: 6667
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Having 0 = true seems to me to be the opposite of what I would ever expect...

--- Mike Zatko <mzatko@boscovs.com> wrote:
> I have a db table that has a field that has a SMALLINT datatype. This 
> field is being used as a true/false flag. 0 would be true, anything else 
> would be false as would typically happen in C. I set up a result map 
> that looks like the following:
> 
>     <resultMap id="getBenefitAppliesMap" 
> class="com.boscovs.commerce.promotion.dao.benefit.apply.BenefitApplyDAO">
>         <result property="totalOrderOn" column="TOTAL_ORDER_ON" 
> jdbcType="SMALLINT" javaType="java.lang.Boolean" nullValue="false"/>
>     </resultMap>
> 
> I was thrilled that it worked, but the results were opposite of what I 
> expected. A '0' value would denote false, while anything else was true. 
> Anybody know whats going on?
> 
> -- 
> Michael H. Zatko
> Java Enterprise Developer
> Boscov's Information Services
> Work: 610-929-7317
> Home: 610-376-1624
> Page: 610-736-4460
> 
>