ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vadboss <vadb...@gmail.com>
Subject Re: IBatis: boolean mapping misunderstanding
Date Mon, 03 May 2010 11:59:43 GMT

It's IBatis 3.

Here is the statement:
<select id="selectByUsernameAndPassword" parameterType="domain.ClockUser"
		resultType="domain.ClockUser">
		SELECT users.id, users.username, users.password,
		MAX(clock_operations.date) as lastActionDate,
		clock_operations.clock_in as clockedIn
		FROM users,
		clock_operations
		WHERE users.id=clock_operations.user_id AND users.username=#{username}
		AND users.password=#{password};
</select>



Larry Meadors wrote:
> 
> Maybe with some info.
> 
> Using ibatis2 or 3?
> 
> Can you provide your mapped statement?
> 
> Throw us a bone here. :P
> 
> Larry
> 
> 
> On Mon, May 3, 2010 at 3:09 AM, vadboss <vadboss@gmail.com> wrote:
>>
>> I have in the table a boolean (tinyint(1)) value. I don't know why, but
>> ibatis always gets it as true, whether it is 0, or 1 in database.
>>
>> Who knows what is the cause?
>> --
>> View this message in context:
>> http://old.nabble.com/IBatis%3A-boolean-mapping-misunderstanding-tp28432952p28432952.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> 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
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/IBatis%3A-boolean-mapping-misunderstanding-tp28432952p28434308.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


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


Mime
View raw message