IBatis: boolean mapping misunderstanding

[Vadim Vararu]

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?

[David Newton]

How did you map it?

[Vadim Vararu]

Here is the code:

package domain;

import java.util.Date;

public class ClockUser {

        private int id;
        private String username;
        private String password;
        private boolean clockedIn;
        private Date lastActionDate;

        public ClockUser() {
                lastActionDate = new Date();
        }

        public ClockUser(String username, String password) {
                this();
                this.username = username;
                this.password = password;
        }

        public ClockUser(int id, String username, String password,
                        boolean clockedIn, Date lastActionDate) {
                this.id = id;
                this.username = username;
                this.password = password;
                this.clockedIn = clockedIn;
                this.lastActionDate = lastActionDate;
        }

        public void resetLastActionDateToCurrent() {
                lastActionDate = new Date();
        }

        public int getId() {
                return id;
        }

        public void setId(int id) {
                this.id = id;
        }

        public String getUsername() {
                return username;
        }

        public void setUsername(String username) {
                this.username = username;
        }

        public String getPassword() {
                return password;
        }

        public void setPassword(String password) {
                this.password = password;
        }

        public boolean isClockedIn() {
                return clockedIn;
        }

        public void setClockedIn(boolean clockedIn) {
                this.clockedIn = clockedIn;
        }

        public Date getLastActionDate() {
                return lastActionDate;
        }

        public void setLastActionDate(Date lastActionDate) {
                this.lastActionDate = lastActionDate;
        }
} 

    
<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>