Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Content-Type: text/plain; charset=utf-8; format=flowed; delsp=yes
To: user-java@ibatis.apache.org
Subject: Re: ibatis 3 COUNT -> Boolean
References: <26156026.post@talk.nabble.com>
 <145103.48797.qm@web50710.mail.re2.yahoo.com>
 <22B9BBA00A312C4FA4D015127DD6E41E05546567@exchange-sm.BWINC.local>
Date: Wed, 04 Nov 2009 20:43:42 +0100
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: "Johannes Klose" <lists@calitrix.de>
Message-ID: <op.u2vydeq71apf6z@jk>
In-Reply-To: 
 <22B9BBA00A312C4FA4D015127DD6E41E05546567@exchange-sm.BWINC.local>
User-Agent: Opera Mail/10.01 (Linux)

You could just modify the query to return a boolean value to avoid  
conversion issues. For example:
	SELECT IF(COUNT(username)>0,true,false) FROM record WHERE ...


Am 04.11.2009, 19:42 Uhr, schrieb Douglas Bell <DBell@boingo.com>:

> I'm trying to do the following using beta 5 (this was working in beta 3)
>
> @Select("SELECT COUNT(username) FROM record WHERE username =
> #{username,jdbcType=VARCHAR}")
> Boolean isExisting(String username);
>
> I get a ClassCastException: java.lang.Long cannot be cast to
> java.lang.Boolean which is understandable.
>
> I thought adding a @Result(javaType = Boolean.class) would do it but I
> still get the same error. Can I do anything short of changing the return
> type to a Long and doing the conversion?
>
> Thanks
>
> -Doug
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org